Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Trim

sbb
7 - Meteor

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

 

Thank you.

3 REPLIES 3
jdunkerley79
ACE Emeritus
ACE Emeritus

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
7 - Meteor

Thank you.

brendafos
10 - Fireball

THANKS

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

Labels