How to split a string using LINQ

Question

I am using a string to store country code with its cost centre code value . I want to spilit it out the string using LINQ query by | and ; characters. The srting is

IND|001;TWN|002;USA|003;LDN|;MYS|005;

Please help me to spilt out the string value using LINQ

Why not use String.Split?http://stackoverflow.com/questions/70405/does-c-sharp-have-a-string-tokenizer-like-javas — Andrew Shepherd, Apr 14 '14 at 06:40
I'd rather parse this input string using a state-machine, it would be a lot faster and consume less memory. — Dai, Apr 14 '14 at 06:40
Without LINQ, you can use `String.Split()` method like `String.Split(new char[] {'|', ';'}, StringSplitOptions.RemoveEmptyEntries);` — Soner Gönül, Apr 14 '14 at 06:43
String.Split is more than enough for simple cases. Regex can cover most advanced cases. LINQ should be used to handle the output of splitting/parsing, not perform the parsing itself — Panagiotis Kanavos, Apr 14 '14 at 06:48

DarkWanderer · Accepted Answer · 2019-02-15T21:01:41.337

10

I am assuming you need a list of Tuple<string,string> as output.

var myString = "IND|001;TWN|002;USA|003;LDN|;MYS|005;";
var objects = myString.Split(';')
        .Where(x => !string.IsNullOrEmpty(x))
        .Select (x => x.Split('|'))
        .Select (x => Tuple.Create(x[0],x[1]))
        .ToList();

Result:

IND 001 
TWN 002 
USA 003 
LDN
MYS 005

edited Feb 15 '19 at 21:01

answered Apr 14 '14 at 06:46

DarkWanderer

8,739
1
25
56

score 2 · Answer 2 · answered Apr 14 '14 at 06:43

2

Rather then LINQ use String.Split.

string s = "IND|001;TWN|002;USA|003;LDN|;MYS|005;";

string[] splitData = s.Split(new string[] { "|", ";" }, StringSplitOptions.RemoveEmptyEntries);

answered Apr 14 '14 at 06:43

Muhammad Umar

3,761
1
24
36

score 0 · Answer 3 · edited Aug 21 '20 at 07:30

0

You can use this:

string temp= "IND|001;TWN|002;USA|003;LDN|;MYS|005";
IEnumerable<string> returnList = temp.Split(';')
    .Where(g=>!String.IsNullOrEmpty(g))
    .Select(c => c.Substring(0, c.IndexOf('|')) + c.Substring(c.IndexOf('|') + 1));

edited Aug 21 '20 at 07:30

zellus

9,617
5
39
56

answered Apr 14 '14 at 08:23

user3530886

1

score 0 · Answer 4 · answered Feb 05 '21 at 10:49

0

var myString = "IND|001;TWN|002;USA|003;LDN|;MYS|005;";
            var result = from sp in myString.Split(';')
                         let spr = sp.Split('|')
                         select string.Join(" ", spr);
            string append = string.Empty;
            foreach (var item in result)
            {
                append += item + "\n";
            }
            Console.WriteLine(append);

answered Feb 05 '21 at 10:49

tl simo

1
1

1

While this code may provide a solution to the question, it's better to add context as to why/how it works. This can help future users learn and apply that knowledge to their own code. You are also likely to have positive-feedback/upvotes from users, when the code is explained. – Amit Verma Feb 05 '21 at 11:14
Why not just use `string.Join` again instead of `foreach`? – General Grievance Feb 05 '21 at 15:04

How to split a string using LINQ

4 Answers4

Linked

Related