Is there a way to clean the values in the column to just have A-Z 0-9 and _ ?
In python/regex I run
def Alphanumeric(string): import re clean_string=re.sub(r'[^a-zA-Z0-9_]', '', string) return clean_string
I need to do this in Mapinfo as an update column. I see something close in http://nyalldawson.net/2013/05/regular-expressions-in-mapbasic/ and am in the process of exploring this.
Additionally, I know I can run InStr() for each of these values but I am hoping for a one-liner.