Didn’t work with my example. but this is regexp wizardry beyond my knowledge (or my google-fu is weak today)
This is what I had in the find box: (.(23)) (.(43)) (.(74)) (.(95)) Sample data Name Alias Database ProhibitSendQuota ExternalDirectoryObjectId ---- ----- -------- ----------------- ------------------------- Name1 Alias1 NAMPR190000-xxxx 49.5 GB (53,150,220… objid1 Name2 Alias2 namPR190000-xxxx 49.5 GB (53,150,220… objid2 No matches were found so nothing got replaced. This was why I loved Columnbo, just drag a marker to the point you wanted the column to start and bang it replaced any string of spaces to a tab character. Used it to massage large masses of text into tabular data. On Nov 10, 2022, at 12:09 PM, jj <[email protected]<mailto:[email protected]>> wrote: You could try a 'Replace All' with a regular expression using column width instead of character positions. Find: (.{65})(.{25})(.{35}) Replace: \1\t\2\t\3 HTH, Jean Jourdain -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]<mailto:[email protected]>" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You received this message because you are subscribed to a topic in the Google Groups "BBEdit Talk" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/bbedit/mpUF87o2jXg/unsubscribe. To unsubscribe from this group and all its topics, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/c4b0ab86-36ab-48f8-8dbd-e2a94c9b89d6n%40googlegroups.com<https://groups.google.com/d/msgid/bbedit/c4b0ab86-36ab-48f8-8dbd-e2a94c9b89d6n%40googlegroups.com?utm_medium=email&utm_source=footer>. -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs -- 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/3E88B875-0D5D-4232-B2DF-1AF5792F3602%40pharmacy.arizona.edu.
