topic Re: Replace string * in load script in QlikView

Replace string * in load script

Thu, 11 Feb 2016 14:00:33 GMT

Dear experts,

in load script I want to replace one string and it doesn't work:

In the column ItsTestColu I have different values: AVI SU, AVI SUS, AVI SUU...

I want to reset this all "AVI S*" through "AVI"

LOAD replace(ItsTestColu, 'AVI SU*', 'AVI') as Test2,

FROM ...

Why * is not working ?

I try it also with wildmatch, and it is also not working:

replace(ItsTestColu, wildmatch(ItsTestColu, 'AVI SU*'), 'AVI')

In this load script I cannot and I don't want use somethin LEFT.. I just want to use "ALL" / " * "

Kind regards,

sunny_talwar — Thu, 11 Feb 2016 16:16:26 GMT

May be try this:

If(Left(ItsTestColu, 7) = 'AVI SU', 'AVI', ItsTestColu) as Test2

tamilarasu — Thu, 11 Feb 2016 16:29:02 GMT

Andre,

You can also try,

If(WILDMATCH(ItstestColu, 'AVI SU*'),'AVI',ItsTestColu) as Test2

rwunderlich — Thu, 11 Feb 2016 19:05:52 GMT

Replace() is the wrong function to use here. replace() replaces individual characters, not strings. Instead use:

if(ItsTestColu LIKE 'AVI SU*', 'AVI', ItsTestColu) as ItsTestColu

-Rob