Your best way to manage erroneous codes

[Anonymous]

I download multiple Excel Access files.

There's some errouneous codes and descriptions in some columns.

For example 'not consistent', 'Not Consistent', 'Not consistant', etc...

I actually use multiple if, but I don't like it.

What's your best way to manage that ?

Is applymap adapted for that ?

[stabben23]

Hi,

You can use upper(Field) as Field or lower(Field) as Field.

This will do all text same

[Anonymous]

No there's different kind of errors like 'Not Consistent', 'Not consistant'.

[sergio0592]

Hi,

You can use WildMatch() function :

if(wildmatch(Field,'*consi*')>0,'Value_you_want', Field)

[stabben23]

oh, did not notice that

[Miguel_Angel_Baeyens]

If you are going to use QlikView Desktop to reload, you can use barryharmsen‌'s code at http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/‌

ApplyMap() does not handle regular expressions and is case sensitive, as most of QlikView functions for fields.