I
iamdave
I have a problem. I need to take a spreadsheet that had a e-commerce
site's information and transpose that to another spreadsheet. This
information includes meta tag and html markup in one spreadsheet. The
other spreadhseet doesn't use the html and also takes what was all in
one cell and has it split in
1st spreadhseet example:
(all this is in one cell)
<meta NAME="description" CONTENT="1 Spot Adapter. Visual Sound 1 Spot
9V DC Adapter at the lowest price! X store ships all over the US
including ohio, pennsylvania, illinois, new, york, jersey, california,
florida, texas and more. Trust x store for the lowest prices, largest
selection and best service."> <meta NAME="keywords" CONTENT="1, Spot,
Adapter, one, Visual, Sound, 9V, DC, Adapter, lowest, prices, on,
line, store, ohio, pennsylvania, illinois, new, york, jersey,
california, florida, texas, on-line, discount, retail, best, for,
and"> <META name="RATING" content="General"> <META name="ROBOTS"
content="index,follow"><META NAME="REVISIT-AFTER" CONTENT="2 weeks">
Needs to go a new spreadsheet
one cell is for meta description, one for keywords with NO HTML markup
and no rating, revist etc. info
So the question is how do I pull out the meta description with no html
markup and transport that to one cell, delete the rest of html markup
and also pull out the keywords info to another cell? I think the
trickist part is that each description and keyword will not start with
nor contain the same information.
I have about 7k lines to go through. ONe at a time would be a major
pain in the rear.
Thanks much,
Dave
site's information and transpose that to another spreadsheet. This
information includes meta tag and html markup in one spreadsheet. The
other spreadhseet doesn't use the html and also takes what was all in
one cell and has it split in
1st spreadhseet example:
(all this is in one cell)
<meta NAME="description" CONTENT="1 Spot Adapter. Visual Sound 1 Spot
9V DC Adapter at the lowest price! X store ships all over the US
including ohio, pennsylvania, illinois, new, york, jersey, california,
florida, texas and more. Trust x store for the lowest prices, largest
selection and best service."> <meta NAME="keywords" CONTENT="1, Spot,
Adapter, one, Visual, Sound, 9V, DC, Adapter, lowest, prices, on,
line, store, ohio, pennsylvania, illinois, new, york, jersey,
california, florida, texas, on-line, discount, retail, best, for,
and"> <META name="RATING" content="General"> <META name="ROBOTS"
content="index,follow"><META NAME="REVISIT-AFTER" CONTENT="2 weeks">
Needs to go a new spreadsheet
one cell is for meta description, one for keywords with NO HTML markup
and no rating, revist etc. info
So the question is how do I pull out the meta description with no html
markup and transport that to one cell, delete the rest of html markup
and also pull out the keywords info to another cell? I think the
trickist part is that each description and keyword will not start with
nor contain the same information.
I have about 7k lines to go through. ONe at a time would be a major
pain in the rear.
Thanks much,
Dave