Shalabh Agarwal

Thanks again Guy. Really appreciate it.

Thanks Claudia. I also just noticed you gave same solution as THEVENOT Guy. I need...

Excellent. This works. Thanks heaps. One more point though. I forgot to mention that...

Thanks Claudia. My file has 45,000 such rows. So, I am looking replace all using...

I have a pipe-delimited file with 19 fields in each row as below: 40|ESIS|016066|$179,517.43|$15,334.73|$0.00|$0.00|$0.00|$0.00|$0.00|$-1,318.55|-$0.00|-$0.00|-$2,293.87|$0.00|-$42.57|-$43.00|$0.00|$191,154.17...

Excellent. It worked. Thanks Thomas.

I have around 4,000 rows in notepad++ in this format: 996LMRDF96044 96044 996LMRDF100812...

I have around 4,000 rows in notepad++ in this format: 996LMRDF96044 96044 996LMRDF100812...