topic Re: Substitute Multiple Values in QlikView

Substitute Multiple Values

Tue, 01 Apr 2014 15:58:20 GMT

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

Re: Substitute Multiple Values

MK_QSL — Tue, 01 Apr 2014 15:59:23 GMT

You can use below in script

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

Re: Substitute Multiple Values

giakoum — Tue, 01 Apr 2014 16:00:19 GMT

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

Re: Substitute Multiple Values

Tue, 01 Apr 2014 16:09:32 GMT

Thank you very much Manish & Ioannis,

Good solutions

Regards

Re: Substitute Multiple Values

matKa — Fri, 09 Oct 2020 08:53:01 GMT

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