Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I want to extract last three digits(ie 100 as given in figure) from the following (item hd name) marked in red in the image . what will be the expression for the same and where to write that expression ?
May be this?
SubField([item hd name], ' ', -1)
Hi Saksham,
Try this,
right([item hd name],3) as [item hd name]
Regards,
Pratik
simple solution could be
LOAD ...
right([item hd name],3) as NewField
Try one of this
=Right([item hd name], 3)
OR
=Subfield([item hd name], ' ',-1)
OR
=Subfield([item hd name], ' ',1)
Or may be you can try this for
Load
Right([item hd name], 3) as OptionOne,
NUM(Right([item hd name], 3)) as OptionTwo
From Source;