Convert text with whitespace to csv
March 20, 2012 12:32 PM Subscribe
perl or sed or awk help for newbie
posted by v-tach to computers & internet (26 answers total) 3 users marked this as a favorite
I am trying to get my tax preparation done and so I need to get info into Moneydance. One of my credit card accounts does not give ofx downloads, just pdfs of the monthly account summaries, and I have managed to extract the text from the pdfs and I now need to transform the text into csv format to import it. I have roughly a thousand transactions to process. I have MacOS 10.7 and can use the terminal but no regex skills.
The text is currently formatted as
MMM DD MMM DD PAYEE INFORMATION CITY PROVINCE
and here is an example of two records
DEC 19 DEC 21 RADIO PARADISE 530¯872¯4993 CA
85450930354980007961385 Foreign Currency¯USD 20.00 Exchange rate¯1.046500
DEC 23 DEC 24 SUNTERRA LENDRUM MA CALGARY AB
How can I transform this to a csv file such as
MMM DD, MMM DD, PAYEE INFORMATION CITY PROVINCE, TRANSACTIONNUMBER COMMENT, AMOUNT
which I can import into my financial software?