Community

bbadmin wrote: Thu Dec 04, 2025 1:52 pm I always find it easier to think about what to match, rather than not match

I like to live dangerously...

[^$] doesn't seem to help $ has no special meaning inside square brackets - it only literally matches a dollar sign. Just like a dot or asterisk are no metacharacters inside character classes .


Huh... I'd swear that used to mean "until the end of the line" when I was first learning RegEx in ...

gurok wrote: Thu Dec 04, 2025 4:47 am I think line endings might be at play here. As in, \r gets captured, inserting a new line when referenced.

I was able to get it to work in a new blank document with:

Find what:

Code: Select all

([^\r\t\n]+)\t([^\r\t\n]+)\r\n\1\t([^\t\r\n]+)

Replace:

Code: Select all

\1\t\2,\3

Hmmm... yup, that did it. Thank you.

I'm having mild frustration trying to bludgeon my tab delimited data files into shape.

As the title implies, when I do something like this in a two column file:

Find what: ([^\t\n]+)\t([^\t\n]+)\n\1\t([^\t\n]+)\n
Replace: \1\t\2,\3\n

It matches the first class, then the tab but then grabs the ...

Oh.

That was easy.

Thank you!

I am trying to use a RegEx replacement string in TextPad 8.5.1 to append row ID numbers to the beginning of each line of a fairly large tab delimited text file to prepare it for insertion into a SQL database.

The RegEx search condition is:

^

The Replacement string is:

\i{1342854,1,0,}\t ...