Need help in data transform .

[suvechha]

Hi there,

How can I get rid of the second curly brackets in front and end and save it in another column ?

[lbendlin]

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"}),
...

[mahoneypat · Accepted solution]

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