Additional String Manipulation Functions in BeastMode
I would like a more robust set of string functions available for BeastMode calculations. Having to continuously go back to the dataflow and use SQL to create new fields is slow, inefficient, and doesn't let me utilize the ETL dataflow type.
A few common string functions that I would like to see incorporated are:
Length('String')-- returns the length of the string
Left('String', # of characters to return)-- returns the first x number of characters in the string
Right('String, # of characters to return)-- returns the last x number of characters in the string
Find('String', Start Character #, 'Sub-string')-- returns the location of first instance of the substring in the original string starting after the start character number
Replace('Orgin String', 'Characters to be replaced', Characters to do the replacing')-- Replaces the any instance of the 2nd input with the 3rd input.
Char(ASCII Number)-- Returns the character associated with the inputted ASCII number
Comments
-
Now, I'm not saying there's a conspiracy afoot <::looks around cautiously::>, but...
quite by accident I discovered that standard MySQL functions work just fine in BeastMode even though they are not alluded to within the BeastMode functions that are presented for use. See a small example of ones off your posted list, or try other standard functions (MySQL 5.7 Reference Manual [online]).
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"0 -
Wow, great find! Basic string manipulation functions are hidden, but date functions are duplicated? Better bust out your tin foil hats....
0 -
Length, Left, Right, Replace, INSTR are now all available in Beast Mode UI.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有