I would like to trim down a field to 5 characters using an Excel Left Logic. I have read some suggestions to use LEN, but the length of the field is not fixed.
In Python I would do something like this:
newvariable = 'blahblahblah'
| eval newvariable=substr(newvariable,1,5)
There are many examples here:
I believe what you are looking for is "substr"