I am not sure if this option was available in 2015 but as of today the easier way to do this would be with the use of one of the text functions with the EVAL command. Usage: substr(<str>,<start>,<length>) In your case: | eval n=substr("your_string", 1, 3)
... View more