Can I write a LINQ query to parse string

Question

I have a string like this:

A00601  CALLE FCO PIETRI   CALLE FRANCISCO PIETRI            A20040407

Is there a way to replace this code:

foreach (var line in parsedList)
{
     if((line[0] == 'D') && (line[55] == 'Y'))
     {
         item.PostalCode5 = line.Substring(1, 5);
         item.PreferredCityName28 = line.Substring(13,28);
          ...
      }
 }

With a LINQ query like this:

foreach (var line in parsedList)
{
     item.PostalCode5(line.Substring(1, 5)),
     item.PreferredCityName28(line.Substring(13,28))
     ...
     .Where (line[0] == 'D' &&  line[55] == 'Y')
 }

are those fixed-width columns or delimited by whitespace?

clarkitect
– clarkitect

2016-03-10 21:28:23 +00:00
Commented Mar 10, 2016 at 21:28 — clarkitect
– clarkitect, Commented Mar 10, 2016 at 21:28
You could at least show a sample line that starts with D

Eser
– Eser

2016-03-10 21:28:27 +00:00
Commented Mar 10, 2016 at 21:28 — Eser
– Eser, Commented Mar 10, 2016 at 21:28

clarkitect · Accepted Answer · 2016-03-10 21:47:39Z

2

parsedList
    .Where(line => line[0]== 'D' && line[55] = 'Y')
    .Select(itm => new Item {
        PostalCode5 = line.Substring(1, 5), 
        PreferredCityName28 = line.Substring(13,28)
    });

edited Mar 10, 2016 at 21:47

clarkitect

1,73014 silver badges23 bronze badges

answered Mar 10, 2016 at 21:28

Ashkan Mobayen Khiabani

34.3k35 gold badges111 silver badges187 bronze badges

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

Comments

Lux · Accepted Answer · 2016-03-10 23:03:02Z

1

You can do this:

parsedList.Where(line => line[0]== 'D' && line[55] = 'Y')
  .ToList()
  .ForEach(line => {
    item.PostalCode5(line.Substring(1, 5)),
    item.PreferredCityName28(line.Substring(13,28))
  });

Which is identical to your code.

answered Mar 10, 2016 at 23:03

Lux

18.3k5 gold badges48 silver badges77 bronze badges

Collectives™ on Stack Overflow

Can I write a LINQ query to parse string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related