Check 6th Digit in column

[#1]

I have a column ID in my data set, I need to check if the 6^th digit is “6” then I need to mention the number as territory1 otherwise it’s Territory2.

E.g. 4587144 is Territory2 and 4125761 is Territory1

[Chanty4u]

try this am not sure

match:

LOAD * INLINE [

    data

     4587144

    4125761

];

LOAD *,

pick(Right(data, '6'), 'ter', 'ter2')

Resident match;

[#3]

Not working