Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Trim Left is not working


HI All,


may i know where i am doing wrong in the Trimleft function.


Everything looks normal. but the output is not right.



Alteryx Certified Partner
Alteryx Certified Partner

the expression that you used will remove "2" from the start of currency. 

if you just want the first 2 characters, left(currency,2)

if you want to skip the first 2 characters, substring(currency,2,)


 otherwise please describe what you're expecting as a result. 




Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

Hi @RanjanKT,


there are different ways how you can trim a string. 


1. Use the Trim function

* Trim(x, y): Removes the character(s) in the string y from the ends of the string x. Y is optional and defaults to trimming white space. Notice in the TRIM function examples the specified characters are trimmed. It doesn't matter what order the characters are in.