Substitute Multiple Values

[#1]

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

[MK_QSL · Accepted solution]

You can use below in script

Replace(Replace(Replace(REG,' ',''),'_',''),'-','') as REG

[giakoum]

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

[#4]

Thank you very much Manish & Ioannis,

Good solutions

Regards

[matKa]

Is Replace() case sensitive? If yes is there a way to make it the other way?