topic Re: Extracting numeric values from a string in QlikView

Extracting numeric values from a string

Zaga_69 — Sat, 16 Nov 2024 02:57:36 GMT

Hi dear all,

I have a colum with the following values

I want to keep just the number after the slash. keep it mind that the characters before the slash '/' could take values likes X15, X01, X16 .. and so on..

Any idea?

Thanks!

Re: Extracting numeric values from a string

sunny_talwar — Fri, 19 Jul 2019 15:46:23 GMT

May be this

SubField(Customer_Sold_To, '/', -1) as Number

Re: Extracting numeric values from a string

Zaga_69 — Fri, 19 Jul 2019 15:53:15 GMT

Hi Sunny,

Unfortunately it does not work for all 😕

thanks in advance

Re: Extracting numeric values from a string

sunny_talwar — Fri, 19 Jul 2019 16:25:20 GMT

Is Customer_Sold_To a field or expression here?

Re: Extracting numeric values from a string

Zaga_69 — Fri, 19 Jul 2019 18:26:35 GMT

It is a field...

I shoudl mention also that I have row like this "D-HPMT-1077805" in that field...

Re: Extracting numeric values from a string

sunny_talwar — Wed, 14 Aug 2019 18:53:17 GMT

Would you extract 1077805 from this?

Also, do you have Customer_Sold_To coming from multiple tables? Did you apply the below code everywhere?

SubField(Customer_Sold_To, '/', -1) as Number