Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be this
SubField(Customer_Sold_To, '/', -1) as Number
Hi Sunny,
Unfortunately it does not work for all 😕
thanks in advance
Is Customer_Sold_To a field or expression here?
It is a field...
I shoudl mention also that I have row like this "D-HPMT-1077805" in that field...
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