selecting first 5 numbers of a value and matching them with another column

[#1]

hi folks,

i want to do a new column, if the first 5 digits in batch_id are the same as the first 5 in batch_id_1 then true else false.

I can do the if statement but not sure how to select the first 5 digits.

[#2 · Accepted solution]

You can use Left() to get characters from the start of string

Names Default To Here(1);

a = "123456789";
five_char = Left(a, 5);
show(five_char);