Website Map: Searching/classifying imported text fields?

maxgbernstein · September 25, 2012 4:50PM

I'm trying to export meta descriptions within a 'Content' text field imported using the Website Map Feed.
Below is a sample of the meta description I'm trying to Filter:

<meta name="description" content="Find breaking news, multimedia, reviews &amp; opinion on Washington, business, sports, movies, travel, books, jobs, education, real estate, cars &amp; more.">

I would like to use the search function to find the string:
<meta name="description" content=""
However, the use of double quotations in the string prevents that from being possible. Is there a way to tell Omniscope not to treat those characters as a literal part of the search formula?

maxgbernstein · September 25, 2012 4:51PM

This is the full tag I reference in the post.

meta name="description" content="Find breaking news, multimedia, reviews & opinion on Washington, business, sports, movies, travel, books, jobs, education, real estate, cars & more."

tjbate · September 26, 2012 7:18AM

Max - Are you trying to write a formula that will detect the presence of a defined string inside the text field [Content]? If so, the Contains function will return true or false, and you can use that to define the subset of rows to export/further process.

The formula would be:

CONTAINS([Target Text Field], 'meta name="description" content="Find breaking news, multimedia, reviews & opinion on Washington, business, sports, movies, travel, books, jobs, education, real estate, cars & more."' )

tjbate · September 26, 2012 7:19AM

Note the single quotes enclosing the entire string to be tested in the [Content] field.

I attach an example file

Welcome!

Categories

Ideas Parade

Tagged