Need Grep Pattern

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

Re: Need Grep Pattern

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

Re: Need Grep Pattern

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

Re: Need Grep Pattern

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