Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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