Clean the HTML garbage code inside field

edit

For clean “HTML code”, I list the detail message to you according to each download field name. ( we have hundreds “HTML code” in our system )

1) Field name: #LM_char100_6

Clean HTML code: &amp &apos

2) Field name: LM_Char10_2

Clean HTML code: &amp &apos

3) Field name: LM_Dec_1(RE_1) LM_Dec_28(CM_4) L_NumAcres(RU_2) Clean HTML code: &apos

4) Field name: LM_Dec_3 (RU_2,RE_1) LM_int4_35 (CM_4) Clean HTML code: &apos

5) Field name: LM_Char25_4 (RU_2,RE_1) Clean HTML code: &apos

6) Field name: LR_remarks55 Clean HTML code: &’–—“”…‘ •½¼®­²éçè 졠ؾ'"><

7) Field name: LR_remarks66 Clean HTML code: &"'’“–—‘” …®² ×<>

8) Field name: VT_ExtVTourURL5 Clean HTML code: &amp

9) Field name: VT_VTourURL Clean HTML code: &é

10) Field name: VT_ExtVTourURL1, VT_ExtVTourURL3, VT_ExtVTourURL2 Clean HTML code: &'