Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.