Letters and No seperation

[Former Member]

I need to figure out if l can differentiate letters from group of word(s) in a field of 7 letter words.

Field

BNNZ123

B230670

BJJJ654

COOO661

If the first 4 words are letters and starts with B then "Good". Else "NotGood".

Thank you

[amitrathi239 · Accepted solution]

use this.

=If(IsNumber(ToNumber(Substr([Field];1;1)))=0 And IsNumber(ToNumber(Substr([Field];2;1)))=0 And IsNumber(ToNumber(Substr([Field];3;1)))=0 And IsNumber(ToNumber(Substr([Field];4;1)))=0 And Substr([Field];1;1)="B") Then "Good" Else "NotGood"