1. If you need a sub-string from starting of the value.
leftstr("string value or field", < length of string >)
2. If you need a sub-string from ending of the value.
rightstr("string value or field", < length of string >)
3. If you need a sub-string from the middle of the string.
midstr("string value or field", < length of string >)