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
Solved! Go to Solution.
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 "<unknown>"
ENDIF
What if Column A = 5?
Chris
@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())))
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".
Thank you Chris. It worked!
Thank you. It is not about the length, it is about the Alpha numeric. Thanks for your help. I got an solution anyway.