This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am looking for a way to filter for values that are UPPER CASE. The goal is to identify and record where we imported the name of a county in UPPER CASE, vs. Proper Case. An example is BUTLER vs Butler. As I need to apply this to 2+ million records and there are 3,000+ counties, identifying each instance is not an option. While I could cleanse the data, I want to only write in the records that need to be updated and not all records (via SQL script), so the challenge to identify the 'cleansed' records or filter for all UPPER CASE. Thank you in advance for your help.
Normally, most of the formulas default to case insensitive, I believe, but by using the REGEX formula, you can use that 3rd parameter in the formula to make it case sensitive, so your results should split up correctly by whether or not [Field1] is all uppercase. Hope that helps!