How do I create a calculated field for a string starting after a certain set of characters?
I'm trying to create a calculated field from an export of email messages that will capture a string AFTER a certain character set. In other words, the field will read something like:
How do I remove my payment information from your website? ------------------ Submitted from: https://www.example.com/example
I want the output of the calculated field to be the URL (https://www.example.com/example ) for cases where both the URL and the text before "------------------ Submitted from:" can vary widely. I imagine this can be done with a SUBSTR or INSTR function (or combination thereof) but I'm not sure how to do this.
You should be able to use substring_index function.
SUBSTRING_INDEX(`description`, '------------------ Submitted from: ', -1) as url
Basically this function looks at your field value (description), finds the string you want to locate, and then the negative 1 takes everything to the right.
Hope this helps,
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Let me just recap your situation:
"How do I remove my payment information from your website? ------------------ Submitted from: https://www.example.com/example"
Assume all URLs obey the same pattern which they all start with "http://www". I think its fair assumption unless there will be two "http://www"s.
What you need to do:
1. replace `Country` with the field that contains your full text with URL inside.
Note: I know it seems like long and difficult. Free free to reply if you are still not able to or need in-depth explanation.1
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 78 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive