I think the answer is probably above but here is one more: Search: *^(\d\d\/\d\d\/\d\d)\s(.+?)\s([0-9\.]+)$* Replace: *\1\t\2\t\3*
Saved in Regex101 here <https://regex101.com/r/9ApMVi/1>. On Thu, 15 Feb 2024 at 17:43, Ted Burger <[email protected]> wrote: > 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]. > 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 > <https://groups.google.com/d/msgid/bbedit/24595419-8337-42BA-B240-DDCD519B344A%40tobsupport.com?utm_medium=email&utm_source=footer> > . > -- Kaveh Bazargan PhD Director River Valley Technologies <http://rivervalley.io> ● Twitter <https://twitter.com/rivervalley1000> ● LinkedIn <https://www.linkedin.com/in/bazargankaveh/> ● ORCID <https://orcid.org/0000-0002-1414-9098> ● @[email protected] <https://mastodon.social/@kaveh1000> *Accelerating the Communication of Research* * <https://www.linkedin.com/posts/bazargankaveh_ismte-innovation-award-recipient-kaveh-bazargan-activity-7039348552526921728-XAEB/?utm_source=share&utm_medium=member_desktop> [image: https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/] <https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/>* -- 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/CAJ2R9phX4rigkqZ_hi-D2mJN1GP%3DMRu62XTQD9kcmqeeAFb0Uw%40mail.gmail.com.
