You need to sign in to do that
Don't have an account?
lodoss1118 Remove trailing zeros from string in formula field
How would i remove trailing zeroes (left after the first numeric char) for this 'LON00010'
Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
lodoss1118 How would i remove trailing zeroes (left after the first numeric char) for this 'LON00010'
I think you need to use FIND and SUBSTITUTE functions
https://na2.salesforce.com/help/doc/en/salesforce_formulas_cheatsheet.pdf
There's an example of the SUBSTITUTE function on Page 83 here ->
https://na1.salesforce.com/help/doc/en/salesforce_useful_formula_fields.pdf
Not sure if this help though for example find only finds the first match not the last one, not sure how to do this?
Hey,
Not excatly trailing but below code will replace all the spaces from your string:
strName.replace(' ','');