Skip to Content

Letters and No seperation

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 27, 2017 at 07:40 PM

    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"

    Add comment
    10|10000 characters needed characters exceeded