Upper and Lower Case indentifeirs

[Arkouda]

Hi everyone 

I have a file that that has a vendor column which has has a mix of 3rd Party vendors and Employee names. 

Vendors are all in Upper Case - i.e MICROSOFT

Employee are a mix of upper/lower case letters = i.e. John Smith 

So how do I write the to show that all Upper Caps are Vendor related (tag them) and Mixed Caps equal Employee 

[kirans666]

Hi,

Can you try and use the simple workflow below? Please let me know in case it did not help. 

[Jonathan-Sherman]

Hi @Arkouda,

You could do this in one formula tool with the following formula:

IF Regex_Match([Text], Uppercase([Text]), 0)
THEN 'Vendor'
ELSE 'Employee'
ENDIF

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download in needed.

Regards,

Jonathan

[Arkouda]

Hi Jonathan 

Thank you for the prompt reply, can you show me how I would retain the column and add this new Vendor column 

i.e. Vendor      | Vendor or Employee

     Microsoft    | Vendor

    John Smith  | Employee 

[Jonathan-Sherman]

Hi @Arkouda,

(1) In your formula tool you will want to "Select Column" (highlighted yellow) and choose "+ Add Column"

(2) Type in a column name (in the highlighted box), for example Vendor

(3) Add your expression in the expression editor and run your workflow

IF Regex_Match([Text], Uppercase([Text]), 0)
THEN 'Vendor'
ELSE 'Employee'
ENDIF

Step 1:

Step 2:

Step 3:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Arkouda · Accepted solution]

that was easy 🙂

Thank you for your assistance 

George