Split string that includes multiline substrings into substrings

Asked Dec 11 '17 at 10:31

Active Dec 11 '17 at 10:36

Viewed 62 times

How can I split a string that may contain substrings that carry on to multiple lines into an array of strings by lines?

For example,

"1234","01",111,AreaA,10/10/2017 11:13:10,
    1,10/09/2017 18:45:00,23296151,"JOHN","- 11/09/2017 18:45:19  U JOHN 0036
  CONFIRMED",
    2,11/09/2017 14:25:00,23296151,"BECCA","- 11/09/2017 15:45:19  U BECCA 0036
  CONFIRMED",

Current code:

        string[] stringSeparators = { "\r\n" };
        string[] lines = auditMessage.Split(stringSeparators, StringSplitOptions.None);

Returns:

""1234","01",111,AreaA,10/10/2017 11:13:10,"
"       1,10/09/2017 18:45:00,23296151,"JOHN","- 11/09/2017 18:45:19  U JOHN 0036"
"      CONFIRMED","
"       2,11/09/2017 14:25:00,23296151,"BECCA","- 11/09/2017 15:45:19  U BECCA 0036"
"      CONFIRMED","

What I would like to be returned:

""1234","01",111,AreaA,10/10/2017 11:13:10,"
"       1,10/09/2017 18:45:00,23296151,"JOHN","- 11/09/2017 18:45:19  U JOHN 0036 CONFIRMED","
"       2,11/09/2017 14:25:00,23296151,"BECCA","- 11/09/2017 15:45:19  U BECCA 0036 CONFIRMED","

edited Dec 11 '17 at 10:36

asked Dec 11 '17 at 10:31

Bhav

1,957
7
33
66

4

What is the value of `stringSeparators`? – stuartd Dec 11 '17 at 10:32
what is value for stringseparators – Pranay Rana Dec 11 '17 at 10:32
1

Would splitting on `,` be a possibility? – Jerodev Dec 11 '17 at 10:33
is that multipline string is sperated by new line character ...doent seems like that – Pranay Rana Dec 11 '17 at 10:34
Try splitting on `",\n"` and then remove all `\n` from your strings – Markiian Benovskyi Dec 11 '17 at 10:35
@stuartd I've updated the OP – Bhav Dec 11 '17 at 10:37
how do you fit your input into a variable? – Ray Krungkaew Dec 11 '17 at 10:40
If confirmed/unconfirmed is the last word in each record, then you can split your string by it. – hustlecoder Dec 11 '17 at 10:41

Split string that includes multiline substrings into substrings

0 Answers0