Flag based on 2nd position in string

[surajdhall]

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

[Frank_Hartmann · Accepted solution]

try this:

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