02-23-2016 08:53 PM
I am processing people names, and I find sometimes the names are in native language. For example, names are spelled like "André " or "Martínez". Currently I am manually tranforming such names into English one by one (e.g. "Andre" or "Martinez"), but there are so many names that I feel a little overwhelmed. I would really appreciate it if someone could kindly teach me a quicker way. Thank you very much in advance.
02-23-2016 09:52 PM
If your problem is caused by different language encodings then this paper may help, in particular the conversion macro included:
02-24-2016 05:23 AM
Well, its a tricky one, as names could be anything. My suggestion would be to create a coded list. To do this, do a select distinct values of name from your dataset. Then go through the distinct list and add in the decoded value, e.g.:
Then simply use that coded list to replce the original. I would imagine that you will need to do at least some manual review, I mean you could setup some programmatic conversions, but some will just be really random.
02-24-2016 11:24 AM
Thank you very much for the useful tip. In order to use the function of BASEDCHAR, should I install "National Language Support (NLS)" as an addition? Since currently the log suggests that "The function BASECHAR is unknown, or cannot be accessed"...