Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

Regular expression pattern macth to weed out words with HTML character codes & entities

I have a file that is riddled with words containing HTML character codes & entities such as: Müller, Étre or "Flying—High" -- however, there's also a lot of junk ones that need to corrected such as Teenage��������s or &sup1dsjÝhccbß

I'm using a perl script, so what would be a good regular expression to match these words with HTML codes & entities? Thanks
0
hadrons
Asked:
hadrons
  • 2
  • 2
  • 2
  • +1
1 Solution
 
wilcoxonCommented:
If you just want to match words with escape sequences in the middle then this should work:
m{((?:\w+(?:&(?:#\d+|[a-z]+);)+)+\w*)}

Open in new window


That will match a word with one or more escapes (either in a row or separated by letters).  It will not match words with the escape at the beginning of the word.
0
 
Dr. KlahnPrincipal Software EngineerCommented:
I am not sure that there is a simple solution to this one.  But here's a start.  The numeric entities expressed in decimal can be matched by

&\#[0-9]+;

Open in new window


Unfortunately this doesn't match numeric entities expressed in hex, and it also does matches entities you probably want to retain that are expressed in numeric form rather than by the HTML name.  For example, it matches the numeric for the euro symbol, and you would probably not want to throw that character out.

&euro; <== interchangeable with ==> &#8364;

Open in new window


If this is a one-off situation, it might be easier to go through the file with a text editor to knock out the obvious and frequently unwanted entities, then see how the result looks.
0
 
wilcoxonCommented:
I had forgotten that you can have hex.  This should also pick up hex (and correct to allow numbers in entity names):
m{((?:\w+(?:&(?:#[0-9a-f]+|[a-z]\w*);)+)+\w*)}

Open in new window


Isn't a semi-colon required to end an escape sequence?  Your "bad" example has &sup1dsj without a closing semi-colon.

If you want to keep some and remove others, there is no really easy way.  The simplest would be either a list of ones to keep or a hash map indicating which to keep and which to get rid of (but then you have to process them one by one).
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Kim WalkerWeb Programmer/TechnicianCommented:
I have a file that is riddled with words containing HTML character codes...
If you only have one file, why not use a text editor for a one-time conversion. One of my favorite code editors, EditPad Pro, has the functionality to convert HTML character entities into unicode characters. A free trial version of EditPad Pro is available which is fully functional except for Spell Checker. I'm sure there are others out there that might be free.
0
 
hadronsAuthor Commented:
Hi, Kim, actually a bunch of files and it's ones I work with on a regular basis, but that info was unimportant to the question itself, so I just simplified the narrative - however, thanks for the EditPadPro - its something that could be useful in the future.

Dr. Klahn, I did use an expression similar to what you suggested: \&\#[0-9A-Za-z]+?; with various other expressions, but its somewhat limited.

But I'll follow up on Wilcoxon suggestion - it looks promising, but I have to wait until Monday. Thanks for the feedback all so far; Mike
0
 
Kim WalkerWeb Programmer/TechnicianCommented:
Are you trying to convert the entities to their unicode character or are you trying to strip them out? You will not be able to convert them using a regex. But you can search for the regex match and then perform a lookup/replace from a reference table.
0
 
hadronsAuthor Commented:
The match is needed to isolate these words so I can grep them out and look them over
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now