Skip first match regex

Hi,

I have a problem with this regex. I try to match the second numbers in the string including the next word. What I've tried is this:

\s([\d\/\.\%]*[\d]+)[\s]+([^\d\s\/\%]+)

But what I matched was 30 MEQ.

I want to match this:

PEDIALYTE 30 MEQ ORAL CEREZA 500 ML SOL 6638

Thank you for readme.

Regex

Accepted answers

All comments

Jonathan-Sherman

Hi @alvaroez,

It's a little difficult to adjust the regex from just one line of data, have you got a larger sample with the outputs you're looking for?

Kind regards,

Jonathan

apathetichell

(\d+\sML) in regex parse tool. - and then just split off the ML with something like regex_replace([RegExOut1],"(\d+)(\sML)","$1") - although there are a TON of ways to isolate the numbers after.

Jonathan-Sherman

@apathetichell if you moved the capture group brackets to wrap just the \d+ you'd only be extracting the digits in parse mode and wouldn't need the more complex RegexReplace() function 😊