Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field in my database that I need "cleaned out" for certain values. The data is not very good because of a lack of a validation process in when it is uploaded. I need to therefore build into my upload statement a statement that removes the following; gaps, underscore character, dash character.
The field is called REG.
Thank you
Herbiec
You can use below in script
Replace(Replace(Replace(REG,' ',''),'_',''),'-','') as REG
You can use below in script
Replace(Replace(Replace(REG,' ',''),'_',''),'-','') as REG
use wildmatch : if wildmatch(REG, ...., replace with this, keep field)
wildmatch( str, expr1 [ , expr2,...exprN ] )
The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.
Example:
wildmatch( M, 'ja*','fe?','mar')
returns 1 if M = January
returns 2 if M = fex
Thank you very much Manish & Ioannis,
Good solutions
Regards
Is Replace() case sensitive? If yes is there a way to make it the other way?