Extract text from string between commas

Question

I want to extract only those words between two commas. So, if the string is Ab Java, DE, 78801 The answer must be DE I have tried this code but it is not working

string search = "Ab  Java, DE, 78801 ";
int index = search.IndexOf(",");
string result = search.Substring(search.IndexOf(",") ,index);
MessageBox.Show(result);

Your string has _always_ two commas? – Soner Gönül May 21 '15 at 06:14 — Soner Gönül, May 21 '15 at 06:14
Yes It always have two commas – Hisham shahid May 21 '15 at 06:16 — Hisham shahid, May 21 '15 at 06:16

Soner Gönül · Accepted Answer · 2015-05-21T06:23:25.717

6

If your string has always 2 commas, you can use String.Split for it like;

string search = "Ab  Java, DE, 78801 ";
Console.WriteLine(search.Split(',')[1]); // DE

Remember, this will you generate DE with an extra white space before it.

enter image description here

If you don't want that white space, you can use TrimStart() to remove it.

Console.WriteLine(search.Split(',')[1].TrimStart()); //DE

edited May 21 '15 at 06:23

answered May 21 '15 at 06:16

Soner Gönül

97,193
102
206
364

2

What is this `Dump()` method? – Shaharyar May 21 '15 at 06:21
2

@Shaharyar It is an extension method of LINQPad. http://stackoverflow.com/questions/2699466/linqpad-dump-extension-method-i-want-one I used this tool to generate some code examples but looks like it might be confusing sometimes. Deleted it. – Soner Gönül May 21 '15 at 06:23
@SonerGönül Thanks for the explanation. I think downvoter also didn't know about this method :) – Shaharyar May 21 '15 at 06:28
@Downvoter care to comment at least so I can see where I _might_ be wrong? – Soner Gönül May 21 '15 at 06:49

score 3 · Answer 2 · answered May 21 '15 at 06:16

Your start and end in your Substring resolve to the same value.

Try using split and getting the second item, of course this assumes that your input always follows the pattern in your example. Otherwise you'll need to do something more complicated.

string[] searchItems = search.Split(',');
string result = searchItems[1].Trim(); // will output DE

score 1 · Answer 3 · answered May 21 '15 at 06:16

1

try this

string[] splitedStr=search.Split(',');
string NewStr=splitedStr[1].ToString();

answered May 21 '15 at 06:16

Dgan

10,077
1
29
51

score 0 · Answer 4 · answered May 21 '15 at 06:16

0

Assuming your string always has just two commas, then:

search.Split(", ")[1]

will give you the desired text.

answered May 21 '15 at 06:16

David Arno

42,717
16
86
131

score 0 · Answer 5 · answered May 21 '15 at 06:18

0

Try this...

String str = "Ab  Java, DE, 78801 ";
String[] myStrings = str.split(",");
String marco = myStrings[1];

answered May 21 '15 at 06:18

Deenadhayalan Manoharan

5,436
14
30
50

score 0 · Answer 6 · answered May 21 '15 at 06:21

0

Try This. It May work...

string[] arrayStr = search.Split(',');
int len = arrayStr.Length;
for(int i =1;i<=len-2;i++)
{
   MessageBox.Show(result);
}

answered May 21 '15 at 06:21

Sadequzzaman Monoj

121
2
3
10

score 0 · Answer 7 · edited Feb 10 '23 at 11:43

That is something I would have solved using regular expressions. It might be slower than the String.Split solutions but it is way easier to read - in particular if the pattern is going to evolve over time.

The solution would than look like this:

string search = "Ab  Java, DE, 78801 ";
Regex r = new Regex(", *(.*?) *,", RegexOptions.Compiled);
Console.WriteLine(r.Match(search).Groups[1].ToString());

This writes DE without surrounding spaces. The regex instance should be a static member of your class, since I assume this is happening within a loop ...

Extract text from string between commas

7 Answers7

Linked

Related