Upper and Lower Case indentifeirs

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

Preparation

Accepted answers

that was easy 🙂

Thank you for your assistance

George

Hi,

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

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

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