Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to remove special character from string

How can i separate the special character such as ",{,} from string
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

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

    works well to seperate '{' and '}'

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

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

 

Regards,

Yuliana Gu