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