vendredi 15 juillet 2016

How to cut unknown symbol from String?

I have this string <Response><ID>123!!45</ID><status>ok</status></Response>

I need to convert XML format but I can't convert because this string has "!!", I have many rows, so I can't use replace or other string function because my XML structure has many nodes and I don't know exactly where is unknown symbol, also my string doesn't has same unknown symbol.

In additional when I select this row I can see unknown symbol but whenever I copy this row to query this symbol automatically disappear.

Aucun commentaire:

Enregistrer un commentaire