Split Text or string by new line and space at once

Help Studio
, ,
1

How to split string by both space and new line

eg.
abc 123 pqr
efg ijk etc…

i want output as in list as
[abc,123,pqr,efg,ijk]

currently i am using asSplit(newstring1.tostring,“ ”)
but this gives me output as
[abc,123,pqr \n efg,ijk]

2

@tejaswini.pratapwar
welcome to the forum

give try at:

YourStringVar.Split({vbCr, vbLf," "}, StringSplitOptions.RemoveEmptyEntries)

1 Like
3

Just Replace the newlines (VBCRLF) with empty string to get rid of them, then split on space.

4

thank you @ppr for quick response.

5

perfect, once it is working close the topic by: