Forum Discussion
Conditional Split Column by delimiter based on value
I'm doing some cheeky data modelling in Query Editor, I have a column which basically holds an API call - which includes useful information I want split out. Therefore I'm trying to create a con...
The solution I used was to Extract Text Between Delimeters:
Under Add Columns in Query Editor, Extract - Text Between Delimiters - and I entered the text string before and after the value I wanted to extract.
This will only work if the text string is consistent.
It's ok I figured out how to do it myself!
Thanks anyway
Anonymous,
if you have figured it out yourself, It will be better to share it here then mark it as a solution so others can also rely on your solution.
Thank you.
The solution I used was to Extract Text Between Delimeters:
Under Add Columns in Query Editor, Extract - Text Between Delimiters - and I entered the text string before and after the value I wanted to extract.
This will only work if the text string is consistent.