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.
mussaenda
Community Champion
Community ChampionAnonymous,
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.