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!
Solved! Go to 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
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
Hi @afv2688
I tried the solution suggested and I still receive a Parse Error message. See below for screenshots I took.
Hi @ramosjaqueline12 - Remove the '=' from your formula
That was way to easy, but I am still learning that this is not Excel. Thanks so much!
No problem - it definitely takes some time to get used to!