« The secret to reviewing your Google Shopping queries | Main | Analysis of Google's acquisition of Channel Intelligence »

Dec 19, 2012

A Holiday Gift from The Feed Doctor

Anthony santa

The other day someone asked me for help writing a rule. She had text with “accented” characters, and wanted to replace them with the non-accented version. For example, she wanted to change the word “Résumé” to “Resume.”

But it was even worse than that. Her text was actually “html encoded.” This is a way of converting “special characters” so that web browsers render them properly. For example, the ampersand is a special character, so it might look like & in an html file. In her case, instead of “Résumé” she actually had “Résumeé”

It turns out I couldn’t think of a good solution, and I hate it when that happens. So I sat down and wrote two new functions: HTMLDECODE and TRANSLIT.

First, HTMLDECODE will convert the encoded special characters into their true form; e.g., it converts “Résumeé” into “Résumé.” Next, TRANSLIT (which is short for “transliterate”) converts the “accented” characters to non-accented ones; so it would convert “Résumé” to “Resume.”

Now, I could have made a single function that does both, but just in case you want one and not the other, I made them distinct. You can of course combine them, like this:

TRANSLIT(HTMLDECODE(“Résumé”)

These functions will be available with our January software update. Enjoy!

Blogpost by Anthony Alford, The Feed Doctor

 


Us-wp-top-5-cse-myths-emailLooking for more information on Comparison Shopping?

Comparison Shopping Misconceptions: Don't Let These Missteps Trip Up Your Strategy

This white paper covers common comparison shopping misconceptions to make sure you're not making mistakes with your CSE strategy.  




 

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341d136453ef017ee66aa337970d

Listed below are links to weblogs that reference A Holiday Gift from The Feed Doctor:

blog comments powered by Disqus