How do I create a filter to show only the UPPERCASE records in a spreadsheet?
I am importing a CSV file. It has both UPPERCASE and lowercase entries in a single column. I would like to filter out all the records that are not UPPERCASE. The end result would be that all mixed case and lowercase entries would NOT be displayed.
Best Answer
-
Hi @PSMTQsecofr
You can use a beast mode to do something similar. MySQL / Beast Modes have access to the UPPER and LOWER functions however there is no function to Proper Case a string so this defaults to "Mixed Case" if it's not either upper or lower case. It should still solve your issue of wanting to filter only Upper Case records. You'd just need to add the beast mode to your filter in the analyzer when designing your card.
CASE WHEN `field` = UPPER(`field`) THEN 'Upper Case' WHEN `field` = LOWER(`field`) THEN 'Lower Case' ELSE 'Mixed Case' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3
Answers
-
This is the Excel command to identify fields by case.
=IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case",IF(EXACT(A2,PROPER(A2)),"Proper Case","Other")))
0 -
Hi @PSMTQsecofr
You can use a beast mode to do something similar. MySQL / Beast Modes have access to the UPPER and LOWER functions however there is no function to Proper Case a string so this defaults to "Mixed Case" if it's not either upper or lower case. It should still solve your issue of wanting to filter only Upper Case records. You'd just need to add the beast mode to your filter in the analyzer when designing your card.
CASE WHEN `field` = UPPER(`field`) THEN 'Upper Case' WHEN `field` = LOWER(`field`) THEN 'Lower Case' ELSE 'Mixed Case' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3 -
Thanks. I'll give it a go and post my results.
0 -
Got me to where I needed to go, Thanks!
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 555 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 566 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive