Extract the data from a Standard Free Text to DT

I have a free text with a pre-described standard. The sample can be considered as follows:

“I changed my number FROM 1234 TO 5678 and he changed his number FROM 2345 TO 8394”. I want to extract the numeric data after “FROM” and after “TO”.

In this case, in DT, I should get something like the following:

FROM --------------- TO
1234 ----------------- 5678
2345 ----------------- 8394

Any leads?

Hello @Ayush_Purohit_IN
You can use regex to get the values and than use ADD Datarow Activity to add the values into the datatable

Check this workflow for better understanding
FromandtoRegex.xaml (11.2 KB)

1 Like

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