Script to remove first 2 digits of a number

[DLM]

Hi guys -- I've a number field with numbers ranging from 3 digits up to 16 or sometimes more. Some of the numbers start with 14 and I need a script that removes such 14 and leaves the rest of the string as is.

In other words, removes the first 2 diigts as long as they are 14.

BTW, I've FM 5.5 running on SL 10.6.8.

[Vaughan]

Use the Set Field step, or use this calculation in a Replace dialog:

Case(

left( textfield , 2 ) = "14" ,

right( textfield , length( textfield ) - 2 ) ,

textfield

)

[DLM]

Use the Set Field step, or use this calculation in a Replace dialog:

Case(

left( textfield , 2 ) = "14" ,

right( textfield , length( textfield ) - 2 ) ,

textfield

)

Thanks mate! :laugh2: