Community

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 delimited by comma (,).

I have to convert the last column value ""JOESMITH00" to "joesmith00"
the line should look like

"0001234","CD44567","12*","","00987","0000003456","joesmith00"

There are thousands of lines - is there a regular expression that will help me achieve this by find and replace?

Thank you very much!

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 Preferences dialog box. HTH

Hi sg94k6r2

You were right about the HOW TO forum. Not the place for questions.

You still can go back and delete that item if no one has responded yet.

By coming here to the correct forum you benefit from a nice quick solution by s_reynisson. Well done!

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 Preferences dialog box. HTH[/quote]