Need formula for splitting an attribut

[#1]

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

[#2]

hi,

you can use subfield function

subfield(Name,'/',1)

Regards

Gilles

[gandalfgray · Accepted solution]

Hi Bjarne

Try

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

hth/gg

[#4]

Thank you gentleman

[#5]

Thanks gentleman