Trim

[sbb]

How do I trim leading or trailing spaces from input data? What is the formula?

Thank you.

[jdunkerley79 · Accepted solution]

There are three functions:

• Trim (trims both start and end)
• TrimLeft (trims start)
• TrimRight (trims end)

You can use a formula tool to trim a single field and either override the original or store in a new field, e,g.

TRIM([TextField])

Or you can use a multi-field formula to do all at once.

TRIM([_CurrentField_])

If you untick Copy Output Fields ... it will override the original,

[sbb]

Thank you.

[brendafos]

THANKS

I just used the Multi-Field and cleaned a whole score of fields - magic.