Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get text between specific characters

Hi,   I'm trying to get name in a long string.  The string is like "operation = 'accept', name = 'Lucy'; operation = 'cancel', name = 'Tina'; operation = 'end', name = 'Tim'" I only want the nam...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

In the query editor, add a Custom Column with this formula 

Text.BetweenDelimiters([ColumnWithText], "'cancel', name = '", "'")

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat