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

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