function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Remove trailing zeros from string in formula field

How would i remove trailing zeroes (left after the first numeric char) for this 'LON00010'

Steve :-/Steve :-/

I think you need to use FIND and SUBSTITUTE functions 


There's an example of the SUBSTITUTE function on Page 83 here ->


Not sure if this help though for example find only finds the first match not the last one, not sure how to do this?




Not excatly trailing but below code will replace all the spaces from your string:


strName.replace(' ','');