Forum Discussion
Solved
Need 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
2 Replies
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
The cheapest might be to run two Table.ReplaceValue calls.
... #"Replaced Value" = Table.ReplaceValue(#"Previous Step","{","",Replacer.ReplaceText,{"BBP_ACTIVITYID"}), #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","}","",Replacer.ReplaceText,{"BBP_ACTIVITYID"}), ...
