"...replacing the spaces in the tab areas..." Should of added "to simulate the text you describe." On Monday, December 13, 2021 at 9:36:13 AM UTC-5 ThePorgie wrote:
> Pulling your text and replacing the spaces in the tab areas and then > Running the following > (?:[- (\.\d]+)?(\d{3})(?:[- )\.]+)?(\d{3})(?:[- )\.]+)?(\d{4}) > with a replacement of > \1-\2-\3 > yields the following > Name1 123-456-7890 Single Lifetime > Name2 123-456-7890 Joint Lifetime > Name3 123-456-7890 Joint Lifetime > Name4 123-456-7890 Single > Name5 123-456-7890 Single > Name6 123-456-7890 Single > Name7 123-456-7890 Joint > Name8 123-456-7890 Joint > > Is that what your looking for? > > On Monday, December 13, 2021 at 8:41:06 AM UTC-5 Tim A wrote: > >> *Try using a negative character class like [^\d\n\r] * >> That will do it! .. and as an extra benefit catches any periods used as a >> delimiter as well. >> >> Deepening the challenge, the phone numbers are actually in the second of >> three columns separated by tabs. If I can get the phone numbers stripped I >> can then impose a uniform format on them. But how do I focus the >> find/replace on just this second column? I can do this in many small steps, >> but figure there must be an elegant way to do it in a single step. >> >> Before... >> >> Name1 1234567890 Single Lifetime >> Name2 123-4567890 Joint Lifetime >> Name3 123-456-7890 Joint Lifetime >> Name4 (123)4567890 Single >> Name5 (123) 4567890 Single >> Name6 (123)-4567890 Single >> Name7 (123)456-7890 Joint >> Name8 123.456.7890 Joint >> >> After... >> Name1 1234567890 SingleLifetime >> Name2 1234567890 JointLifetime >> Name3 1234567890 JointLifetime >> Name4 1234567890 Single >> Name5 1234567890 Single >> Name6 1234567890 Single >> Name7 1234567890 Joint >> Name8 1234567890 Joint >> >> >> >> >> >> -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/c82d1992-768c-4f68-9343-ad2b70b0ee7an%40googlegroups.com.