Cut characters

[Theo_Westseit]

Hello guys,

im looking for a way in the backend script to cut 4 characters from the right and return everything beyond.

Source Data	Return
31551	3
884545	88
15003333	1500

[brunobertels · Accepted solution]

Hi 

try this (replace value in simple quote with your dimension)

trim(left('884545',len('884545')-4))

trim supress blanck space if exist

len(yourdim)-4 count the number of digit minus 4 ( 4 characters to be supressed ) 

left() return the result