Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this:
Load *, if(isnum(right(left(Field,2),1)),1,0) as Flag;
Load * Inline [
Field
B11AY
BT476EJ
];
try this:
Load *, if(isnum(right(left(Field,2),1)),1,0) as Flag;
Load * Inline [
Field
B11AY
BT476EJ
];