Forum Discussion
Conditional Split Column by delimiter based on value
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
Please give me some examples.
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.
