topic Need formula for splitting an attribut in QlikView

Need formula for splitting an attribut

Wed, 14 Sep 2011 08:01:29 GMT

Hi All

I need some help to find a useful function.

I have an attribut in my load called name and that is equl to articlenumber and collisize. Ex. = 1005123/4 I need only the article number, so I need to split this attribut by using a function. I could use Left(Name,7), but the problem is that article number could be with 7-8-9-10 digtigs and colliesize can also be with 1-2-3 digtigs. So I need the function that can split this attribut (name) at the "/" in my script.

Somebody that knows the solution to this?

Best regards

Bjarne

Need formula for splitting an attribut

Wed, 14 Sep 2011 08:09:45 GMT

hi,

you can use subfield function

subfield(Name,'/',1)

Regards

Gilles

Need formula for splitting an attribut

gandalfgray — Wed, 14 Sep 2011 08:14:02 GMT

Hi Bjarne

Try

subfield(Name, '/', 1) As ArticleNumber

hth/gg

Need formula for splitting an attribut

Wed, 14 Sep 2011 08:28:54 GMT

Thank you gentleman

Re: Need formula for splitting an attribut

Wed, 14 Sep 2011 08:30:48 GMT

Thanks gentleman