last three digits from particular code

[Anonymous]

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 ?

[Anonymous]

[Anil_Babu_Samineni]

May be this?

SubField([item hd name], ' ', -1)

[mostwanted123]

Hi Saksham,

Try this,

right([item hd name],3) as [item hd name]

Regards,

Pratik

[Kushal_Chawda]

simple solution could be

LOAD ...

          right([item hd name],3) as NewField

[its_anandrjs]

Try one of this

=Right([item hd name], 3)

OR

=Subfield([item hd name], ' ',-1)

OR

=Subfield([item hd name], ' ',1)

[its_anandrjs]

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;