Alteryx - String Functions - Trim and Pad

The first in a new series of content focused on string functions. In this session, I'll walk through the basic use of the Trim and Pad functions.
00:25 - Start of Trim Function
05.27 - Start of Pad Function
#Alteryx #Trim #Pad #NPT

[@neelimakammila7891]

I am sure ....you will make Alteryxians SME's with your amazing videos.. Thank you for sharing the knowledge

[@NPT]

You're welcome, Neelima.

[@jonwlawley]

Can I use TRIMRIGHT to remove a space and a character? If not what do you do you recommend? Appreciate the help!

[@Laxmanmane007]

Hi Nathan, Could you please upload video on Connectors, Calagry, Predactive analysis if possible

[@azadcavdar8610]

Excellent!

[@NPT]

Thanks Azad!

[@raghureddy5815]

Hi Nathan:
Great content. As a newbie wading my toes into ETL, I am learning so much from your videos.
If you have the time, would you walk us through how to scrape web data with APIs? I tried a combination with download tool and JSON parser. I would love to see an example with Quandl API or FRED API.
Thanks again for all your efforts

[@NPT]

Great suggestion, Raghu! The Download Tool is a bit tricky. I'll see what I can dig up for new content.

[@tommyprimm4693]

Hello Nathan! How do you insert a space inside a string? My output shows total sales by US state. Currently, it shows: ALTotal, AZTotal, CATotal. I would like to have: AL Total, AZ Total, CA Total. My current formula is: [State] + "Total" I only need one space between the state abbreviation and the word "Total". Thank you!!!

[@NPT]

Hi Tommy, you can add the space in the word Total like this " Total".

[@tommyprimm4693]

@@NPT It worked! Such a simple solution to a nagging problem. You're the BEST! Thank you!!!

[@NPT]

You're welcome@@tommyprimm4693. Yes, you gotta love the simple stuff. 👍

[@Laxmanmane007]

👍

[@NPT]

Thanks Lucky!