Hi Kim,
Maybe this search pattern will help:
([\d\/]{8})( )([^\,]+)(\, TX )([\d\.]{1,5})
with replace pattern:
\1\t\3\t\5
By the way: Try the pattern first wich the Pattern Playground (the 6th entry in
BBEdits search menu). There’s also an extensive help on grep included.
Cheers, Ulrich
> Am 14.02.2024 um 23:44 schrieb Kim Mosley <[email protected]>:
>
> 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.
>
> Can someone help?
>
> Thanks!
>
> 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
>
> --
> 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]
> <mailto:[email protected]>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/bbedit/235af5bb-10d7-4dad-9df0-fe2db21e94bdn%40googlegroups.com
>
> <https://groups.google.com/d/msgid/bbedit/235af5bb-10d7-4dad-9df0-fe2db21e94bdn%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/E5102CE7-07BA-4051-A600-AFA2F59FB2C9%40gmx.de.
