weeding out info from cells

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
 
P

Pecoflyer

iamdave;221094 said:
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

I'm guessing this is a one-time job, otherwise you might run it whil
recording a macro.
The easiest way is probably using Data - Text to columns - use "<" ( n
quotes) as a delimiter
This will allow you to extract the different meta strings
The strings you do not need can be easily erased with
Ctrl+H
Look for ...
Replace with
As I don't know exactly what you need, I hope this puts you on track
:

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
I

iamdave

iamdave;221094 Wrote:









I'm guessing this is a one-time job, otherwise you might run it while
recording a macro.
The easiest way is probably using Data - Text to columns - use "<" ( no
quotes) as a delimiter
This will allow you to extract the different meta strings
The strings you do not need can be easily erased with
Ctrl+H
Look for ...
Replace with
As I don't know exactly what you need, I hope this puts you on track.
:)

--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)*& allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster

Hmm, maybe the macro thing is the ticket. I was hoping some kind of
replace thing also. Yes, it's a one time thing but on 7,000 rows.
ugh...

Sure appreciate the input and any other thoughts.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top