Remove html encoding for characters using Notepad++

Question

I would like to change the code view for my XML template from:

&lt;p style=&quot;text-align: justify;&quot;&gt;

To:

<p style="text-align: justify;">

This is an example but it's the whole file that I need to be able to read..

What's the proper encoding language so I can read the XML file exported from MySql. I will need to edit it and re-import it. Please if you can advise, it's a huge file. — user3001925, Jan 09 '14 at 18:22

herohuyongtao · Accepted Answer · 2018-01-20T03:48:07.967

18

Use Notepad++ HTML TAG Plugin.

Check out here for step-by-step instructions.

edited Jan 20 '18 at 03:48

answered Jan 09 '14 at 18:20

herohuyongtao

Thanks a lot for your answer! I'm running the plugin right now..still waiting for the end results. Just a last question sorry, do I need to re-encode before importing back the XML file to MySql? Any idea? – user3001925 Jan 09 '14 at 18:36
@user3001925 You probably need to do this as there is no function in mySQL to decode html. Check out [here](http://stackoverflow.com/questions/3678980/is-there-a-mysql-function-to-decode-html-entities). – herohuyongtao Jan 09 '14 at 18:41
Is it normal that it takes so long to decode? It's more than 15 mins now..and still running.. – user3001925 Jan 09 '14 at 18:46
@user3001925 How large is your file? – herohuyongtao Jan 09 '14 at 18:47
It's a large file..something like 40.000 lines.. – user3001925 Jan 09 '14 at 18:52
1

@user3001925 It seems not that strange since it's so large. Give it some time. – herohuyongtao Jan 09 '14 at 18:54

1 Answers1