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.

  • What exactly [any string] contains? And what about last zero at right side, it should replace with letter N? – Siva Charan Oct 29 '12 at 13:37
  • any string contains values like 000NIS00000069 ; and yes replace right side 0 with an N – Steve Oct 29 '12 at 18:24

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





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




|improve this answer|||||

You can find this:


And replace by this:


With the regular expression box checked, of course.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.