Split datatable.row into a list of string

Help
1

Hi,

I have a variable that i want to split into several string
In a for each row, i print the result in a message box which is “row(2).tostring”

This variable is like “a,b,c” and i wanted to separate a,b and c

How can i do that ?

Thanks,

2

yah the expression would be like this
Split(row(2).ToString)(0)+“,”+Split(row(2).ToString)(1)+"and "+Split(row(2).ToString)(2)

Cheers @Pierre_PARIS

4

Hi,

Can you try the following?

resultStrArray = System.Text.RegularExpressions.Regex.Split(strData,"(?<=.+?,.+?),")

Regards,

5

Can use Assign activity
Create a String variable ex:str1
In assign activity
str1 = datarow.itemarray.tostring
Now create another string Array ex:starArray
StrArray = str1.split(“,”.Tochararray)

This StrArray is having strings separated by Comma

1 Like