.Split() Function

Hi Caroline, 

Please try the following

dim myString as string;
myString = "ID|Name|Qty1|Qty2";

dim delimstr as string;
dim stringsplit[4] as string;
dim split[1] as System.Char;
delimstr = "|"; 
split = delimstr.ToCharArray();
stringsplit = myString.Split(split);

LogMessage("value on position 1: "+stringsplit[1]);
LogMessage("value on position 2: "+stringsplit[2]);
LogMessage("value on position 3: "+stringsplit[3]);
LogMessage("value on position 4: "+stringsplit[4]);

The result should be 

Here is a simpler version because why not?

dim MyString as string;
MyString = "ID|Name|Qty1|Qty2";

dim StringSplit[4] as string;
StringSplit = MyString.Split("|".ToCharArray()[1]);

LogMessage("value on position 1: "+StringSplit[1]);
LogMessage("value on position 2: "+StringSplit[2]);
LogMessage("value on position 3: "+StringSplit[3]);
LogMessage("value on position 4: "+StringSplit[4]);

If you lack forehand knowledge of the length of the resulting array, you can simply make an implicit declaration like this:.

dim myArray = delimitedText.Split("|".ToCharArray());

Building on Richard's example, something like this will likely work:

dim s as string;
for each s in delimitedText.Split("|".ToCharArray());
    LogMessage(s);
end for;

That said, myArray may turn out as a zero-indexed .NET array as opposed to the 1-indexed QuickScript arrays. Just because it would be too easy if they were just the same.