Alteryx designer Discussions

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

LEFT function parse error for both number and text on a cell

Highlighted
6 - Meteoroid

Hi - I am trying to use the LEFT function to get the first 8 numbers of the below cells. On excel I was using a simple "=Left(A2,8)" formula but it is not working with Alteryx. I tried using the =TrimLeft(ToString([Concur Expense Purpose  Purpose]),"8") formula and it didn't work either.

 

I would like to have a column were I can have the Concur ID only. Is there a way I can do this? Thanks!

 

 
Highlighted
6 - Meteoroid
 
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @ramosjaqueline12 ,

 

You can use this:

Left([Concur Expense Purpose Purpose], 

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Highlighted
17 - Castor
17 - Castor

Hi @ramosjaqueline12 

 

As an addition to @afv2688's solution, the TrimLeft(String,chars) function is used to remove characters from the start of a string.  In your case, it will remove all the "8" characters, so "8888ABCDEFG" would become "ABCDEFG".  

 

Dan

Highlighted
6 - Meteoroid

Hi @afv2688 

 

I tried the solution suggested and I still receive a Parse Error message. See below for screenshots I took.

 

error.PNG

 

formula.PNG

 

Highlighted
7 - Meteor

Hi @ramosjaqueline12 -  Remove the '=' from your formula

Highlighted
6 - Meteoroid

That was way to easy, but I am still learning that this is not Excel. Thanks so much!

Highlighted
7 - Meteor

No problem - it definitely takes some time to get used to!

Labels