Is there a fucntion or formula that I can use that will mimic the the LEFT function in Excel? I am trying to pull the first 5 charactors from a string ?
Thank you in advance!
LEFT([STRING],5)
Thank you so much and "DUH" to myself! I did have brackets intially.
Mark, what if you had this:
"Trying to find the first position of o"
In excel, you can search the string and get back that the first "o" is at position 9 (might be 8. I don't remember if search is 0 based).
I have a situation in Alteryx where I'm trying to find a character "|". I'd like to do something like --> right([fieldname],length([FieldName])-search([fieldname],'|'))
I am using the below function but I am getting error
Left([GL Account Number], 1)
Below is the error
