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"...

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 E...

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 ...