Ask Your Question
0

Clean the HTML garbage code inside field

asked 2016-12-08 10:50:28 -0500

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: &'

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-12-12 11:25:04 -0500

updated 2016-12-12 11:27:17 -0500

Not sure I follow your question?

Are you asking any of the following:

  1. Character set conversion?
  2. HTML entities to their applicable characters?
  3. URL decoding?
  4. MS Word decoding?

It may depend on which RETS client you are using, and if you are using a scripting language like PHP?

Some RETS Clients have a character set encoding setting you can choose from that may help some of this.

A common issue is when someone copies and paste text from Microsoft Word into a plain text field resulting in what looks like garbled text. If your using a scripting language you can use things like HTML Entities decode, URL Decoding and filters to translate some characters.

edit flag offensive delete link more

Comments

My question is : after we download from RETS there are a lot of HTML code in our field listed. We need your group clean them in your server side. ( we use perl ) text download.

charles@ereb.com gravatar imagecharles@ereb.com ( 2016-12-12 14:59:20 -0500 )edit
0

answered 2016-12-08 10:52:01 -0500

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

edit flag offensive delete link more

Comments

removed text

Tony gravatar imageTony ( 2016-12-12 11:19:41 -0500 )edit

this HTML code, since u are online support, when i copy/past in, they become this. I put space in each charachers, it like this, & & # 8 2 1 7; ;& # 8211; & # 8212; & # 8220; & #8 221; & # 8230; & #8 216; & #8 226; & # 189; & # 188; & # 174; & #173; & #178

charles@ereb.com gravatar imagecharles@ereb.com ( 2016-12-15 14:52:02 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-12-08 10:50:28 -0500

Seen: 196 times

Last updated: Dec 12 '16