Number value extraction from a string variable

Help Studio
1

Hello,

i have converted data table variable to string variable which looks as below

image

i want to use regex and fetch all the numbers again without word ID now.

Also let me know if any alternative logic if youll know in a shorter way.

Thanks in advance.

2

Hi @tejas.kotharkar

Could you explain what is the process you are doing so I can help you out.

Regards

3

i m having a CSV file containing ID as the column with its values so i want to fetch all the values under that column (ID) and paste it into one application directly.

4

@tejas.kotharkar

You want to paste the ID’s one by one or all the 6 ID’s at a time. Please specify.

Regards

5

At a time and these ID will be dynamic it can be at any numbers its not static as 6

6

Hi @tejas.kotharkar

You can use the below syntax:

Input= "ID
4734731
4734735
4734738
4734740
4735392
4735395"

Output= System.Text.RegularExpressions.Regex.Match(Input,"(?<=ID\s*)\d*[\s\S]*(?=\d*)").Value.Trim()

You can use the Output variable in the application to print the ID’s.

Hope it helps!!
Regards

7

Thanks alot it worked as needed

1 Like
8

You’re welcome @tejas.kotharkar

Happy Automation!!
Regards

9

I hope you got the solution. Make my post mark as solution to close the loop.

Happy Automation!! @tejas.kotharkar

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.