BeastMode: Field contains lower case
Best Answer
-
@swagner What if you did this?
case
when `Description` = UPPER(`Description`) then 'All upper'
else 'Contains lowercase'
endIf your descriptions come in as all uppercase then it should match on the first when statement. Otherwise it wouldn't match because your description contains a lowercase letter and fall into the else condition.
I haven't tested, but hope it helps.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.5
Answers
-
I don't think this is doable with a regular expression in a Beast Mode however you can utilize a Magic ETL data flow with a replace text tile and a regex to remove any non-lowercase characters and then check if the value is NULL or not to determine if it doesn't or does have lowercase characters in it.
Another option is to utilize a MySQL dataflow instead:
select `holidayDescr`
, case when `holidayDescr` REGEXP '[a-z]' then 'Y' else 'N' end as has_lowercase
from `calendar_dates`**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I suppose technically you could do a really long case statement based on each letter in the alphabet.
case when `Description` like '%a%' OR
`Description` like '%b%' OR
`Description` like '%c%' OR
`Description` like '%d%' OR
`Description` like '%e%' OR
`Description` like '%f%' OR
`Description` like '%g%' OR
`Description` like '%h%' OR
`Description` like '%i%' OR
`Description` like '%j%' OR
`Description` like '%k%' OR
`Description` like '%l%' OR
`Description` like '%m%' OR
`Description` like '%n%' OR
`Description` like '%o%' OR
`Description` like '%p%' OR
`Description` like '%q%' OR
`Description` like '%r%' OR
`Description` like '%s%' OR
`Description` like '%t%' OR
`Description` like '%u%' OR
`Description` like '%v%' OR
`Description` like '%w%' OR
`Description` like '%x%' OR
`Description` like '%y%' OR
`Description` like '%z%' THEN 'Y' ELSE 'N' END**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@swagner What if you did this?
case
when `Description` = UPPER(`Description`) then 'All upper'
else 'Contains lowercase'
endIf your descriptions come in as all uppercase then it should match on the first when statement. Otherwise it wouldn't match because your description contains a lowercase letter and fall into the else condition.
I haven't tested, but hope it helps.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.5 -
Of course I overthink the whole thing. @MarkSnodgrass has a much cleaner solution.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@MarkSnodgrass THANKS!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive