> Il giorno 18 feb 2023, alle ore 23:54, Nello Lucchesi > <[email protected]> ha scritto: > > I’m new to scripting BBEdit and columnular transformations. > > I’d like to create/modify/steal a script to transform a csv file containing > financial data from my credit card company’s format into the format exported > by Mint (so that I can import the resulting Mint imposter into Quicken for > Mac). > > Credit card CSV (Input) > Date, Id, Amount, Description > > Mint CSV (Output) > Date,Description,Original Description,Amount,Transaction > Type,Category,Account Name,Labels,Notes > > The new columns will be either: > Constants, > Empty. > Duplicates of other columns > > Can someone please point me in the right direction? Ideally, can you point > me towards a script that does most of this and that I can modify? > > Thank you. >
if the CSV fiel had ';' as field separator, open BBEdit cutn paste that Date;id;amount;description 01/01/2022;0001;123.00;una descrizione 01/01/2022;0001;123.00;una descrizione 01/01/2022;0001;123.00;una descrizione (some words are italian) open find check GREP and Show Matches , and left to right buttons column right click in 3rd with a ? in a circle. find: ^(.*)\;(.*)\;(.*)\;(.*)$ replace \2;\1;\4;\3 then button replace&find to see what happens. I hope that helps "Un fiorino!" Massimo Rainato [email protected] -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/59FE2EFA-0C5E-484A-9A7B-2767279D45B4%40gmail.com.
