Skip to Content
0

Letters and No seperation

Jan 27, 2017 at 04:52 PM

45

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Jan 27, 2017 at 07:40 PM
0

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"

Share
10 |10000 characters needed characters left characters exceeded