Extracting numeric values from a string

[Zaga_69]

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!

[sunny_talwar]

May be this

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

[Zaga_69]

Hi Sunny,

Unfortunately it does not work for all  😕

thanks in advance

[sunny_talwar]

Is Customer_Sold_To a field or expression here?

[Zaga_69]

It is a field...

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

[sunny_talwar]

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