How can we convert string into a list/ Array?

[anjasing (Anjali)]

I’ve input as below mentioned and these are SAP systems…but I want to make all these into a list of array which ever is best to work with…

Input: VD1, QO4, TO2, VQ1, QO1, TO1
Output should be a array/list of:
VD1
QO4
TO2
VQ1
QO1
TO1

So that I can further work on each system.

[ppr (Peter Preuss)]

@anjasing

VD1, QO4, TO2, VQ1, QO1, TO1

Along with trimming:

YourString.Split({","c}, StringSplitOptions.RemoveEmptyEntries).select(Function (x) x.trim).tolist

[mosa_sleeman (Mousa Suleiman)]

Hello @anjasing
Here we go

[anjasing (Anjali)]

Thank you so much…for my process array would be better…

[anjasing (Anjali)]

Thank you…

[ppr (Peter Preuss)]

@ppr

YourString.Split({","c}, StringSplitOptions.RemoveEmptyEntries).select(Function (x) x.trim).tolist

in such case we just change from toList to toArray: