Forum Discussion
Xero output file in CSV. How to convert to txt file for upload in bank system for payment
Hi I need some help to convert a file in CSV (Xero output) into a txt file for upload in bank system for payment. I am trying to build a process when I can take the CSV file, take the data and paste...
I'd do that with Power Query
- query csv from some folder
- query additional information which is required to form the text (I guess email, etc)
- transform all together into one column table with required texts
- return it to Excel sheet and save it as Unicode txt, manually or by macro similar to NikolinoDE suggested, i guess simple bat file will work as well.
Thanks so much for your response which sparked me off in the right direction. It was helpful !
Thanks also to all the others who provided input / tips. They will surely come in handy as I build my solution.
