RegEx word and numbers

RPA3 · February 25, 2020, 9:23am

Hello!
Which expression should I use? For example, I have:

134
sdefwe
fwarg 31
fwe4fwe
wetf23tfw4tg24
235
sergwgt 1351

I need to leave only lines where there are numbers separately:
134
fwarg 31
235
sergwgt 1351

And also I need clean received lines from words and leave:
134
31
235
1351

ThomasStocker · February 25, 2020, 9:29am

Getting rows with number separately:
[0-9 ]+

extracting numbers from lines:

\d+

RPA3 · February 25, 2020, 9:36am

How to combine it?

Yoichi · February 25, 2020, 9:49am

Hi,

Can you try Matches activity with the following settings.

Input : your string variable
Pattern : "(?<=(^|\s))\d+$"
RegexOption : check Multiline

Regards,

hacky · February 25, 2020, 10:08am

Please find the workflow as per your requirement.

Kindly mark as solution if you found it useful.

Thanks and Regards,
hacky.

msan · February 25, 2020, 12:06pm

For numbers only : \b\d+\b
For lines containing these numbers: ^.*\b\d+\b.*$ with Multiline option

Vivek.A.S · February 25, 2020, 12:17pm

@RPA3, you got solution ah?

Else Please refer the Regex Pattern given below