Find specifig word and catch following then send to excel in batch

[dano (D Albayrak)]

Hi,

I am now trying days to parse PDF files and create an Excel with needed data. Actually no big deal, there is a good tutorial video out there. Unfortunately my PDF is not showing up sections so I can’t go that way.

I need to find a workaround to search for a word “Date:” and have UIPath taking the following characters, lets say 10 caracters.

Is there any way handling this?

[NIVED_NAMBIAR (NIVED N)]

Hi @dano
welcome to forum

You can try regex for this

Regards,
Nived N
Happy Automation

[dano (D Albayrak)]

Hi @NIVED_NAMBIAR,

is there any help page for regex and how to process in total? I am pretty new to UIP

[NIVED_NAMBIAR (NIVED N)]

Hi @dano
Check this

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…

Also if you can share more details about your usecase i can help on that

Regards,
Nived N

[ermanoj3101 (MANOJ)]

Hi @dano ,

You can try this as a reference to get value from Date:
GetValueAfterColon.xaml (5.9 KB)

[dano (D Albayrak)]

hi guys,

thnaks a lot.

How can I use regex in a process? Sorry, I am at the very beginning.

I can’t attach a file so I share a link to the PDF

Invoice

I need to fetch these data:

Vom: …
Innenauftragsnummer: …
Gesamt Netto …

Thanks for your help