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

[ramosjaqueline12]

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!

[afv2688 · Accepted solution]

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

[danilang]

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

[ramosjaqueline12]

Hi @afv2688 

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

[amazz24 · Accepted solution]

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

[ramosjaqueline12]

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

[amazz24]

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