Find the text adjacent to a string and extract the value

[Gopalakrishnan_K]

I have extracted PDF text and saved it as string. I need to check if a specific word (say total amount ,Bill number etc…)is present in the PDF. If it is so,i need to extract the word adjacent to the specific word and add it to Data table. How can i achieve this functionality?

[Vrushali_Gave]

@Gopalakrishnan_K Use regex for this task.

[Gopalakrishnan_K]

@Vrushali_Gave, How to use regex in case i need to fetch the adjacent word in a string

[Pratik_Wavhal]

Hi @Gopalakrishnan_K

Can you share the readed PDF text file along with PreserveFormatting option in properties as “True” and also without “True”

So that applying exact Regex on the same will be easier

Happy Automation

Best Regards
Er Pratik Wavhal

[Gopalakrishnan_K]

@Pratik_Wavhal,
Amazon.pdf (60.2 KB)
In this pdf, i am searching for text ‘Order total’. If the text is present, i need to extract the word adjacent to ‘Order total’ which is the value corresponding to the field.

[Gopalakrishnan_K]

@Pratik_Wavhal,
please reply

[Pratik_Wavhal]

Hi @Gopalakrishnan_K

Below is the workflow for the same :-

MainPratik.xaml (8.6 KB)
output.txt (1.3 KB)

Output :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[Gopalakrishnan_K]

Thanks ,got it

[Steven_McKeering]

If you want to learn more about Regex - check out my MegaPost.

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

The purpose of this post is to help New Regex users I see a lot of Regex posts seeking help but very little effort is made in their post. Give us, Sample, Output and Pattern. CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : L…

[Anju_Unnikrishnan]

Hi @Pratik_Wavhal , Even i am working on the same use case. Is it possible to obtain the same scenario for the field “Price” in the above pdf? Because the price amount is printed below the Price field. How to obtain that?

[Pratik_Wavhal]

Hi @Anju_Unnikrishnan

So you mean to say the price der which is in below SS right down side ??

Happy Automation

Best Regards
Er Pratik Wavhal

[Anju_Unnikrishnan]

@Pratik_Wavhal, The Price which is present right to the “Items Ordered”. I want to extract the value (57,990.00) which is below the Price field.

[Pratik_Wavhal]

Hi @Anju_Unnikrishnan

Below is the workflow which meets your requirement :-

Pratik.xaml (9.4 KB)

Output :-

Happy Automation

Best Regards
Er Pratik Wavhal

[Anju_Unnikrishnan]

@Pratik_Wavhal, Thank you

[Pratik_Wavhal]

Hi @Anju_Unnikrishnan @Gopalakrishnan_K

You both are welcome

Happy Automation

Best Regards
Er Pratik Wavhal