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

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

jearls11 — Fri, 09 Jun 2023 18:04:10 GMT

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.

jthi — Sun, 31 Oct 2021 17:34:26 GMT

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