LINQ - Convert to String LIST and Replace Characters

Question

I have a dataset that is returned from a stored procedure that I save into a string LIST.

So far this is what I have and it's working correctly:

 this.UserOrgs = ds.Tables[0].AsEnumerable()
           .Select(r => r.Field<string>(0))
                            .ToList();

However, I also need to replace all "X" with "Y" in the returned values before I put them into the list.

I guess my question is, can I do it all at one time using LINQ? Or should I replace the characters in the dataset before I convert it into a list?

Jon Skeet · Accepted Answer · 2013-02-26 20:21:22Z

6

Sure, it's easy to do this - you don't even need another call:

this.UserOrgs = ds.Tables[0].AsEnumerable()
                            .Select(r => r.Field<string>(0).Replace("X", "Y"))
                            .ToList();

answered Feb 26, 2013 at 20:21

Jon Skeet

1.5m892 gold badges9.3k silver badges9.3k bronze badges

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

1 Comment

Madam Zu Zu Over a year ago

puuurfect, thanks! can i trim the YYYYY that i now have at the end. the resulting (2345-YYYYY, i want to display as: 2345-Y, if i use .TrimEnd("Y") it takes out ALL "Y"s and i just have 2345-

SoftwareSprint · Accepted Answer · 2013-02-26 20:33:28Z

0

var chars = new[] { "X", "Y" };
EnumerableRowCollection<string> enumerableRowCollection = dataTable.AsEnumerable().Select(r => chars.Aggregate(r.Field<string>(0), (s, s1) => s.Replace(s1, string.Empty)));

The above answer will replace all X's and all Y's.

At least anything that you put in the char array

answered Feb 26, 2013 at 20:33

SoftwareSprint

212 bronze badges

Collectives™ on Stack Overflow

LINQ - Convert to String LIST and Replace Characters

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related