String Manipulations

[prasanna.Ui (prasanna)]

Hi ,
Below is my string Text_NameAndAddress.

Text_NameAndAddress=“Date -1/12/2019 \r\nTom Hanks \r\n789 Broad Street \r\nPeoria, IL 61615 \r\n”
I want to split my data with ‘\r\n’ by using below syntax.
Text_NameAndAddress.Split({vbCr,vbLf},StringSplitOptions.None)

I am getting data in the below format but why i am getting extra “” quotes how to
string[9]
{
"Date -1/12/2019 ",
“”,
"Tom Hanks ",
“”,
"789 Broad Street ",
“”,
"Peoria,
IL 61615 ",
“”,
“”
}

I want split at a time with ‘\r\n’.

[codemonkee (Tim)]

@prasanna.Ui

…

Text_NameAndAddress="Date -1/12/2019 \r\nTom Hanks \r\n789 Broad Street \r\nPeoria, IL 61615 \r\n"

I want to split my data with ‘\r\n’ by using below syntax.

Text_NameAndAddress.Split({vbCr,vbLf},StringSplitOptions.None)

… why i am getting extra "" quotes

string[9] 
{
  "Date -1/12/2019 ",
  "",
  "Tom Hanks ",
  "",
  "789 Broad Street ",
  "",
  "Peoria,
  IL 61615 ",
  "",
  "" 
}

This is due to using vbCr and vbLf seperately, it is using both characters to split the text on. Instead split using a \r\n or use vbCrLf to split only once per instance.

Text_NameAndAddress.Split({vbCrLf}, StringSplitOptions.None)

string[5] 
{
  "Date -1/12/2019 ",
  "Tom Hanks ",
  "789 Broad Street ",
  "Peoria,
  IL 61615 ",
  "" 
}

[prasanna.Ui (prasanna)]

Thank you twhitehead.

Issue got resolved.