cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gokul Member
Member

How to remove special character from string

pbisssue.png

How can i separate the special character such as ",{,} from string

1 ACCEPTED SOLUTION

Accepted Solutions
Gokul Member
Member

Re: How to remove special character from string

Column = SUBSTITUTE(SUBSTITUTE(feedback[key_phrases - Copy],"{",""),"}","")

works well to seperate '{' and '}'

2 REPLIES 2
Gokul Member
Member

Re: How to remove special character from string

Column = SUBSTITUTE(SUBSTITUTE(feedback[key_phrases - Copy],"{",""),"}","")

works well to seperate '{' and '}'

Community Support Team
Community Support Team

Re: How to remove special character from string

Hi @Gokul,

 

Glad to hear that you have worked it out by yoursefl. And thanks for your sharing solution.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.