Unidentified symbol - Xml file construction

RA6 — Sat, 16 Nov 2024 03:31:46 GMT

Hello folks,

I have a csv file which is used to construct an xml file.

When i opened the csv file in notepad++, i see unidentified symbol:

When the xml conversion is done, the [US] is converted into 
<personalFieldValue>TGW_A320</personalFieldValue>

The problem is that the xml file which is generated has become invalid since ampersand [&] is a xml special characters.

Is there a way to find all the lines which consists of any unidentified characters [US] ?

Is there a way to remove all unidentified characters [US] ?

Is there a way to insert the ampersand [&] without crashed the structure?

Thank you.

Best regards,

asadasing

Re: Unidentified symbol - Xml file construction

fdenis — Mon, 20 Jan 2020 10:55:27 GMT

you can replace all strange char: row1.column.replaceAll("a","e")
but is your xml valid?
did you use the right charset?