Forum Discussion

funmay's avatar
funmay
Contributor
8 years ago

How to put specify multiple List separator in a function

Hi, How can i pass multiple list separation  e.g comma[","] vertical line["|"] within a function to handle any parameter passed with any list separator.   See my eaxmple below,but i am not gett...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
8 years ago

So... what's not working?  You don't clarify what errors or problems you running into.  It would be helpful to understand where the problem is.

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    8 years ago

    After I posted that, I tried it out... and yeah, it's not working... but that's because you have your logic incorrect.

    aqString.Contains returns the position of the first instance of the desired substring.  IF it doesn't find the string, it returns -1.  So... change your logic to the following

     

    function TextString(array)
{ 
if(aqString["Contains"](array,",") != -1)
{
aqString["ListSeparator"] = ','
}
else if (aqString["Contains"](array,"|") != -1){
aqString["ListSeparator"] = '|'
}
/*Get the value of the first number*/
var FirstStringTobeginLooping = aqString["GetListItem"](array,0);
}