Forum Discussion
suvechha
Helper IV
Helper IVNeed help in data transform .
Hi there, How can I get rid of the second curly brackets in front and end and save it in another column ?
In the query editor on the Add Column tab, select your column and choose Extract/Text Between Delimiters and put { and } in the pop-up fields.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeIn the query editor on the Add Column tab, select your column and choose Extract/Text Between Delimiters and put { and } in the pop-up fields.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat