Regular expression to replace in TextPad

Question

I need to replace this:

HSOD,BASE,DFLT,001,06-19-2012,[any string],1,0,0

With this:

HSOD,BASE,DFLT,001,06-19-2012,[any string],1,0,N

where the [any string] part needs to be a wild card.

Answer 1

If all the lines are the same format you can just check for lines ending in ,0 and replace that ,0 with ,N.

Search:

,0$

Replace:

,N

If you don't know the value of the last digit(s) then you could do the following.

Search:

,[[:digit:]]*$

Replace:

,N

Answer 2

You can find this:

(HSOD,BASE,DFLT,001,06-19-2012,.*?,1,0,)0

And replace by this:

\1N

With the regular expression box checked, of course.