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 WHOLEFD
Search for:
^([0-9]+/[0-9]+/[0-9]+) (.*) ([0-9.]+)$
and replace with
\1\t\2\t\3
and Replace all should do it.
-Jim Straus
On Wed, Feb 14, 2024 at 5:05 PM 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, an
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 CENT
Thanks. It worked for some but not all. It could have been my error.
Kim
> On Feb 14, 2024, at 6:06 PM, Jim Straus wrote:
>
> Search for:
> ^([0-9]+/[0-9]+/[0-9]+) (.*) ([0-9.]+)$
> and replace with
> \1\t\2\t\3
> and Replace all should do it.
> -Jim Straus
>
> On Wed, Feb 14, 2024 at 5:05 PM