Since you have more headers than fields, I’d remove the headers and I’d use (replace all):
Find: (.*)\r(.*)\r(.*)\r(.*)\r Replace: \1\t\2\t\3\t\t\4\r (Although I noted that the sample data you provided has a date at the end with no data for any of the other fields) Corentin > On Sep 28, 2021, at 14:04, Kim Mosley <[email protected]> wrote: > > I'm looking for a grep pattern to put this data into 5 columns (though there > is no data for the "tags" column). Hopefully I can paste it into Excel. Now > it just goes into one column. > > Date > Description > Category > Tags > Amount > 9/28/2021 > Central Market > Groceries > -$45.28 > 9/28/2021 > Randalls > Groceries > -$9.73 > 9/28/2021 > Natural Grocers > Groceries > -$22.09 > 9/27/2021 > Randalls > Groceries > -$11.03 > 9/27/2021 > Amazon > General Merchandise > -$14.52 > 9/27/2021 > Amazon > General Merchandise > $27.19 > 9/26/2021 > > -- > 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 <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] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/bbedit/7a081d46-77cf-40a7-9ea3-d815ad80dd51n%40googlegroups.com > > <https://groups.google.com/d/msgid/bbedit/7a081d46-77cf-40a7-9ea3-d815ad80dd51n%40googlegroups.com?utm_medium=email&utm_source=footer>. -- 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/54C2F64E-C5F3-4205-AE75-D4F49D0574E8%40gmail.com.
