Data from Textfile to Excel

Help StudioX
,
1

Hello together,

i have 100 PDF Documents. In each PDF Document are error messages. I just want to export the error messages from the Documents to excel to sort the error messages. Now for the first step i used the activity → READ PDF and then WRITE TO. So the bot wrote all from the PDF-Document in a Text File. But now i need only the error Messages in the Text file and i want to export them to Excel.

This is my first bot and i hope, that somebody can help me. Thank you in advance for your help.

Greetings from Germany
Daniele

2

Can you share the text file ,by using the regex it will extract only the error message

@daniele.piccolomo

4

image
image1297×983 27.4 KB

I need only the Informations after → Fehler/Meldungen:

5

@daniele.piccolomo

try this once

assign activity

outputvariable=system.text.RegularExpressions.Regex.Match(outputstr,“(?<=\bFehler /Meldungen:\n).\n.\n.*”).Value

Cheers

6

Hi can you try with this regex pattern,

str= System.text.RegularExpressions.Regex.Match(lineTetx,“(?<=Fehler/Meldungen:[\s*]).\n.\n.\n.”).Value.Trim

@daniele.piccolomo

let me know if it working or not

7

@Praveen_Mudhiraj @Shiva_Nikhil thank you very much for your help :-). I Will try it tomorrow and let you know, if it works ;-).

8

@daniele.piccolomo

Sure and thank you :blush:

1 Like
9

yeah ok @daniele.piccolomo

Cheers…

1 Like