Flag based on 2nd position in string

surajdhall — Sat, 16 Nov 2024 02:43:04 GMT

Hi All,

I want to create a flag field in the table based on below condition.

If there is NUMBER in the 2nd position of below values identify as 1, similarly if there is LETTER in the 2nd position, then identify as 0.

B11AY //Number in 2nd postition from left, so flag it as 1.

BT476EJ //LETTER in 2nd postition from left, so flag it as 0

Please help

Re: Flag based on 2nd position in string

Frank_Hartmann — Sat, 17 Aug 2019 09:28:49 GMT

try this:

Load *, if(isnum(right(left(Field,2),1)),1,0) as Flag; Load * Inline [ Field B11AY BT476EJ ];