PDF data formatting

[sayali_rokade]

i have one text file so i want all data in proper manner so what happen is till one page m extracting well but some description is going in second table so how to extract in second page i will share my code
TxtToExcel (1).xaml (36.2 KB)
Canara bank April 2021 stmt.pdf (5.4 KB)

[kumar.varun2 (Varun Kumar)]

Hi @sayali_rokade

Try this

PDF Data Formatting.xaml (19.6 KB)

[sayali_rokade]

from where you have learn regex? its great that its working for all files which have same format .thanks a lot. as i am beginner and m learning how to work with regex pls share me imp links related to regex pattern

[NIVED_NAMBIAR (NIVED N)]

Hi @sayali_rokade

To learn regex, there is good post in forum made by regex champion @Steven_McKeering

Sharing the link here

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 If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). 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 : Le…

You will find this useful for learning regex

Regards,
Nived N
Happy Automation

[sayali_rokade]

Thanks @NIVED_NAMBIAR

[kumar.varun2 (Varun Kumar)]

Check for tutorials on YouTube also.