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 '}'

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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