Match only numbers between the first and second comma in regex

Question

Example strings:

John, a 005, green, 01-22-18.abc Sarah, 325, blue, 03-18-17.abc Mike, b 56, red, 12-05-17.abc

I would like regex to match 005 325 and 56 respectively. Could you show me how to accomplish it?

Thanks.

Doesn't work. Thanks for trying. https://regex101.com/r/k8qGBo/1 — misaligar, Jan 22 '18 at 14:40

score 1 · Answer 1 · answered Jan 22 '18 at 14:45

1

You can use this regex to match numbers that occur between first and second comma in each line:

^[^,]*,[^,0-9]*([0-9]+)

Numbers are available in capture group #1

Explanation:

answered Jan 22 '18 at 14:45

anubhava

How do I extract the "group #1" only? – misaligar Jan 22 '18 at 14:55
Text parser module of Integromat. Here https://www.integromat.com/en/integrations/regexp – misaligar Jan 22 '18 at 14:58
Hmm I don't know Integromat but extracting a capture group is possible in all the editors or tools – anubhava Jan 22 '18 at 15:01

rkta · Answer 2 · 2018-02-05T08:24:07.553

0

Depending on your regex engine you could use Positive Lookbehind and Positive Lookahead.

(?<=,\W|\s)\d+(?=,)

Explanation in order of execution:

Try it here:

https://regex101.com/r/nkYBFh/1

edited Feb 05 '18 at 08:24

answered Jan 22 '18 at 14:43

rkta

Thanks a lot! However, this regex phrase doesn't work in Notepad++. Any idea why? – misaligar Jan 22 '18 at 14:57
Not all regex engines support lookaheads/lookbehinds. – rkta Jan 22 '18 at 14:58

2 Answers2