Using SubField Function to Extract String Value

[KKumar92]

This is a sample of the data set I am processing,

Product Id

AC1320ABC

EC3210ECD

BC1250RED

BC3500CED

I want to create a Field as "Product" and it should only contain the Last Three String of the Product_ID as follow;

Product Id	Product
AC1320ABC	ABC
EC3210ECD	ECD
BC1250RED	RED
BC3500CED	CED

I have used the below script, but it does not generate the expected answer.

SubField(if(Index(Product_ID,'0')=0,Product_ID,
Mid(Product_ID,1,Index(Product_ID,'0',1)-1)),'|') as Product,

Please advise on this, appreciate your support and guidance.

[MayilVahanan · Accepted solution]

HI @KKumar92 

Try with Right() function.

ex: Right([Product Id],3) 

[KKumar92]

Thank You @MayilVahanan  , it is working.