topic Re: seperate code from description in QlikView

seperate code from description

Fri, 29 May 2015 12:48:31 GMT

I would like to remove a color code from its total description

Our color description is 001 Black and I would like to create a field only showing Black.

I tried to exclude this via the left function, but this leads not to the correct results.

thanks for your help in advance

Patrick

Re: seperate code from description

rwunderlich — Fri, 29 May 2015 16:43:01 GMT

If all colors follow that pattern: number followed by the text, you should be able to:

=mid(myfield, index(myfield, ' ')+1)

-Rob

Re: seperate code from description

maxgro — Fri, 29 May 2015 16:48:32 GMT

if ' ' is always there

=subfield('001 Black', ' ', 2)

replace '001 Black' with your field

Re: seperate code from description

rwunderlich — Fri, 29 May 2015 17:01:24 GMT

What if the color is "002 Dark Blue"?

Re: seperate code from description

maxgro — Fri, 29 May 2015 17:11:33 GMT

Dark

Error

Re: seperate code from description

rwunderlich — Fri, 29 May 2015 20:10:19 GMT

I meant to point out that the subfield() method wouldn't work with a multi-word color

-Rob

Re: seperate code from description

sebastiandperei — Fri, 29 May 2015 20:33:20 GMT

There are different posibilities, based on your data.

If your format is everytime: [code][space][color], I guess Massimo and Rob solutions are what you need (if you have multi-word colours, only Rob's one works)

If you haven't everytime ONE space between code and colour, you could use Mid(Purgechar(field,'0123456789'),1)

I think that if you send the different types of values you have, it wil be easier.

Re: seperate code from description

maxgro — Fri, 29 May 2015 21:41:12 GMT

yes, for a one word color my answer works, for a multi-word it doesn't, it's an Error

Re: seperate code from description

Sun, 07 Jun 2015 06:35:55 GMT

Dear Rob,

this was very helpful input. It solved my problem.

Many thanks

Patrick