Recode in script

[Anonymous]

Hi guys,

I have field which has string value DB or DBNull and numbers.

I'd like to recode them in system missing.

I tried to use

IF(wildmatch(Field, '*DB*', ''), Field ) as Field

It didn't work.

[MK_QSL]

IF(WildMatch(Field,'*DB*),Field) as Field

[its_anandrjs · Accepted solution]

Try with this

IF(wildmatch(Field, '*DB*'),'',Field ) as Field

If found what you need blank space or some other value.