How to replace a string with linq

Question

I have this bit of code that joins 3 tables. In the end, the result is a list of users. The list that is returned usually contains records like "DG3\RONASS", but can also be DG4, DG5, etc. In this case, I'm replacing "DG3\" just to see how it works. How can I make it generic, so that it replaces the backslash and everything before it, without having to specify a string to replace like in this case?

 List<string> journalingUsers = Context.ResourceSetSet
                .Join(Context.ResourceItemJnSet, resourceSet => resourceSet.ID, resourceItemJn => resourceItemJn.ResourceSet_ID, (resourceSet, resourceItemJn) => new { ResourceSet = resourceSet, ResourceItemJn = resourceItemJn }).Where(join => join.ResourceSet.ToepassingsCode == toepassingsCode).Select(join => join.ResourceItemJn).ToList()
                .Join(Context.ResourceItemDotNetJnSet, resourceItemJn => resourceItemJn.ID, resourceItemDotNetJn => resourceItemDotNetJn.ID, (resourceItemJn, resourceItemDotNetJn) => new { ResourceItemJn = resourceItemJn, ResourceItemDotNetJn = resourceItemDotNetJn }).Select(join => join.ResourceItemDotNetJn).ToList()
                .Join(Context.ResourceItemWaardeJnSet, resourceItemDotNetJn => resourceItemDotNetJn.ID, resourceItemWaardeJn => resourceItemWaardeJn.ResourceItem_ID, (resourceItemDotNetJn, resourceItemWaardeJn) => new { ResourceItemDotNetJn = resourceItemDotNetJn, ResourceItemWaardeJn = resourceItemWaardeJn })
     .Select(join => join.ResourceItemWaardeJn.User.Replace(@"DG3\", ""))
     .Distinct().ToList();

You just want to return everything after the backslash??

DavidG
– DavidG

2014-08-12 08:45:58 +00:00
Commented Aug 12, 2014 at 8:45 — DavidG
– DavidG, Commented Aug 12, 2014 at 8:45
Right margin Overflow.

Henk Holterman
– Henk Holterman

2014-08-12 08:48:50 +00:00
Commented Aug 12, 2014 at 8:48 — Henk Holterman
– Henk Holterman, Commented Aug 12, 2014 at 8:48
yes, that's it, DavidG.

Rui Martins
– Rui Martins

2014-08-12 08:48:53 +00:00
Commented Aug 12, 2014 at 8:48 — Rui Martins
– Rui Martins, Commented Aug 12, 2014 at 8:48

DavidG · Accepted Answer · 2014-08-12 08:53:50Z

3

Use the Substring function:

journalingUsers = journalingUsers.Select(s => s.Substring(s.IndexOf(@"\")+1));

answered Aug 12, 2014 at 8:53

DavidG

120k13 gold badges232 silver badges239 bronze badges

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

4 Comments

Tim Schmelter Over a year ago

+1, more efficient and more redable than my string.split approach

DavidG Over a year ago

Don't think you should have deleted yours though, it's still a valid answer.

Tim Schmelter Over a year ago

Ok, i've undeleted it. Maybe it has some added value if OP needs to take/skip other parts.

Rui Martins Over a year ago

Works like a charm, tks.

Tim Schmelter · Accepted Answer · 2014-08-12 08:49:15Z

2

So you want to ignore the first part? A simple approach is using String.Split and Enumerable.Skip:

List<string> allButFirst = journalingUsers
    .Select(s => string.Join("\\", s.Split('\\').Skip(1)))
    .ToList();

answered Aug 12, 2014 at 8:49

Tim Schmelter

462k79 gold badges720 silver badges981 bronze badges

3 Comments

Henk Holterman Over a year ago

It's not a path, just Domain\User so you don't need to Join again. Split(...)[2] is enough.

Tim Schmelter Over a year ago

@HenkHolterman: You've lost me. OP doesn't mention Domain\User or that it contains three tokens.

Henk Holterman Over a year ago

Yeah, should have been [1]

Community · Accepted Answer · 2017-05-23 10:33:32Z

-1

This question on #Stackoverflow might help you out, check it out?

Link to Question on stackoverflow

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Aug 12, 2014 at 8:46

Suits999

3691 gold badge7 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to replace a string with linq

3 Answers 3

4 Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related