How to save only specific keyword from DB

[Printf7]

Dear all,

I would like to save only specific keyword that begins with ‘NQ311’ from DB.
(ExractDataTable)

Could you please let me know how to save it like this?
/display/showDisplay/NQ31135517%AJFJIE/
→ NQ31135517 (10 digits)

thanks,
Best regards,

[Pravin_Patil1 (Pravin Patil)]

@Printf7

Use matches activity with regular expression “(NQ311)\w+”

Below screenshot for ref

[Marius_Puscasu]

Hi @Printf7 ,

Another possible solution would be to use the following statement:

(?<=goodsNo=).*(?=&influx|&display)

For a better understanding of how these things works, please check our colleagues mega post https://forum.uipath.com/t/regex-help-tutorial-megapost-making-your-first-regex-post-reusable-regex-patterns-regex-troubleshooting-sample-workflow-and-more/238791

Best regards,
Marius

[Printf7]

Hello,
I really appreciate about your answer!

However, I hope to use the DB (DataTable type) not Excel file.
In this case, How should I do…?

Data is

There is a additional questions.
How can I modify the data from DB (DataTable)? (not excel)
544(0.14%) (text type) → 544 (number type)

[Pravin_Patil1 (Pravin Patil)]

@Printf7

You have to loop through the data table using for each row and then assign value to
row(“Page”)=output of regular expression I explained above

[Printf7]

Hello,

I really appreciate about your help!
It works well!!!