Splitting a String using regex in c#

Question

I have a program to compare text files. Takes in 2 files spits out 1. The input files have lines of data similar to this

tv_rocscores_DeDeP005M3TSub.csv FMR: 0.0009 FNMR: 0.023809524 SCORE: -4  Conformity: True
tv_..............P006............................................................
tv_..............P007............................................................

etc etc.

For my initial purposes, I was splitting the lines based on spaces, to get the respective values. However, for the first field, tv_rocscores_DeDeP005M3TSbu.csv i only need P005 and not the rest. I cannot opt for position number as well, because the position of P005 in the phrase is not the same for every file.

Any advise on how i split this so that i can identify my first field with only P005??

If you got a pattern as @germi was looking for you could extract the value via a regex. — A. Tapper
– A. Tapper, Commented Jan 10, 2014 at 10:28
That's just one line. I have from P001 to P100 in my text files. This was just for an example. — Matt
– Matt, Commented Jan 10, 2014 at 10:29
Without using regex: get a new line, find first occurrence of .csv, go back until you read Pxxx, take xxx. Should not be hard. — Sinatr
– Sinatr, Commented Jan 10, 2014 at 10:58

Dmitrii Bychenko · Accepted Answer · 2014-01-10 10:32:38Z

2

Your question is a bit unclear. If you're looking for pattern, say "P + three digits", e.g. "P005" you can use regular expressions:

  String str = @"tv_rocscores_DeDeP005M3TSub.csv FMR: 0.0009 FNMR: 0.023809524 SCORE: -4  Conformity: True";

  String[] parts = str.Split(' ');
  parts[0] = Regex.Match(parts[0], @"P\d\d\d").Value; // <- "P005"

answered Jan 10, 2014 at 10:32

Dmitrii Bychenko

188k20 gold badges178 silver badges231 bronze badges

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

2 Comments

Matt Over a year ago

Thanks for the answer @Dmitry. Lemme test that out please. :)

Matt Over a year ago

This worked like a charm for me. This is actually easier for me to use in my program. And so i am accepting this answer. Thank you very much again

A. Tapper · Accepted Answer · 2014-01-10 10:35:05Z

1

To extract the desired part I would try something like this:

 var parts = str.Split(' ');
 var number = Regex.Match(parts[0], ".*?(?<num>P\d+).*?").Groups["num"].Value;

Or if you know its only three digits you could change the regular expression to .*?(?<num>P\d{3}).*?

Hope that solves your problem :)

answered Jan 10, 2014 at 10:35

A. Tapper

1,2738 silver badges17 bronze badges

1 Comment

Matt Over a year ago

Hi, Thanks for the answer. I already got an answer(same as yours). This goes well with my application. Thanks for taking time to answer my question.

Raidri · Accepted Answer · 2014-01-10 10:25:43Z

0

How about just checking if the first field contains P005?

bool hasP005 = field1.Contains("P005");

answered Jan 10, 2014 at 10:25

Raidri

17.7k11 gold badges69 silver badges70 bronze badges

1 Comment

Matt Over a year ago

Thanks for taking time to answer my question. I got my answer. Have a great day.

Douglas · Accepted Answer · 2014-01-10 10:25:58Z

0

Your question isn't clear. Can't you just replace the first field with your string?

string[] parts = str.Split(' ');
parts[0] = "P005";

answered Jan 10, 2014 at 10:25

Douglas

55.1k14 gold badges145 silver badges193 bronze badges

2 Comments

Matt Over a year ago

I am sorry my question wasn't clear. I have a program to compare two text files and subtract the respective fields (based on the first field tv_roc....P005...)

Matt Over a year ago

Thanks for taking time to answer my question

Crudler · Accepted Answer · 2014-01-10 10:41:08Z

0

Are you looking to try field the field that contains that string? if so then you can use some linq

var field = s.Split(' ').Where(x => x.Contains("P005")).ToList()[0];

answered Jan 10, 2014 at 10:41

Crudler

2,3164 gold badges35 silver badges59 bronze badges

1 Comment

Matt Over a year ago

No worries. Thank you very much for taking time to answer my question. I got my answer. Thanks again

Collectives™ on Stack Overflow

Splitting a String using regex in c#

5 Answers 5

2 Comments

1 Comment

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related