Set condition for those with 7characters only

Requesting your urgent help to provide the right formula or condition to identify each item. My condition is here:

If ID is equal to 7characters then that the Tagging is "Staff" but if its starts with 3 zeroes (or more than 7 characters) then its a "vendor".

Input and Output sample:

ID - Tagging

1655222 - Staff

000632563 - vendor

000235103658 - vendor

Thanks

Datasets

Input

Custom Tools

Best Practices

Data Investigation

Accepted answers

AshRez

if Length([ID]) = 7 then "Staff"

elseIf Left([ID],3) = "000" and Length([ID]) > 7 then "Vendor"

else "Unknown"

EndIF

All comments

AshRez

if Length([ID]) = 7 then "Staff"

elseIf Left([ID],3) = "000" and Length([ID]) > 7 then "Vendor"

else "Unknown"

EndIF

alexnajm

A conditional IF statement in a Formula tool will do the trick! There are functions like Length and StartsWith that will help

binu_acs

IF Length([ID]) = 7 THEN "Staff"
ELSEIF StartsWith([ID], "000") OR Length([ID]) > 7 THEN "Vendor"
ELSE "Unknown"
ENDIF

@PassION_es make sure your ID field is string data type , if it is integer then you need to use either toString() function or add a select tool then change the data type to string

PassION_es

Thank you all. Yes @binu_acs , it is string data type.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335