Hi, Camilo and All,
Look, guys : I found a general, but difficult, regex but you, Camilo, you just pinpoint the right regex, which is quite adapted to your list. Bravo ! Moreover, against a big file, the regex engine will execute this regex faster than mime :-) I should have thought about it, some more time !
Of course, this implies that the state is a one-word, composed of two capital letters
So, instead of my complicated regex, it can be simply achieved with :
Find what : (?-i)\s([A-Z]{2},)
Replace with : ,\1
Note : I just added the (?-i), at the beginning of the regex, in order to force the regex engine to search in a sensitive way, whatever the Match case option is set or unset
About the single quotes problem, there are, usually, 3 kinds :
The usual single quote ', ( Apostrophe ) of Unicode code \x27
The ‘ ( Left single quotation mark ) of Unicode code \x{2018}
The ’ ( Right single quotation mark ) of Unicode code \x{2019}
However, I’m a bit confused, as it seems rather easy to get rid of any of these 3 characters, with the simple S/R, below :
Find what : '|\x{2018}|\x{2019}
Replace with : Leave EMPTY
Best Regards,
guy038
