431789_en-US

liliconcom

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

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.

 

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

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);