Beast Mode Approach to Eliminate Field Character

I have a data set of email addresses and i've used a beast mode calc to create a new field for the domains.
RIGHT(Sent Email
,((LENGTH(Sent Email
))-(INSTR(Sent Email
,'@'))))
The issue I'm having is that some of the email values also include the bracketed name of the user so some
of the results are coming back looking like this:
hotmail.com>
gmail.com>
Is there an additional beast mode calc i can do against this new field I've created to eliminate that character when it exists. When it is there, its always the last character.
I'm non-tech, have zip experience in ETL and have my available dev team members focused on outward (client) facing priorities. My hope is there is a beast mode approach as I'm gaining familiarity there.
Thanks so much.
Best Answers
-
@afieweger If it is always the same character that is showing up, then you can wrap your entire statement in a REPLACE function to remove all instances of the '>' character like this:
REPLACE(RIGHT(`Sent Email`,((LENGTH(`Sent Email`))-(INSTR(`Sent Email`,'@')))),'<','')
1 -
@MichelleH has what I would have suggested, but she mistyped the character you are looking for. :)
Should be:
REPLACE
(
RIGHT
(`Sent Email`,((
LENGTH
(`Sent Email`))-(
INSTR
(`Sent Email`,'@')))),'>','')
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
@afieweger If it is always the same character that is showing up, then you can wrap your entire statement in a REPLACE function to remove all instances of the '>' character like this:
REPLACE(RIGHT(`Sent Email`,((LENGTH(`Sent Email`))-(INSTR(`Sent Email`,'@')))),'<','')
1 -
LEFT(new field ,LENGTH(new field)-1)
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU! 😎😎😎
0 -
@MichelleH has what I would have suggested, but she mistyped the character you are looking for. :)
Should be:
REPLACE
(
RIGHT
(`Sent Email`,((
LENGTH
(`Sent Email`))-(
INSTR
(`Sent Email`,'@')))),'>','')
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
Good catch @MarkSnodgrass!
1 -
You guys rock. Thanks all for the help. Working perfectly!
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive