I am not that good with grep, so I would break this down. Find: /23 (there is a space character at the end) Replace: /23\t
Then Find: TX (there is a space at the end) Replace: TX\t Thanks, Ted *********************** Ted Burger **************************** [email protected] ********* www.tobsupport.com > On Feb 15, 2024, at 12:33 PM, Mike Pasini <[email protected]> wrote: > > Let's describe the pattern you are trying to split. There's more than one way > to do that (as the replies to you query show) but by focusing on a general > pattern (what must always be true about your original text), we can make a > more reliable regexp. > > You want to capture everything up to the first space -- ^(.+?)/s -- followed > by just about anything (.+?)/s until you see a string of numbers including a > period ([\d.]+?)$ at the end of the line. > > So try: ^(.+?)\s(.+?)\s([\d.]+?)$ > > In BBEdit, you can put that in the Find dialog with \1\n\2\n\3\n\n in the > replace to make the three groups clear (substitute \t for the first \n for > tabs). > > On Wednesday, February 14, 2024 at 3:05:25 PM UTC-8 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. > > 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/2e4a77ba-e50f-46b8-877b-59f0e08cef0en%40googlegroups.com > > <https://groups.google.com/d/msgid/bbedit/2e4a77ba-e50f-46b8-877b-59f0e08cef0en%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/24595419-8337-42BA-B240-DDCD519B344A%40tobsupport.com.
