hi all i have one excel, and i converted that excel into text file now i want to extraxt data from text file and save it in excel.
here is my txt file
city.txt (3.1 KB)
i want to save data(table data) like this in excel
By seeing the text file, I am not sure this is feasible due to the second line value. We can not identify the second line value is for which column.
May I know from where you are getting this text file. Possible try to get a text file each row in single line with a delimiter. Then it will be easy for you.
i want data from TRANS VALUE BRANCH REF/CHQ.NO DESCRIPTION WITHDRAWS DEPOSIT BALANCE
DATE DATE
that is the task
Hi @sayali_rokade,
Please refer this xaml:
TxtToExcel.xaml (32.5 KB)
Sample Output:
Output_City.xlsx (9.4 KB)
Change the txt file path in argument and test it.
Thanks!
1 Like
@kadiravan_kalidoss thanks a lot for your efforts .you just made my day ,will go through nd that will really healpful for me to learn.
actually i have same example and i am trying regex pattern there but not working my side will share you my code ls check if you have any idea about it.my code
MUFGCA_toExcel.xaml (13.9 KB)
MUFGCA.txt (2.5 KB)
@kadiravan_kalidoss just checked second table value are not coming in excel
just noticed that some text in Description col is displayed incomplete it showing only upto RTGS CR- HDFC0000240- BHARATFORGELTD-2
and half text is in page 2 like HDFCR52021033185265609
so can we merge page1 and page2 in single excel
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.