Extracting table from txt file

Help Studio
21

The format of this file is awful. Where is it coming from?

I see this a lot with RPA - people just think you can automate bad processes to make them good processes. You can’t.

As part of your overall process (not just the automation part) get a better file to work with (csv, excel, etc), or a direct connection to the data source, etc.

22

@kadiravan_kalidoss this is the post if u have idea pls help

23

Hi @sayali_rokade,

Please refer this xaml:
TxtToExcel_MUFGCA.xaml (61.4 KB)

Sample Input & Output:
MUFGCA.txt (2.5 KB)

Output_MUFGCA.xlsx (9.5 KB)

Change the txt file path in argument and test it.

Thanks!

24

@kadiravan_kalidoss thanks for ua help one more thing adding is:
i want to add Acc no for all entries in excel means i need to add one column named account no and save it excel for all entries, as we i extracted acc no and even saved in excel but only in one row -i try to do it in your code but showing error where to place this acc code in ur code
try.xaml (10.7 KB)

25

TxtToExcel_MUFGCA.xaml (62.2 KB)
Updated Account Number Code. I have hard coded acc. num. Pass the
extracted Acc. Num in this variable(strAccNum). @sayali_rokade

Thanks!

26

hi @kadiravan_kalidoss actually next challenge m facing is as u solved some description goes in second table which is not coming in excel so suppose i have pdf with 2 page then
CanaraBank.txt (2.9 KB)
so i want below opening bal as well

27

Hello Sayali,
In this video, I have 17 examples with code on how to extract data from PDF (You can try the VB.NET logic):

Thanks,
Cristian