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?stackoverflow.com/questions/70405/… — Andrew Shepherd
– Andrew Shepherd, Commented Apr 14, 2014 at 6:40
I'd rather parse this input string using a state-machine, it would be a lot faster and consume less memory. — Dai
– Dai, Commented Apr 14, 2014 at 6:40
Without LINQ, you can use String.Split() method like String.Split(new char[] {'|', ';'}, StringSplitOptions.RemoveEmptyEntries); — Soner Gönül
– Soner Gönül, Commented Apr 14, 2014 at 6: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
– Panagiotis Kanavos, Commented Apr 14, 2014 at 6:48

DarkWanderer · Accepted Answer · 2019-02-15 21:01:41Z

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, 2019 at 21:01

answered Apr 14, 2014 at 6:46

DarkWanderer

8,8751 gold badge30 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Muhammad Umar · Accepted Answer · 2014-04-14 06:43:46Z

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, 2014 at 6:43

Muhammad Umar

3,7811 gold badge26 silver badges36 bronze badges

Comments

zellus · Accepted Answer · 2020-08-21 07:30:19Z

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, 2020 at 7:30

zellus

9,5825 gold badges41 silver badges58 bronze badges

answered Apr 14, 2014 at 8:23

user3530886

1

Comments

tl simo · Accepted Answer · 2021-02-05 10:49:22Z

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 5, 2021 at 10:49

tl simo

11 bronze badge

2 Comments

Amit Verma Over a year ago

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.

General Grievance Over a year ago

Why not just use string.Join again instead of foreach?

Collectives™ on Stack Overflow

How to split a string using LINQ

4 Answers 4

Comments

Comments

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

2 Comments

Linked

Related