> Il giorno 18 feb 2023, alle ore 23:54, Nello Lucchesi > <ne...@octobergroup.com> 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 massimo.rain...@gmail.com -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/59FE2EFA-0C5E-484A-9A7B-2767279D45B4%40gmail.com.
