Community

Thank you very much! that did the trick! now I have to figure out how it really works ; )

My CSV file contains lines like these..

"A","234234","7UM*","2345","00070","12343","120 DEL J.NORRIS"
"B","23423","8UM*","2345","00070","12343","120 DEL J.IMTIH"
"V","1234","6UM*","2345","00070","12343","ABCDEFG"
"V","1234","6UM*","2345","00070","12343",""

I want to find rows where last column (eg ...

I have a macro that I need to run on 100 files - can anyone guide me how to do that in one shot rather than running it on each file?

Thank you very much!

Dear s_reynisson

Oh this worked like a charm! Thank you very much!!

I wish I could return the favor some day.

Regards,

Jaimin


[quote="s_reynisson"]This works for me:
find [[:upper:]]+[0-9]*"$
replace \L&

I have used POSIX regular expression syntax, which can be selected
from the Editor page ...

I Posted this in HOW_TO Section but realized that questions are not supposted to be posted there (Or so I read)

I regularly receive a file that has lines like..
"0001234","CD44567","12*","","00987","0000003456","JOESMITH00"

It is always 7 fields value delimited by double quote (" ") and column ...