parse data with regular expression

Question

<option value="28.5.2011|2">28.maj. 2 dni od 109,00&nbsp;EUR</option>
<option value="27.8.2011|2">27.avg. 2 dni od 109,00&nbsp;EUR</option>
ect

i need to parse data from text like this.

I need to get in first example:

109

in second example:

109

regular expression must be generic to get this data becous ei have 1000 rows.

To get 27.8.2011 i use split and | for delimeter. The same with 2. but i do not know how to get 109.

Thx

What have you tried (i.e., what does your current regex look like) and where are you stuck? The split/delimiter stuff doesn't sound like you are using regex at all at the moment... — Heinzi, Apr 21 '11 at 15:18
I recommend using this tool to assist with creating regular expressions: http://gskinner.com/RegExr/ — Chris Laplante, Apr 21 '11 at 15:19
you should make the groups in the regex the you want to fetch from data and then apply it on data by the execute method — Badr, Apr 21 '11 at 15:20
i have only problems with 109,00. This i do not know how to get? @moon groups? — senzacionale, Apr 21 '11 at 15:28
http://www.regular-expressions.info/named.html this will help you — Badr, Apr 22 '11 at 06:06

plasmasnake · Answer 1 · 2012-04-05T10:31:57.543

1

String pat = "<option\svalue=".{1,15}?">.{1,10}?\s\d\s.{1,5}?\s.{1,5}?\s(.{1,10}?)\&nbsp\;EUR</option>";
Regex r = new Regex(pat, RegexOptions.IgnoreCase);
Match m = r.Match(test);
Group ad1 = m.Groups[1];
String out = ad1 +"";

edited Apr 05 '12 at 10:31

answered Apr 05 '12 at 10:26

plasmasnake

11
2

Jason McCreary · Answer 2 · 2011-04-21T15:45:58.213

0

Provided your input is strictly just the option markup

<option value="28.5.2011|2">28.maj. 2 dni od 109,00&nbsp;EUR</option>
<option value="27.8.2011|2">27.avg. 2 dni od 109,00&nbsp;EUR</option>

The following works:

"([^\|]+)\|([^"])">.*?(\d+),

Note: This is a very specific Regex and I'm not familiar with C#. So if you need exact code, someone else will have to provide it. Nonetheless, for that input, the RegEx above works.

edited Apr 21 '11 at 15:45

answered Apr 21 '11 at 15:22

Jason McCreary

71,546
23
135
174

thx for answer but i get error. So i write this: \d+((.\d+)+(,\d+)?)? Is ok? – senzacionale Apr 21 '11 at 15:51
Which error exactly? The [regex](http://www.regular-expressions.info/) works OK with your very limited data set on [nregex.com](http://www.nregex.com) and [regexhero.net/tester](http://www.regexhero.net/tester). You probably just need to properly [take care of the quotes and escape sequences](http://stackoverflow.com/questions/5179389/at-sign-in-file-path-string/5179393#5179393 "escaping behavior of strings") to use the presented string in your code… – mousio Apr 21 '11 at 22:28

parse data with regular expression

2 Answers2