Kim,
On Wed, 14 Feb 2024 14:44:27 -0800 (PST), Kim Mosley wrote:
> I want to add tabs (or something else that might be better) so that
> I can have three columns… date, vendor with city, and price.
> 01/03/23 CENTRAL MARKET 61 AUSTIN, TX 45.00
> 01/04/23 H-E-B 425 AUSTIN, TX 74.62
> 01/09/23 CENTRAL MARKET 61 AUSTIN, TX 43.70
> 01/10/23 WHOLEFDS LMR 10145 AUSTIN, TX 62.25
> 01/13/23 SQ *ASAHI IMPORTS Austin, TX 24.46
> 01/14/23 CENTRAL MARKET 61 AUSTIN, TX 29.22
> 01/17/23 CENTRAL MARKET 61 AUSTIN, TX 28.25
> 01/18/23 CENTRAL MARKET 61 AUSTIN, TX 19.34
> 01/21/23 CENTRAL MARKET 61 AUSTIN, TX 1.83
> 01/21/23 CENTRAL MARKET 61 AUSTIN, TX 18.34
> 01/23/23 CENTRAL MARKET 61 AUSTIN, TX 19.85
Search for
^([0-9]{2}/[0-9]{2}/[0-9]{2})\s{1,}(.*[A-Z]{2,})\s{1,}([0-9]{1,}\.[0-9]{2})
Replace with
\1\t\2\t\3
The *search for* regex makes several assumptions.
1. all entries in the data set begin on a new line.
2. all the dates in the data set are of the form mm/dd/yy (ie the
legacy US-centric Gregorian date shorthand).
3. all the vendor addresses end with a comma, one or more spaces, and
then a two-letter state code as per the USPS’s Publication 59,
1963-10.
4. all prices are listed to two significant figures after the decimal
point.
Hope this helps.
Regards,
Brian Forte
--
Brian Forte
<[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/20240215095722462538.d5f23e1a%40adelaide.on.net.
