Slpit the message box to line

Tharusha_Fernando · March 8, 2021, 6:47am

this is the out put from PDF extraction
i want to sperate this as lines and write in a excel row by row
how can i slipt is row by row if so

prasath17 · March 8, 2021, 6:48am

@Tharusha_Fernando - Do you want only the below potion?

Tharusha_Fernando · March 8, 2021, 6:50am

Hi @prasath17
no i want below part also
pdfoutput =new.txt (789 Bytes)
tablebeforeextraction=Bank Statement Template 1 - TemplateLab.pdf (2.1 MB)

prasath17 · March 8, 2021, 6:53am

@Tharusha_Fernando - Please use Preserve format to true, while using read pdf to text activity and share the text file?

BTW: Have you tried this with Document Understanding ??

moenk · March 8, 2021, 6:54am

You will split the string to an array of strings and then loop over it with for each activity to put it you excel.

Tharusha_Fernando · March 8, 2021, 7:01am

it work
how can i now write the excel
do i need to split
how to make this a array @prasath17

new.txt (3.2 KB)

prasath17 · March 8, 2021, 8:31pm

Hi @Tharusha_Fernando - Please find the starter help here…Regex_TF.zip (1.9 MB)

I have achieved it using Regex, which may/may not the best approach depend on the needs.

Hope this helps…

I have also provided the Regex pattern used in the workflow…here is the sample below

Tharusha_Fernando · March 9, 2021, 4:32am

system · March 12, 2021, 4:33am

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