Thanks so much!!! I have this (313 items):
What would be the grep pattern so that I'd just see the author and the
quote.
Don’t feel disturbed by the thinking mind. You are not practicing to
prevent thinking, but rather to recognize and acknowledge thinking whenever
it arises.—Sayadaw U Tejani
On 28 Sep 2021, at 19:04, Kim Mosley 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.
Save this script as xx.pl in
"~/Library/Application Support
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, 202
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