Need to segregate Numbers and alpha numeric column

Question

I have the below data and below to that is my requirement:

Column A 1 2 3 5 6 7 8 9 AA BB CC1 DD2-1

Column B

If Column A is > 5 it should say "Individual" in column B

If Column A is <5 it should say "Common" in column B

If Column A is alphanumeric or alphabets it should say "Individual 1" in column B

ChrisTX · Accepted Answer

Try this in a Formula tool: IF ToNumber([My Field],1,1) > 5 THEN "Individual" ELSEIF ToNumber([My Field],1,1) < 5 THEN "Common" ELSEIF IsNull(ToNumber([My Field],1,1)) THEN "Individual 1" ELSE "" ENDIF What if Column A = 5? Chris

Laksh345 · Accepted Answer

Below is the data , formula used and result. It is not working.

binu_acs · Accepted Answer

@Laksh345 based on my understanding

IIF(REGEX_CountMatches([Vendor Number], '^\D+'),'Individual 1',IIF(Length([Vendor Number]) > 5,'Individual',  IIF(Length([Vendor Number])<= 5, 'Common',Null())))

ChrisTX · Accepted Answer

In the Formula tool, you are updating the value for the field "Type", which is defined as data type Boolean.

Create a new field with a string data type if you want values like "Individual".