Split a a string based on new line

[Gaurav_Bahuguna]

how to split a astring based on new line
input -
abc
ert
4234
asd

I want to split this and save in 4 separate variables

[pattyricarte (Patty Boy)]

You can try this code. @Gaurav_Bahuguna

str.Split(CChar(vbCrLf ))

cheers

Happy learning

[nadim.warsi]

A note here is that when you split the string you will automatically get a array of the strings which you can simple access using the index 0…3.
Now you can choose to assign then individually to new 4 variables or you can use them using their array index.

[Gaurav_Bahuguna]

not working
this is the data in excel cell

I am using this but not working

[nadim.warsi]

try:
yourString.Split(Environment.NewLine.TocharArray)

[pattyricarte (Patty Boy)]

i think the delimited of this is new line right,can you replace the new line with another delimited and from then assign it to array i hope it make sense @Gaurav_Bahuguna

cheers

Happy learning