Okay, this may be a shot in the dark but hopefully someone can guide me in the right direction? What I'm trying to do is detect a name in a text field. The problem is that I do not have a potential list of names to match it to. I can look for a set number of characters together and output a dataset and review to see if they are in fact names but this is not ideal when you are looking through millions of records. A more automated approach would be preferred. So a bit of background that may help: Peoples name have been put into a unique identifier field. This is considered sensitive information and we need to strip the names from this variable. The variable is a text field and can contain any combination of numbers or characters. We do not want to strip anything that may not be a name because having unique identifiers are needed to do analytical work. Any suggestions??? Thanks so much!
... View more