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.
