How to separate these words using data manipulation

How to separate these words

Hi @Akash_Bawankar
You can try regex

let’s say u had the word stored in data_in

Now use the below assign activity

data_array = System.Text.RegularExpressions.Regex.Matches(data_in,"\w+").Cast(Of Match).Select(Function(e) e.Value.ToString).ToArray()

data_array should be String datatype

Regards,
Nived N

@Akash_Bawankar - If you would like split using comma, then you can try this…

image

Hi @Akash_Bawankar ,

If you want to split it from space you can use this.
test.xaml (6.5 KB)

Thanks all

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.