Which expression should I use? For example, I have:
I need to leave only lines where there are numbers separately:
And also I need clean received lines from words and leave:
Getting rows with number separately:
extracting numbers from lines:
Can you try Matches activity with the following settings.
Input : your string variable
RegexOption : check Multiline
Please find the workflow as per your requirement.
Kindly mark as solution if you found it useful.
Thanks and Regards,
@RPA3_Solution.xaml (7.6 KB)
Test.xlsx (8.3 KB)
For numbers only :
For lines containing these numbers:
^.*\b\d+\b.*$ with Multiline option
@RPA3, you got solution ah?
Else Please refer the Regex Pattern given below