Unable to split a string with newLine delimiter?

[blacksundar (Shyam Sundar)]

I made a string variable

a =“this is
new line”

but not able to get split it using new line.
I have tried
a.Split(VbCrLf, StringSplitOptions.NONE)

not returning two elements indeed returning full string. why ??

[asesor-rpa (Nestor Andres Martinez)]

have you tested changing vbCrLf with Environment.NewLine?

[lakshman (Ganta lakshman)]

@blacksundar

Try these expressions:

a.split(Environment.NewLine.TocharArray)(0) - this is

a.split(Environment.NewLine.TocharArray)(1) - new line

[blacksundar (Shyam Sundar)]

Okay. I’ll tell u what I’ve used?
VbCrLf,
VbLf,
Environment.NewLine

Now not able to get the required result.

[pathLessTaken (Hose Son)]

@blacksundar try vbNewLine

[blacksundar (Shyam Sundar)]

Sorry I missed that, I have also used that

[pathLessTaken (Hose Son)]

@blacksundar are you splitting using .ToCharArray? Split(vbNewLine.ToCharArray) . Because this is working for me

[amaresan (Amaran)]

Hi @blacksundar

try this

a.Split({vbLf},StringSplitOptions.RemoveEmptyEntries)

[Shiva_Karthik]

Hi @blacksundar,

Please try the below syntax and try once.

a.Split(VBNewline.tocharArray, StringSplitOptions.RemoveEmptyEntries)

Regards,
Shiva Karthik

[blacksundar (Shyam Sundar)]

Thank you all. But I’ll post what didn’t work.

can you all please tell me reasons of all?
a.Split({vbCrLf},StringSplitOptions.RemoveEmptyEntries)
a.Split({Environment.NewLine},StringSplitOptions.RemoveEmptyEntries)
a.Split({VbNewline},StringSplitOptions.RemoveEmptyEntries)
a.Split(VBNewline.tocharArray, StringSplitOptions.RemoveEmptyEntries)

what’s difference between
a.Split({vbNewline}, StringSplitOptions.RemoveEmptyEntries)
and
a.Split(vbNewline.ToCharArray, StringSplitOptions.RemoveEmptyEntries)

[lakshman (Ganta lakshman)]

@blacksundar

Could you please share your Workflow. Will check and update you.

[amaresan (Amaran)]

Hi @blacksundar

vbCrLf - when you have both carriage return(Cr) and Line feed(Lf) in the string
vbCr - Only when Carriage return(Cr) in the string
vbLf - Only when Line feed(Lf) in the string

a.Split({vbNewline}, StringSplitOptions.RemoveEmptyEntries)
and
a.Split(vbNewline.ToCharArray, StringSplitOptions.RemoveEmptyEntries)

both function perform same…

after split(u have to use char )

first one assign as char array method {vbNewline}
next one they convert as char array vbNewline.ToCharArray)

so Respected of function u have to mention within the {} otherwise u have to convert as TocharArray()

thanks…

[blacksundar (Shyam Sundar)]

Hi @amaresan

Thank you so much for your time.
I have tested all methods given in this message.

{}, without{} performed different way. 1st one didn’t split using new line, but second one did…

why is it so?

[lakshman (Ganta lakshman)]

@blacksundar

Split function separates Strings. It receives a string or character delimiter. It parses and separates the source string by separating the parts that come between the delimiter.

[amaresan (Amaran)]

@blacksundar

could you share me the code which is not working… i will explain why not working

[blacksundar (Shyam Sundar)]

it’s output is “1”

it’s output is “2”

[amaresan (Amaran)]

@blacksundar

I’m not sure may it perform like this. You u are give two method is single {} that will consider always one

if u use two Cr and Lf in curly braces u have to give like this samplestring.split({vbCr,VbLf},StringSplitOptions.RemoveEmptyEntries).Length.ToString

otherwise use tocharArray()

i hope it make clear

Regards
Amaresan.P