Hi Pandey Ji,

You said that you want to replace "\" "  to " " " and than you said there is some data you dont want to replace it . Could you please elaborate your use case a little more so that i can look for solution.

Any example will be great !

Regards,

-PJ-

Hi Pramod,

Please see the sample data below

"{""load"":""{\""row1\"":{\""col1\"":\""99978444P\"",\""col2\"":\""99978444P\"",\""col3\"":\""99978444P\"",\""pascodeid\"":\""n\VOL3PL-TK2nh\ZXjXN5QV*6RM""}"

We have a column named passcodeid . It consist of value that can have special characters like \ .- ,* in it.

I don't want to remove it.

Thanks

So you trying to get valid JSON or is there some other use case?

To get valid JSON from you example use the following;

Use the following replace rules;

1. \"" to "
2. "" to "
3. "{ to {
4. }" to }

You example is missing 2 } at the very end of the json. If you follow these rules in this order and then add the 2} you should get valid json. It's is possible that your parser will nag about the invalid escapes in the pascodeid field though, that's not really up to spec.

Good luck,

Vincent

In addition, in OutSystems, if you want a single (that is, one) double quote inside a Text, you acually type two. So to replace \" by ", you use

Replace(MyText, "\""", """")

You're welcome :). It's one of those things you just need to know :). Happy coding!