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.
Hi v-diye-msft
I think your code is just extracting the word GUID and Member ID. I actually want the text that appears after these words, so if text contains "GUID" then I want the actual ID number that appears after it.
Fortunately, the GUID or Member ID appear at the end of the API string.
Hi Anonymous ,
can you provide a sample data and your expected output so we can text and help you easier.
Thank you