Hey, I'm using the following regex to make sure we...
# administration
g
Hey, I'm using the following regex to make sure we have products without random 'corrupt' chars (or well, unicode), it's the part that's not working is \-, it doesn't seem to be recognizing this character. Does anyone know how to check for the - character? REGEXP_REPLACE({displayname}, '[a-zA-Z0-9\-\:\.\s]+', '') Thank you,
m
Did you try putting the hyphen at the start or end of the character class? https://stackoverflow.com/a/28503565
g
I'll read through your link, thank you michoel. I made a work around, which is the following: REPLACE(REGEXP_REPLACE(REPLACE({displayname}, '-', ''), '[a-zA-Z0-9\:\.\/\s]+', ''), ' ', '')
Not the best work-around, but works ha.