\i Replacement String not working?

[JohnFoelster]

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:

Code: Select all

^

The Replacement string is:

Code: Select all

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

What I think it SHOULD be doing is numbering each row:

Code: Select all

1342854{tab}
1342855{tab}
1342856{tab}

and so on...

What I am in fact getting is:

Code: Select all

1{1342854,1,0,}{tab}
2{1342854,1,0,}{tab}
3{1342854,1,0,}{tab}

and so on...

And this is NOT what I want.

I remember \i working fine the last time I used TextPad to do this, and I don't think the last two parameters of the \i function were included in the Replacement String documentation the last time I did. I have no idea what I'm doing wrong.

I'm going to eat lunch and take a walk and hopefully someone will come by and explain why I'm stupid.

[bbadmin]

You haven't specified the leading space character after the trailing comma. Either insert a space after it or delete the comma.

[JohnFoelster]

Oh.

That was easy.

Thank you!