How to save only specific keyword from DB

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,

@Printf7

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

Below screenshot for ref

1 Like

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

2 Likes

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…?
image

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)

@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

1 Like

Hello,

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

image

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