Split Text or string by new line and space at once

How to split string by both space and new line

abc 123 pqr
efg ijk etc…

i want output as in list as

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

welcome to the forum

give try at:

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

1 Like

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

thank you @ppr for quick response.

perfect, once it is working close the topic by: