Find in XML and Copy

[S1L1Y1]

That is the problem it seems to me that you can not highlight them all
because I tried to click shift and move down but not happened only the next
one got highlighted, or maybe I don't know how to do it here.
Sol
"Gary S. Terhune" <none> wrote in message
news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
> Using Excel Find, you found all the URLs and they were automatically all
> highlighted, all at once?
>
> --
> Gary S. Terhune
> MS-MVP Shell/User
> www.grystmill.com
>
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
> >I will have to go one by one and will never finish. I tried I opened
Excel
> > and then imported the data from the xml file and then went to find all
and
> > it found all the entries but you can not copy and paste from there you
> > would
> > still have to copy each one separate. There must be an easier way.
> > Solomon
> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> XML files are plain text. Use facilities for searching and copying etc
> > that
> >> you would use for a text file.
> >> --
> >> Jeff Richards
> >> MS MVP (Windows - Shell/User)
> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
> >> > This question must probably does not belong here but I tried
different
> >> > groups but got no answer.
> >> > I would very much appreciate if some body can help I have an XML file
> > that
> >> > opens with internet explorer. Now I am trying to find for example all
> >> > of
> >> > the
> >> > following: ItemField Name="image-url. Then copy all the value for
> > example
> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the web
> >> > addresses
> >> > found.
> >> > Sol
> >> >
> >> >
> >>
> >>
> >
> >
>

 

[S1L1Y1]

How do I write a macro and what does it do?
Sol
"Gary S. Terhune" <none> wrote in message
news:eUeXIYhuIHA.1328@TK2MSFTNGP03.phx.gbl...
> In case you can't see Franc's post, he suggests you put a copy online (not
> posted here to the NG, put it on a private website.) Put a link here. Then
> we can see just what you're talking about and play with the file
ourselves.
>
> If you want the result to be an Excel file, that suggests that it would be
> simplest to write a macro, if a macro can do the job.
>
> --
> Gary S. Terhune
> MS-MVP Shell/User
> www.grystmill.com
>
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
> >I will have to go one by one and will never finish. I tried I opened
Excel
> > and then imported the data from the xml file and then went to find all
and
> > it found all the entries but you can not copy and paste from there you
> > would
> > still have to copy each one separate. There must be an easier way.
> > Solomon
> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> XML files are plain text. Use facilities for searching and copying etc
> > that
> >> you would use for a text file.
> >> --
> >> Jeff Richards
> >> MS MVP (Windows - Shell/User)
> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
> >> > This question must probably does not belong here but I tried
different
> >> > groups but got no answer.
> >> > I would very much appreciate if some body can help I have an XML file
> > that
> >> > opens with internet explorer. Now I am trying to find for example all
> >> > of
> >> > the
> >> > following: ItemField Name="image-url. Then copy all the value for
> > example
> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the web
> >> > addresses
> >> > found.
> >> > Sol
> >> >
> >> >
> >>
> >>
> >
> >
>

 

[S1L1Y1]

I was able to open it with word. Now I am trying to find all that start with
www.adc.com/, but the end is not the same. I am sending a sample
="http://www.abc.com/catalog/b3_1_424_1.JPG" .
What do I enter in the find box?
Sol
"Jeff Richards" <JRichards@msn.com.au> wrote in message
news:ORMMAtluIHA.5580@TK2MSFTNGP04.phx.gbl...
> I'm surprised that you are using EXCEL as your text editor.
>
> using WORD is much easier (although there are specialised text editors
that
> would make it a snap). Use Find and Replace (with judicious use of the
> special characters, such as paragraph mark or 'any letter' etc) to make
the
> text you require significant - eg bounded by tilde (~) or some other
> character that doesn't otherwise appear. Get this text onto a line by
> itself, probably by using replace to insert a paragraph mark at the
> appropriate point. Then sort. Then delete everything you don't want (it
> will be in contiguous lines). Then remove any characters you added.
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
> >I will have to go one by one and will never finish. I tried I opened
Excel
> > and then imported the data from the xml file and then went to find all
and
> > it found all the entries but you can not copy and paste from there you
> > would
> > still have to copy each one separate. There must be an easier way.
> > Solomon
> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> XML files are plain text. Use facilities for searching and copying etc
> > that
> >> you would use for a text file.
> >> --
> >> Jeff Richards
> >> MS MVP (Windows - Shell/User)
> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
> >> > This question must probably does not belong here but I tried
different
> >> > groups but got no answer.
> >> > I would very much appreciate if some body can help I have an XML file
> > that
> >> > opens with internet explorer. Now I am trying to find for example all
> >> > of
> >> > the
> >> > following: ItemField Name="image-url. Then copy all the value for
> > example
> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the web
> >> > addresses
> >> > found.
> >> > Sol
> >> >
> >> >
> >>
> >>
> >
> >
>
>

 

[Gary S. Terhune]

I did some experimenting of my own and saw what happens. For some reason
when you Find All, it turns into a multiple selection that can't be copied,
unlike when you select several separate cells manually, where copying is for
some reason OK. Go figure.

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com

"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
> That is the problem it seems to me that you can not highlight them all
> because I tried to click shift and move down but not happened only the
> next
> one got highlighted, or maybe I don't know how to do it here.
> Sol
> "Gary S. Terhune" <none> wrote in message
> news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
>> Using Excel Find, you found all the URLs and they were automatically all
>> highlighted, all at once?
>>
>> --
>> Gary S. Terhune
>> MS-MVP Shell/User
>> www.grystmill.com
>>
>> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
>> >I will have to go one by one and will never finish. I tried I opened
> Excel
>> > and then imported the data from the xml file and then went to find all
> and
>> > it found all the entries but you can not copy and paste from there you
>> > would
>> > still have to copy each one separate. There must be an easier way.
>> > Solomon
>> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
>> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
>> >> XML files are plain text. Use facilities for searching and copying
>> >> etc
>> > that
>> >> you would use for a text file.
>> >> --
>> >> Jeff Richards
>> >> MS MVP (Windows - Shell/User)
>> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
>> >> > This question must probably does not belong here but I tried
> different
>> >> > groups but got no answer.
>> >> > I would very much appreciate if some body can help I have an XML
>> >> > file
>> > that
>> >> > opens with internet explorer. Now I am trying to find for example
>> >> > all
>> >> > of
>> >> > the
>> >> > following: ItemField Name="image-url. Then copy all the value for
>> > example
>> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the web
>> >> > addresses
>> >> > found.
>> >> > Sol
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>
>

 

[Gary S. Terhune]

A macro is program, so you have to learn to write in that program's
language, which is some form of VBA, Visual Basic for Applications. Like
VBScript, VBA is also fairly easy to learn. Look in your Office Help or
Google it.

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com

"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:ebU%233asuIHA.4528@TK2MSFTNGP03.phx.gbl...
> How do I write a macro and what does it do?
> Sol
> "Gary S. Terhune" <none> wrote in message
> news:eUeXIYhuIHA.1328@TK2MSFTNGP03.phx.gbl...
>> In case you can't see Franc's post, he suggests you put a copy online
>> (not
>> posted here to the NG, put it on a private website.) Put a link here.
>> Then
>> we can see just what you're talking about and play with the file
> ourselves.
>>
>> If you want the result to be an Excel file, that suggests that it would
>> be
>> simplest to write a macro, if a macro can do the job.
>>
>> --
>> Gary S. Terhune
>> MS-MVP Shell/User
>> www.grystmill.com
>>
>> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
>> >I will have to go one by one and will never finish. I tried I opened
> Excel
>> > and then imported the data from the xml file and then went to find all
> and
>> > it found all the entries but you can not copy and paste from there you
>> > would
>> > still have to copy each one separate. There must be an easier way.
>> > Solomon
>> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
>> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
>> >> XML files are plain text. Use facilities for searching and copying
>> >> etc
>> > that
>> >> you would use for a text file.
>> >> --
>> >> Jeff Richards
>> >> MS MVP (Windows - Shell/User)
>> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
>> >> > This question must probably does not belong here but I tried
> different
>> >> > groups but got no answer.
>> >> > I would very much appreciate if some body can help I have an XML
>> >> > file
>> > that
>> >> > opens with internet explorer. Now I am trying to find for example
>> >> > all
>> >> > of
>> >> > the
>> >> > following: ItemField Name="image-url. Then copy all the value for
>> > example
>> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the web
>> >> > addresses
>> >> > found.
>> >> > Sol
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>
>

 

[S1L1Y1]

I was able to open it with word. Now I am trying to find all that start with
www.adc.com/, but the end is not the same. I am sending a sample
="http://www.abc.com/catalog/b3_1_424_1.JPG" .
What do I enter in the find box?
Sol
"Gary S. Terhune" <none> wrote in message
news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
> I did some experimenting of my own and saw what happens. For some reason
> when you Find All, it turns into a multiple selection that can't be
copied,
> unlike when you select several separate cells manually, where copying is
for
> some reason OK. Go figure.
>
> --
> Gary S. Terhune
> MS-MVP Shell/User
> www.grystmill.com
>
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
> > That is the problem it seems to me that you can not highlight them all
> > because I tried to click shift and move down but not happened only the
> > next
> > one got highlighted, or maybe I don't know how to do it here.
> > Sol
> > "Gary S. Terhune" <none> wrote in message
> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
> >> Using Excel Find, you found all the URLs and they were automatically
all
> >> highlighted, all at once?
> >>
> >> --
> >> Gary S. Terhune
> >> MS-MVP Shell/User
> >> www.grystmill.com
> >>
> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
> >> >I will have to go one by one and will never finish. I tried I opened
> > Excel
> >> > and then imported the data from the xml file and then went to find
all
> > and
> >> > it found all the entries but you can not copy and paste from there
you
> >> > would
> >> > still have to copy each one separate. There must be an easier way.
> >> > Solomon
> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> >> XML files are plain text. Use facilities for searching and copying
> >> >> etc
> >> > that
> >> >> you would use for a text file.
> >> >> --
> >> >> Jeff Richards
> >> >> MS MVP (Windows - Shell/User)
> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
> >> >> > This question must probably does not belong here but I tried
> > different
> >> >> > groups but got no answer.
> >> >> > I would very much appreciate if some body can help I have an XML
> >> >> > file
> >> > that
> >> >> > opens with internet explorer. Now I am trying to find for example
> >> >> > all
> >> >> > of
> >> >> > the
> >> >> > following: ItemField Name="image-url. Then copy all the value for
> >> > example
> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the web
> >> >> > addresses
> >> >> > found.
> >> >> > Sol
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >
> >
>

 

[Jeff Richards]

Your sample is too tiny to for me be sure, but I would use something like
this:

Find Value="
Replace with ^p~

Find "
Replace with ^p

Sort

Delete all lines not starting with ~

Find ~
Replace with

(if i remember correctly that ^& is the find string).. If you post a few
lines - say 10 - then I can see if the above will work or not.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:%23DLpsS2uIHA.4736@TK2MSFTNGP04.phx.gbl...
>I was able to open it with word. Now I am trying to find all that start
>with
> www.adc.com/, but the end is not the same. I am sending a sample
> ="http://www.abc.com/catalog/b3_1_424_1.JPG" .
> What do I enter in the find box?
> Sol
> "Gary S. Terhune" <none> wrote in message
> news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
>> I did some experimenting of my own and saw what happens. For some reason
>> when you Find All, it turns into a multiple selection that can't be
> copied,
>> unlike when you select several separate cells manually, where copying is
> for
>> some reason OK. Go figure.
>>
>> --
>> Gary S. Terhune
>> MS-MVP Shell/User
>> www.grystmill.com
>>
>> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
>> > That is the problem it seems to me that you can not highlight them all
>> > because I tried to click shift and move down but not happened only the
>> > next
>> > one got highlighted, or maybe I don't know how to do it here.
>> > Sol
>> > "Gary S. Terhune" <none> wrote in message
>> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
>> >> Using Excel Find, you found all the URLs and they were automatically
> all
>> >> highlighted, all at once?
>> >>
>> >> --
>> >> Gary S. Terhune
>> >> MS-MVP Shell/User
>> >> www.grystmill.com
>> >>
>> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
>> >> >I will have to go one by one and will never finish. I tried I opened
>> > Excel
>> >> > and then imported the data from the xml file and then went to find
> all
>> > and
>> >> > it found all the entries but you can not copy and paste from there
> you
>> >> > would
>> >> > still have to copy each one separate. There must be an easier way.
>> >> > Solomon
>> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
>> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
>> >> >> XML files are plain text. Use facilities for searching and copying
>> >> >> etc
>> >> > that
>> >> >> you would use for a text file.
>> >> >> --
>> >> >> Jeff Richards
>> >> >> MS MVP (Windows - Shell/User)
>> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
>> >> >> > This question must probably does not belong here but I tried
>> > different
>> >> >> > groups but got no answer.
>> >> >> > I would very much appreciate if some body can help I have an XML
>> >> >> > file
>> >> > that
>> >> >> > opens with internet explorer. Now I am trying to find for example
>> >> >> > all
>> >> >> > of
>> >> >> > the
>> >> >> > following: ItemField Name="image-url. Then copy all the value for
>> >> > example
>> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the
>> >> >> > web
>> >> >> > addresses
>> >> >> > found.
>> >> >> > Sol
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >
>> >
>>
>
>

 

[S1L1Y1]

<ItemField Name="price" Value="13.27"/>
<ItemField Name="product-url"
Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>
<ItemField Name="merchant-site-category" Value="JEWELRY BOXES"/>
<ItemField Name="image-url"
Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>
<ItemField Name="upc" Value=""/>
<ItemField Name="isbn" Value=""/>
<ItemField Name="manufacturer" Value=""/>
<ItemField Name="manufacturer-part-no" Value=""/>
<ItemField Name="classification" Value="new"/>
<ItemField Name="in-stock" Value="Y"/>
<ItemField Name="shipping-price" Value="5.00"/>
<ItemField Name="shipping-weight" Value="1.2"/>

"Jeff Richards" <JRichards@msn.com.au> wrote in message
news:%23bwV9U4uIHA.1768@TK2MSFTNGP03.phx.gbl...
> Your sample is too tiny to for me be sure, but I would use something like
> this:
>
> Find Value="
> Replace with ^p~
>
> Find "
> Replace with ^p
>
> Sort
>
> Delete all lines not starting with ~
>
> Find ~
> Replace with
>
> (if i remember correctly that ^& is the find string).. If you post a few
> lines - say 10 - then I can see if the above will work or not.
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:%23DLpsS2uIHA.4736@TK2MSFTNGP04.phx.gbl...
> >I was able to open it with word. Now I am trying to find all that start
> >with
> > www.adc.com/, but the end is not the same. I am sending a sample
> > ="http://www.abc.com/catalog/b3_1_424_1.JPG" .
> > What do I enter in the find box?
> > Sol
> > "Gary S. Terhune" <none> wrote in message
> > news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
> >> I did some experimenting of my own and saw what happens. For some
reason
> >> when you Find All, it turns into a multiple selection that can't be
> > copied,
> >> unlike when you select several separate cells manually, where copying
is
> > for
> >> some reason OK. Go figure.
> >>
> >> --
> >> Gary S. Terhune
> >> MS-MVP Shell/User
> >> www.grystmill.com
> >>
> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
> >> > That is the problem it seems to me that you can not highlight them
all
> >> > because I tried to click shift and move down but not happened only
the
> >> > next
> >> > one got highlighted, or maybe I don't know how to do it here.
> >> > Sol
> >> > "Gary S. Terhune" <none> wrote in message
> >> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
> >> >> Using Excel Find, you found all the URLs and they were automatically
> > all
> >> >> highlighted, all at once?
> >> >>
> >> >> --
> >> >> Gary S. Terhune
> >> >> MS-MVP Shell/User
> >> >> www.grystmill.com
> >> >>
> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
> >> >> >I will have to go one by one and will never finish. I tried I
opened
> >> > Excel
> >> >> > and then imported the data from the xml file and then went to find
> > all
> >> > and
> >> >> > it found all the entries but you can not copy and paste from there
> > you
> >> >> > would
> >> >> > still have to copy each one separate. There must be an easier way.
> >> >> > Solomon
> >> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> >> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> >> >> XML files are plain text. Use facilities for searching and
copying
> >> >> >> etc
> >> >> > that
> >> >> >> you would use for a text file.
> >> >> >> --
> >> >> >> Jeff Richards
> >> >> >> MS MVP (Windows - Shell/User)
> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
> >> >> >> > This question must probably does not belong here but I tried
> >> > different
> >> >> >> > groups but got no answer.
> >> >> >> > I would very much appreciate if some body can help I have an
XML
> >> >> >> > file
> >> >> > that
> >> >> >> > opens with internet explorer. Now I am trying to find for
example
> >> >> >> > all
> >> >> >> > of
> >> >> >> > the
> >> >> >> > following: ItemField Name="image-url. Then copy all the value
for
> >> >> > example
> >> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the
> >> >> >> > web
> >> >> >> > addresses
> >> >> >> > found.
> >> >> >> > Sol
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >
> >> >
> >>
> >
> >
>
>

 

[Gary S. Terhune]

Here's a script I wrote to do the job. You're welcome to try it out. I'm
putting it on my website inside a ZIP file for easier downloading. You
should create a folder just for this script. When you want to analyze an XML
file, put it into the same folder with the script, then run the script.

I am posting the contents here for review, but it's better to download the
file. DO NOT try to copy the script from this post for use unless you know
VBS and can fix the broken lines due to wrapping. If you want to put the
results file into an Excel sheet, change the extension from TXT to CSV. Or
paste the text into Word for sorting. I did not concern myself with removing
any possible duplications or sorting. Yet.
http://grystmill.com/shared/FindURL.zip

Feedback is welcome. To a certain degree, <s>.

****************************************
Option Explicit

dim WshShell, fso, f, fl, fn, ln, s, r, q

Set fso = CreateObject("Scripting.FileSystemObject")
Set WshShell = WScript.CreateObject("WScript.Shell")
f = WshShell.CurrentDirectory

'Obtain name of file to be analyzed.
'line 10
Do Until fn <> ""
fn = InputBox("Please input the name of the file you wish to analyze.
Example: MyFirstXML.xml " & _
" Note that the file must be in the same folder as this script -- "
& f & ".")
If fn = "" Then
If MsgBox("Input is invalid. Press OK to try again, or Cancel to stop
this script from running.", _
1, "FindURL.vbs -- Error!") = 2 Then WScript.Quit
End If
If (fso.FileExists(f & "\" & fn)) <> True Then
If MsgBox("Input is invalid. Press OK to try again, or Cancel to stop
this script from running.", _
1, "FindURL.vbs -- Error!") = 2 Then WScript.Quit
'line20
End If
Loop

If (fso.FileExists(f & "\URLs_" & Left(fn, Len(fn) - 3) & "txt")) <> True
Then
Set r = fso.CreateTextFile(f & "\URLs_" & Left(fn, Len(fn) - 3) & "txt")
Else
q = MsgBox("A file named " & f & "\URLs_" & Left(fn, Len(fn) - 3) & "txt"
& _
", already exists. Press YES to overwrite the old file"
& _
", or NO to append new URLs to the existing results
file." & _
" Press Cancel to stop the analysis.", 3 + 48 + 0)
'line 30
If q = 2 Then WScript.Quit
If q = 6 Then Set r = fso.CreateTextFile(f & "\URLs_" & Left(fn,
Len(fn) - 3) & "txt", True)
If q = 7 Then Set r = fspenTextFile(f & "\URLs_" & Left(fn, Len(fn) -
3) & "txt", 8)
End If

Set fl = fspenTextFile(f & "\" & fn, 1)
Do While fl.AtEndOfStream <> True
ln = fl.ReadLine
If InStr(ln, "http://") > 0 Then
s = InStr(ln, "http://") 'line 40
ln = Right(ln, Len(ln) - s + 1)
ln = Left(ln, Len(ln) - 3)
r.WriteLine(ln)
End If
Loop

WScript.Quit

***********************************************

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com


"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
> This question must probably does not belong here but I tried different
> groups but got no answer.
> I would very much appreciate if some body can help I have an XML file that
> opens with internet explorer. Now I am trying to find for example all of
> the
> following: ItemField Name="image-url. Then copy all the value for example
> Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the web
> addresses
> found.
> Sol
>
>

 

[Jeff Richards]

This will work. Create the document as a txt file and use Open With to open
it in WORD. Use Find and Replace as indicated:

Find What: Value="http
Replace With: ^p~
Replace All

Find What: "/>
Replace With:
Replace All

Sort

Delete all lines not starting with ~

Find What: ~
Replace With: http
Replace All
--
Jeff Richards
MS MVP (Windows - Shell/User)
"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:e%23VI0G5uIHA.4848@TK2MSFTNGP05.phx.gbl...
> <ItemField Name="price" Value="13.27"/>
> <ItemField Name="product-url"
> Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>
> <ItemField Name="merchant-site-category" Value="JEWELRY BOXES"/>
> <ItemField Name="image-url"
> Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>
> <ItemField Name="upc" Value=""/>
> <ItemField Name="isbn" Value=""/>
> <ItemField Name="manufacturer" Value=""/>
> <ItemField Name="manufacturer-part-no" Value=""/>
> <ItemField Name="classification" Value="new"/>
> <ItemField Name="in-stock" Value="Y"/>
> <ItemField Name="shipping-price" Value="5.00"/>
> <ItemField Name="shipping-weight" Value="1.2"/>
>
> "Jeff Richards" <JRichards@msn.com.au> wrote in message
> news:%23bwV9U4uIHA.1768@TK2MSFTNGP03.phx.gbl...
>> Your sample is too tiny to for me be sure, but I would use something like
>> this:
>>
>> Find Value="
>> Replace with ^p~
>>
>> Find "
>> Replace with ^p
>>
>> Sort
>>
>> Delete all lines not starting with ~
>>
>> Find ~
>> Replace with
>>
>> (if i remember correctly that ^& is the find string).. If you post a
>> few
>> lines - say 10 - then I can see if the above will work or not.
>> --
>> Jeff Richards
>> MS MVP (Windows - Shell/User)
>> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> news:%23DLpsS2uIHA.4736@TK2MSFTNGP04.phx.gbl...
>> >I was able to open it with word. Now I am trying to find all that start
>> >with
>> > www.adc.com/, but the end is not the same. I am sending a sample
>> > ="http://www.abc.com/catalog/b3_1_424_1.JPG" .
>> > What do I enter in the find box?
>> > Sol
>> > "Gary S. Terhune" <none> wrote in message
>> > news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
>> >> I did some experimenting of my own and saw what happens. For some
> reason
>> >> when you Find All, it turns into a multiple selection that can't be
>> > copied,
>> >> unlike when you select several separate cells manually, where copying
> is
>> > for
>> >> some reason OK. Go figure.
>> >>
>> >> --
>> >> Gary S. Terhune
>> >> MS-MVP Shell/User
>> >> www.grystmill.com
>> >>
>> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
>> >> > That is the problem it seems to me that you can not highlight them
> all
>> >> > because I tried to click shift and move down but not happened only
> the
>> >> > next
>> >> > one got highlighted, or maybe I don't know how to do it here.
>> >> > Sol
>> >> > "Gary S. Terhune" <none> wrote in message
>> >> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
>> >> >> Using Excel Find, you found all the URLs and they were
>> >> >> automatically
>> > all
>> >> >> highlighted, all at once?
>> >> >>
>> >> >> --
>> >> >> Gary S. Terhune
>> >> >> MS-MVP Shell/User
>> >> >> www.grystmill.com
>> >> >>
>> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
>> >> >> >I will have to go one by one and will never finish. I tried I
> opened
>> >> > Excel
>> >> >> > and then imported the data from the xml file and then went to
>> >> >> > find
>> > all
>> >> > and
>> >> >> > it found all the entries but you can not copy and paste from
>> >> >> > there
>> > you
>> >> >> > would
>> >> >> > still have to copy each one separate. There must be an easier
>> >> >> > way.
>> >> >> > Solomon
>> >> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
>> >> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
>> >> >> >> XML files are plain text. Use facilities for searching and
> copying
>> >> >> >> etc
>> >> >> > that
>> >> >> >> you would use for a text file.
>> >> >> >> --
>> >> >> >> Jeff Richards
>> >> >> >> MS MVP (Windows - Shell/User)
>> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
>> >> >> >> > This question must probably does not belong here but I tried
>> >> > different
>> >> >> >> > groups but got no answer.
>> >> >> >> > I would very much appreciate if some body can help I have an
> XML
>> >> >> >> > file
>> >> >> > that
>> >> >> >> > opens with internet explorer. Now I am trying to find for
> example
>> >> >> >> > all
>> >> >> >> > of
>> >> >> >> > the
>> >> >> >> > following: ItemField Name="image-url. Then copy all the value
> for
>> >> >> > example
>> >> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all the
>> >> >> >> > web
>> >> >> >> > addresses
>> >> >> >> > found.
>> >> >> >> > Sol
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >
>> >> >
>> >>
>> >
>> >
>>
>>
>
>

 

[Gary S. Terhune]

Only problem would be if there is a ~ (tilde) in any of the URLs. Seems to
me I've seen them, but perhaps not?

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com

"Jeff Richards" <JRichards@msn.com.au> wrote in message
news:e4SreC%23uIHA.6096@TK2MSFTNGP06.phx.gbl...
> This will work. Create the document as a txt file and use Open With to
> open it in WORD. Use Find and Replace as indicated:
>
> Find What: Value="http
> Replace With: ^p~
> Replace All
>
> Find What: "/>
> Replace With:
> Replace All
>
> Sort
>
> Delete all lines not starting with ~
>
> Find What: ~
> Replace With: http
> Replace All
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:e%23VI0G5uIHA.4848@TK2MSFTNGP05.phx.gbl...
>> <ItemField Name="price" Value="13.27"/>
>> <ItemField Name="product-url"
>> Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>
>> <ItemField Name="merchant-site-category" Value="JEWELRY BOXES"/>
>> <ItemField Name="image-url"
>> Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>
>> <ItemField Name="upc" Value=""/>
>> <ItemField Name="isbn" Value=""/>
>> <ItemField Name="manufacturer" Value=""/>
>> <ItemField Name="manufacturer-part-no" Value=""/>
>> <ItemField Name="classification" Value="new"/>
>> <ItemField Name="in-stock" Value="Y"/>
>> <ItemField Name="shipping-price" Value="5.00"/>
>> <ItemField Name="shipping-weight" Value="1.2"/>
>>
>> "Jeff Richards" <JRichards@msn.com.au> wrote in message
>> news:%23bwV9U4uIHA.1768@TK2MSFTNGP03.phx.gbl...
>>> Your sample is too tiny to for me be sure, but I would use something
>>> like
>>> this:
>>>
>>> Find Value="
>>> Replace with ^p~
>>>
>>> Find "
>>> Replace with ^p
>>>
>>> Sort
>>>
>>> Delete all lines not starting with ~
>>>
>>> Find ~
>>> Replace with
>>>
>>> (if i remember correctly that ^& is the find string).. If you post a
>>> few
>>> lines - say 10 - then I can see if the above will work or not.
>>> --
>>> Jeff Richards
>>> MS MVP (Windows - Shell/User)
>>> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>>> news:%23DLpsS2uIHA.4736@TK2MSFTNGP04.phx.gbl...
>>> >I was able to open it with word. Now I am trying to find all that start
>>> >with
>>> > www.adc.com/, but the end is not the same. I am sending a sample
>>> > ="http://www.abc.com/catalog/b3_1_424_1.JPG" .
>>> > What do I enter in the find box?
>>> > Sol
>>> > "Gary S. Terhune" <none> wrote in message
>>> > news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
>>> >> I did some experimenting of my own and saw what happens. For some
>> reason
>>> >> when you Find All, it turns into a multiple selection that can't be
>>> > copied,
>>> >> unlike when you select several separate cells manually, where copying
>> is
>>> > for
>>> >> some reason OK. Go figure.
>>> >>
>>> >> --
>>> >> Gary S. Terhune
>>> >> MS-MVP Shell/User
>>> >> www.grystmill.com
>>> >>
>>> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>>> >> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
>>> >> > That is the problem it seems to me that you can not highlight them
>> all
>>> >> > because I tried to click shift and move down but not happened only
>> the
>>> >> > next
>>> >> > one got highlighted, or maybe I don't know how to do it here.
>>> >> > Sol
>>> >> > "Gary S. Terhune" <none> wrote in message
>>> >> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
>>> >> >> Using Excel Find, you found all the URLs and they were
>>> >> >> automatically
>>> > all
>>> >> >> highlighted, all at once?
>>> >> >>
>>> >> >> --
>>> >> >> Gary S. Terhune
>>> >> >> MS-MVP Shell/User
>>> >> >> www.grystmill.com
>>> >> >>
>>> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>>> >> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
>>> >> >> >I will have to go one by one and will never finish. I tried I
>> opened
>>> >> > Excel
>>> >> >> > and then imported the data from the xml file and then went to
>>> >> >> > find
>>> > all
>>> >> > and
>>> >> >> > it found all the entries but you can not copy and paste from
>>> >> >> > there
>>> > you
>>> >> >> > would
>>> >> >> > still have to copy each one separate. There must be an easier
>>> >> >> > way.
>>> >> >> > Solomon
>>> >> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
>>> >> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
>>> >> >> >> XML files are plain text. Use facilities for searching and
>> copying
>>> >> >> >> etc
>>> >> >> > that
>>> >> >> >> you would use for a text file.
>>> >> >> >> --
>>> >> >> >> Jeff Richards
>>> >> >> >> MS MVP (Windows - Shell/User)
>>> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>>> >> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
>>> >> >> >> > This question must probably does not belong here but I tried
>>> >> > different
>>> >> >> >> > groups but got no answer.
>>> >> >> >> > I would very much appreciate if some body can help I have an
>> XML
>>> >> >> >> > file
>>> >> >> > that
>>> >> >> >> > opens with internet explorer. Now I am trying to find for
>> example
>>> >> >> >> > all
>>> >> >> >> > of
>>> >> >> >> > the
>>> >> >> >> > following: ItemField Name="image-url. Then copy all the value
>> for
>>> >> >> > example
>>> >> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all
>>> >> >> >> > the
>>> >> >> >> > web
>>> >> >> >> > addresses
>>> >> >> >> > found.
>>> >> >> >> > Sol
>>> >> >> >> >
>>> >> >> >> >
>>> >> >> >>
>>> >> >> >>
>>> >> >> >
>>> >> >> >
>>> >> >>
>>> >> >
>>> >> >
>>> >>
>>> >
>>> >
>>>
>>>
>>
>>
>
>

 

[S1L1Y1]

Bravo! Bravo! Bravo! YOU ARE GREAT.
We are starting to get there. Now I have a problem that it does not sort in
the original order. When I copy and paste it to my Excel file it has to
match to the other columns.
Sol
"Jeff Richards" <JRichards@msn.com.au> wrote in message
news:e4SreC%23uIHA.6096@TK2MSFTNGP06.phx.gbl...
> This will work. Create the document as a txt file and use Open With to
open
> it in WORD. Use Find and Replace as indicated:
>
> Find What: Value="http
> Replace With: ^p~
> Replace All
>
> Find What: "/>
> Replace With:
> Replace All
>
> Sort
>
> Delete all lines not starting with ~
>
> Find What: ~
> Replace With: http
> Replace All
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:e%23VI0G5uIHA.4848@TK2MSFTNGP05.phx.gbl...
> > <ItemField Name="price" Value="13.27"/>
> > <ItemField Name="product-url"
> > Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>
> > <ItemField Name="merchant-site-category" Value="JEWELRY BOXES"/>
> > <ItemField Name="image-url"
> > Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>
> > <ItemField Name="upc" Value=""/>
> > <ItemField Name="isbn" Value=""/>
> > <ItemField Name="manufacturer" Value=""/>
> > <ItemField Name="manufacturer-part-no" Value=""/>
> > <ItemField Name="classification" Value="new"/>
> > <ItemField Name="in-stock" Value="Y"/>
> > <ItemField Name="shipping-price" Value="5.00"/>
> > <ItemField Name="shipping-weight" Value="1.2"/>
> >
> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> > news:%23bwV9U4uIHA.1768@TK2MSFTNGP03.phx.gbl...
> >> Your sample is too tiny to for me be sure, but I would use something
like
> >> this:
> >>
> >> Find Value="
> >> Replace with ^p~
> >>
> >> Find "
> >> Replace with ^p
> >>
> >> Sort
> >>
> >> Delete all lines not starting with ~
> >>
> >> Find ~
> >> Replace with
> >>
> >> (if i remember correctly that ^& is the find string).. If you post a
> >> few
> >> lines - say 10 - then I can see if the above will work or not.
> >> --
> >> Jeff Richards
> >> MS MVP (Windows - Shell/User)
> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> news:%23DLpsS2uIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> >I was able to open it with word. Now I am trying to find all that
start
> >> >with
> >> > www.adc.com/, but the end is not the same. I am sending a sample
> >> > ="http://www.abc.com/catalog/b3_1_424_1.JPG" .
> >> > What do I enter in the find box?
> >> > Sol
> >> > "Gary S. Terhune" <none> wrote in message
> >> > news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
> >> >> I did some experimenting of my own and saw what happens. For some
> > reason
> >> >> when you Find All, it turns into a multiple selection that can't be
> >> > copied,
> >> >> unlike when you select several separate cells manually, where
copying
> > is
> >> > for
> >> >> some reason OK. Go figure.
> >> >>
> >> >> --
> >> >> Gary S. Terhune
> >> >> MS-MVP Shell/User
> >> >> www.grystmill.com
> >> >>
> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
> >> >> > That is the problem it seems to me that you can not highlight them
> > all
> >> >> > because I tried to click shift and move down but not happened only
> > the
> >> >> > next
> >> >> > one got highlighted, or maybe I don't know how to do it here.
> >> >> > Sol
> >> >> > "Gary S. Terhune" <none> wrote in message
> >> >> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
> >> >> >> Using Excel Find, you found all the URLs and they were
> >> >> >> automatically
> >> > all
> >> >> >> highlighted, all at once?
> >> >> >>
> >> >> >> --
> >> >> >> Gary S. Terhune
> >> >> >> MS-MVP Shell/User
> >> >> >> www.grystmill.com
> >> >> >>
> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
> >> >> >> >I will have to go one by one and will never finish. I tried I
> > opened
> >> >> > Excel
> >> >> >> > and then imported the data from the xml file and then went to
> >> >> >> > find
> >> > all
> >> >> > and
> >> >> >> > it found all the entries but you can not copy and paste from
> >> >> >> > there
> >> > you
> >> >> >> > would
> >> >> >> > still have to copy each one separate. There must be an easier
> >> >> >> > way.
> >> >> >> > Solomon
> >> >> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> >> >> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> >> >> >> XML files are plain text. Use facilities for searching and
> > copying
> >> >> >> >> etc
> >> >> >> > that
> >> >> >> >> you would use for a text file.
> >> >> >> >> --
> >> >> >> >> Jeff Richards
> >> >> >> >> MS MVP (Windows - Shell/User)
> >> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
> >> >> >> >> > This question must probably does not belong here but I tried
> >> >> > different
> >> >> >> >> > groups but got no answer.
> >> >> >> >> > I would very much appreciate if some body can help I have an
> > XML
> >> >> >> >> > file
> >> >> >> > that
> >> >> >> >> > opens with internet explorer. Now I am trying to find for
> > example
> >> >> >> >> > all
> >> >> >> >> > of
> >> >> >> >> > the
> >> >> >> >> > following: ItemField Name="image-url. Then copy all the
value
> > for
> >> >> >> > example
> >> >> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all
the
> >> >> >> >> > web
> >> >> >> >> > addresses
> >> >> >> >> > found.
> >> >> >> >> > Sol
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>

 

[Franc Zabkar]

On Wed, 21 May 2008 18:26:09 -0400, "S1L1Y1" <s1l1y1@yahoo.com> put
finger to keyboard and composed:

><ItemField Name="price" Value="13.27"/>
><ItemField Name="product-url"
>Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>
><ItemField Name="merchant-site-category" Value="JEWELRY BOXES"/>
><ItemField Name="image-url"
>Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>
><ItemField Name="upc" Value=""/>
><ItemField Name="isbn" Value=""/>
><ItemField Name="manufacturer" Value=""/>
><ItemField Name="manufacturer-part-no" Value=""/>
><ItemField Name="classification" Value="new"/>
><ItemField Name="in-stock" Value="Y"/>
><ItemField Name="shipping-price" Value="5.00"/>
><ItemField Name="shipping-weight" Value="1.2"/>

If I understand the problem correctly, then the following one-line
command may be close to what you want:

find /i "<ItemField Name=""image-url Value=" "filename.xml" | find /i
"http://" > your_path_name\urls.txt

Execute the command in a DOS window (watch out for word wrap). The
URLs are written to a file named your_path_name\urls.txt.
"Filename.xml" is the name of your XML file. I'm assuming that
"ItemField Name" and "Value" appear on the same line. An actual
example XML file would have helped.

- Franc Zabkar
--
Please remove one 'i' from my address when replying by email.

 

[Jeff Richards]

That's why it is so important that you provide a FULL description of what
you are trying to do BEFORE we start to tackle your problem. You haven't
explained why you need to use EXCEL, which is very limited for this type of
exercise.

After the replace and just before the sort, cut and paste the whole thing
into a blank EXCEL sheet. Add a column to the right with an incrementing
number (using a formula), copy the column, and paste special as values back
to the same location as the original column. Then sort in EXCEL, delete the
rows you don't need, and re-sort by the extra column to get back to the
original order. Delete the extra column. I don't know whether you an then
finish it in EXCEL, (probably) or you need to export as text and finish in
WORD, but the process is essentially the same.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:u5U6c5DvIHA.4952@TK2MSFTNGP05.phx.gbl...
> Bravo! Bravo! Bravo! YOU ARE GREAT.
> We are starting to get there. Now I have a problem that it does not sort
> in
> the original order. When I copy and paste it to my Excel file it has to
> match to the other columns.
> Sol
> "Jeff Richards" <JRichards@msn.com.au> wrote in message
> news:e4SreC%23uIHA.6096@TK2MSFTNGP06.phx.gbl...
>> This will work. Create the document as a txt file and use Open With to
> open
>> it in WORD. Use Find and Replace as indicated:
>>
>> Find What: Value="http
>> Replace With: ^p~
>> Replace All
>>
>> Find What: "/>
>> Replace With:
>> Replace All
>>
>> Sort
>>
>> Delete all lines not starting with ~
>>
>> Find What: ~
>> Replace With: http
>> Replace All
>> --
>> Jeff Richards
>> MS MVP (Windows - Shell/User)
>> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> news:e%23VI0G5uIHA.4848@TK2MSFTNGP05.phx.gbl...
>> > <ItemField Name="price" Value="13.27"/>
>> > <ItemField Name="product-url"
>> > Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>
>> > <ItemField Name="merchant-site-category" Value="JEWELRY BOXES"/>
>> > <ItemField Name="image-url"
>> > Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>
>> > <ItemField Name="upc" Value=""/>
>> > <ItemField Name="isbn" Value=""/>
>> > <ItemField Name="manufacturer" Value=""/>
>> > <ItemField Name="manufacturer-part-no" Value=""/>
>> > <ItemField Name="classification" Value="new"/>
>> > <ItemField Name="in-stock" Value="Y"/>
>> > <ItemField Name="shipping-price" Value="5.00"/>
>> > <ItemField Name="shipping-weight" Value="1.2"/>
>> >
>> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
>> > news:%23bwV9U4uIHA.1768@TK2MSFTNGP03.phx.gbl...
>> >> Your sample is too tiny to for me be sure, but I would use something
> like
>> >> this:
>> >>
>> >> Find Value="
>> >> Replace with ^p~
>> >>
>> >> Find "
>> >> Replace with ^p
>> >>
>> >> Sort
>> >>
>> >> Delete all lines not starting with ~
>> >>
>> >> Find ~
>> >> Replace with
>> >>
>> >> (if i remember correctly that ^& is the find string).. If you post a
>> >> few
>> >> lines - say 10 - then I can see if the above will work or not.
>> >> --
>> >> Jeff Richards
>> >> MS MVP (Windows - Shell/User)
>> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> news:%23DLpsS2uIHA.4736@TK2MSFTNGP04.phx.gbl...
>> >> >I was able to open it with word. Now I am trying to find all that
> start
>> >> >with
>> >> > www.adc.com/, but the end is not the same. I am sending a sample
>> >> > ="http://www.abc.com/catalog/b3_1_424_1.JPG" .
>> >> > What do I enter in the find box?
>> >> > Sol
>> >> > "Gary S. Terhune" <none> wrote in message
>> >> > news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
>> >> >> I did some experimenting of my own and saw what happens. For some
>> > reason
>> >> >> when you Find All, it turns into a multiple selection that can't be
>> >> > copied,
>> >> >> unlike when you select several separate cells manually, where
> copying
>> > is
>> >> > for
>> >> >> some reason OK. Go figure.
>> >> >>
>> >> >> --
>> >> >> Gary S. Terhune
>> >> >> MS-MVP Shell/User
>> >> >> www.grystmill.com
>> >> >>
>> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> >> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
>> >> >> > That is the problem it seems to me that you can not highlight
>> >> >> > them
>> > all
>> >> >> > because I tried to click shift and move down but not happened
>> >> >> > only
>> > the
>> >> >> > next
>> >> >> > one got highlighted, or maybe I don't know how to do it here.
>> >> >> > Sol
>> >> >> > "Gary S. Terhune" <none> wrote in message
>> >> >> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
>> >> >> >> Using Excel Find, you found all the URLs and they were
>> >> >> >> automatically
>> >> > all
>> >> >> >> highlighted, all at once?
>> >> >> >>
>> >> >> >> --
>> >> >> >> Gary S. Terhune
>> >> >> >> MS-MVP Shell/User
>> >> >> >> www.grystmill.com
>> >> >> >>
>> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> >> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
>> >> >> >> >I will have to go one by one and will never finish. I tried I
>> > opened
>> >> >> > Excel
>> >> >> >> > and then imported the data from the xml file and then went to
>> >> >> >> > find
>> >> > all
>> >> >> > and
>> >> >> >> > it found all the entries but you can not copy and paste from
>> >> >> >> > there
>> >> > you
>> >> >> >> > would
>> >> >> >> > still have to copy each one separate. There must be an easier
>> >> >> >> > way.
>> >> >> >> > Solomon
>> >> >> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
>> >> >> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
>> >> >> >> >> XML files are plain text. Use facilities for searching and
>> > copying
>> >> >> >> >> etc
>> >> >> >> > that
>> >> >> >> >> you would use for a text file.
>> >> >> >> >> --
>> >> >> >> >> Jeff Richards
>> >> >> >> >> MS MVP (Windows - Shell/User)
>> >> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> >> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
>> >> >> >> >> > This question must probably does not belong here but I
>> >> >> >> >> > tried
>> >> >> > different
>> >> >> >> >> > groups but got no answer.
>> >> >> >> >> > I would very much appreciate if some body can help I have
>> >> >> >> >> > an
>> > XML
>> >> >> >> >> > file
>> >> >> >> > that
>> >> >> >> >> > opens with internet explorer. Now I am trying to find for
>> > example
>> >> >> >> >> > all
>> >> >> >> >> > of
>> >> >> >> >> > the
>> >> >> >> >> > following: ItemField Name="image-url. Then copy all the
> value
>> > for
>> >> >> >> > example
>> >> >> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all
> the
>> >> >> >> >> > web
>> >> >> >> >> > addresses
>> >> >> >> >> > found.
>> >> >> >> >> > Sol
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>

 

[Jeff Richards]

Any character that doesn't appear elsewhere in the file will work - the
vertical bar is also a good choice. If there's a difficulty, use an
unlikely combination of unusual characters instead of a single character.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"Gary S. Terhune" <none> wrote in message
news:uD3qB1BvIHA.3680@TK2MSFTNGP05.phx.gbl...
> Only problem would be if there is a ~ (tilde) in any of the URLs. Seems to
> me I've seen them, but perhaps not?

 

[Gary S. Terhune]

You are close to the most frustrating person to land in this NG in a long
time!

WHAT DO YOU WANT TO DO? Not the intermediate steps you keep asking about,
like extracting and sorting. What is your FINAL GOAL? What does your Excel
file look like?

Here's my email address: gryst_at_grystmill.com (please tell me you know how
to make that a real email address.) Please send me as many XML files as you
have for samples, and your Excel file(s), too. Then I can put it on my
website for others to download and review, also.

If you haven't totally pissed off everyone, you may yet get an answer. A
search of Google Groups shows that you have indeed gotten LOTS of attempts
help you, in this group and in the Office.Misc group (and why not Excel?)
Oh, and now a couple of weak attempts in the Excel group where you haven't
given them any real info to work with either. (If you give me the files to
post, even the Excel guys & gals can access them.)

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com


"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:u5U6c5DvIHA.4952@TK2MSFTNGP05.phx.gbl...
> Bravo! Bravo! Bravo! YOU ARE GREAT.
> We are starting to get there. Now I have a problem that it does not sort
> in
> the original order. When I copy and paste it to my Excel file it has to
> match to the other columns.
> Sol
> "Jeff Richards" <JRichards@msn.com.au> wrote in message
> news:e4SreC%23uIHA.6096@TK2MSFTNGP06.phx.gbl...
>> This will work. Create the document as a txt file and use Open With to
> open
>> it in WORD. Use Find and Replace as indicated:
>>
>> Find What: Value="http
>> Replace With: ^p~
>> Replace All
>>
>> Find What: "/>
>> Replace With:
>> Replace All
>>
>> Sort
>>
>> Delete all lines not starting with ~
>>
>> Find What: ~
>> Replace With: http
>> Replace All
>> --
>> Jeff Richards
>> MS MVP (Windows - Shell/User)
>> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> news:e%23VI0G5uIHA.4848@TK2MSFTNGP05.phx.gbl...
>> > <ItemField Name="price" Value="13.27"/>
>> > <ItemField Name="product-url"
>> > Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>
>> > <ItemField Name="merchant-site-category" Value="JEWELRY BOXES"/>
>> > <ItemField Name="image-url"
>> > Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>
>> > <ItemField Name="upc" Value=""/>
>> > <ItemField Name="isbn" Value=""/>
>> > <ItemField Name="manufacturer" Value=""/>
>> > <ItemField Name="manufacturer-part-no" Value=""/>
>> > <ItemField Name="classification" Value="new"/>
>> > <ItemField Name="in-stock" Value="Y"/>
>> > <ItemField Name="shipping-price" Value="5.00"/>
>> > <ItemField Name="shipping-weight" Value="1.2"/>
>> >
>> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
>> > news:%23bwV9U4uIHA.1768@TK2MSFTNGP03.phx.gbl...
>> >> Your sample is too tiny to for me be sure, but I would use something
> like
>> >> this:
>> >>
>> >> Find Value="
>> >> Replace with ^p~
>> >>
>> >> Find "
>> >> Replace with ^p
>> >>
>> >> Sort
>> >>
>> >> Delete all lines not starting with ~
>> >>
>> >> Find ~
>> >> Replace with
>> >>
>> >> (if i remember correctly that ^& is the find string).. If you post a
>> >> few
>> >> lines - say 10 - then I can see if the above will work or not.
>> >> --
>> >> Jeff Richards
>> >> MS MVP (Windows - Shell/User)
>> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> news:%23DLpsS2uIHA.4736@TK2MSFTNGP04.phx.gbl...
>> >> >I was able to open it with word. Now I am trying to find all that
> start
>> >> >with
>> >> > www.adc.com/, but the end is not the same. I am sending a sample
>> >> > ="http://www.abc.com/catalog/b3_1_424_1.JPG" .
>> >> > What do I enter in the find box?
>> >> > Sol
>> >> > "Gary S. Terhune" <none> wrote in message
>> >> > news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
>> >> >> I did some experimenting of my own and saw what happens. For some
>> > reason
>> >> >> when you Find All, it turns into a multiple selection that can't be
>> >> > copied,
>> >> >> unlike when you select several separate cells manually, where
> copying
>> > is
>> >> > for
>> >> >> some reason OK. Go figure.
>> >> >>
>> >> >> --
>> >> >> Gary S. Terhune
>> >> >> MS-MVP Shell/User
>> >> >> www.grystmill.com
>> >> >>
>> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> >> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
>> >> >> > That is the problem it seems to me that you can not highlight
>> >> >> > them
>> > all
>> >> >> > because I tried to click shift and move down but not happened
>> >> >> > only
>> > the
>> >> >> > next
>> >> >> > one got highlighted, or maybe I don't know how to do it here.
>> >> >> > Sol
>> >> >> > "Gary S. Terhune" <none> wrote in message
>> >> >> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
>> >> >> >> Using Excel Find, you found all the URLs and they were
>> >> >> >> automatically
>> >> > all
>> >> >> >> highlighted, all at once?
>> >> >> >>
>> >> >> >> --
>> >> >> >> Gary S. Terhune
>> >> >> >> MS-MVP Shell/User
>> >> >> >> www.grystmill.com
>> >> >> >>
>> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> >> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
>> >> >> >> >I will have to go one by one and will never finish. I tried I
>> > opened
>> >> >> > Excel
>> >> >> >> > and then imported the data from the xml file and then went to
>> >> >> >> > find
>> >> > all
>> >> >> > and
>> >> >> >> > it found all the entries but you can not copy and paste from
>> >> >> >> > there
>> >> > you
>> >> >> >> > would
>> >> >> >> > still have to copy each one separate. There must be an easier
>> >> >> >> > way.
>> >> >> >> > Solomon
>> >> >> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
>> >> >> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
>> >> >> >> >> XML files are plain text. Use facilities for searching and
>> > copying
>> >> >> >> >> etc
>> >> >> >> > that
>> >> >> >> >> you would use for a text file.
>> >> >> >> >> --
>> >> >> >> >> Jeff Richards
>> >> >> >> >> MS MVP (Windows - Shell/User)
>> >> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> >> >> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
>> >> >> >> >> > This question must probably does not belong here but I
>> >> >> >> >> > tried
>> >> >> > different
>> >> >> >> >> > groups but got no answer.
>> >> >> >> >> > I would very much appreciate if some body can help I have
>> >> >> >> >> > an
>> > XML
>> >> >> >> >> > file
>> >> >> >> > that
>> >> >> >> >> > opens with internet explorer. Now I am trying to find for
>> > example
>> >> >> >> >> > all
>> >> >> >> >> > of
>> >> >> >> >> > the
>> >> >> >> >> > following: ItemField Name="image-url. Then copy all the
> value
>> > for
>> >> >> >> > example
>> >> >> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all
> the
>> >> >> >> >> > web
>> >> >> >> >> > addresses
>> >> >> >> >> > found.
>> >> >> >> >> > Sol
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>

 

[S1L1Y1]

Jeff,
If you can help me with one more thing I will very much appreciate I asked
already this questions and got replies but I don't understand them.
I have an Excel files with a column of only the end of the urls. I want to
add to each one the same beginning of the url, www.adc.com/. How do I do it
without having to go to each individual and paste?
Sol
"Jeff Richards" <JRichards@msn.com.au> wrote in message
news:e4SreC%23uIHA.6096@TK2MSFTNGP06.phx.gbl...
> This will work. Create the document as a txt file and use Open With to
open
> it in WORD. Use Find and Replace as indicated:
>
> Find What: Value="http
> Replace With: ^p~
> Replace All
>
> Find What: "/>
> Replace With:
> Replace All
>
> Sort
>
> Delete all lines not starting with ~
>
> Find What: ~
> Replace With: http
> Replace All
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:e%23VI0G5uIHA.4848@TK2MSFTNGP05.phx.gbl...
> > <ItemField Name="price" Value="13.27"/>
> > <ItemField Name="product-url"
> > Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>
> > <ItemField Name="merchant-site-category" Value="JEWELRY BOXES"/>
> > <ItemField Name="image-url"
> > Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>
> > <ItemField Name="upc" Value=""/>
> > <ItemField Name="isbn" Value=""/>
> > <ItemField Name="manufacturer" Value=""/>
> > <ItemField Name="manufacturer-part-no" Value=""/>
> > <ItemField Name="classification" Value="new"/>
> > <ItemField Name="in-stock" Value="Y"/>
> > <ItemField Name="shipping-price" Value="5.00"/>
> > <ItemField Name="shipping-weight" Value="1.2"/>
> >
> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> > news:%23bwV9U4uIHA.1768@TK2MSFTNGP03.phx.gbl...
> >> Your sample is too tiny to for me be sure, but I would use something
like
> >> this:
> >>
> >> Find Value="
> >> Replace with ^p~
> >>
> >> Find "
> >> Replace with ^p
> >>
> >> Sort
> >>
> >> Delete all lines not starting with ~
> >>
> >> Find ~
> >> Replace with
> >>
> >> (if i remember correctly that ^& is the find string).. If you post a
> >> few
> >> lines - say 10 - then I can see if the above will work or not.
> >> --
> >> Jeff Richards
> >> MS MVP (Windows - Shell/User)
> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> news:%23DLpsS2uIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> >I was able to open it with word. Now I am trying to find all that
start
> >> >with
> >> > www.adc.com/, but the end is not the same. I am sending a sample
> >> > ="http://www.abc.com/catalog/b3_1_424_1.JPG" .
> >> > What do I enter in the find box?
> >> > Sol
> >> > "Gary S. Terhune" <none> wrote in message
> >> > news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
> >> >> I did some experimenting of my own and saw what happens. For some
> > reason
> >> >> when you Find All, it turns into a multiple selection that can't be
> >> > copied,
> >> >> unlike when you select several separate cells manually, where
copying
> > is
> >> > for
> >> >> some reason OK. Go figure.
> >> >>
> >> >> --
> >> >> Gary S. Terhune
> >> >> MS-MVP Shell/User
> >> >> www.grystmill.com
> >> >>
> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
> >> >> > That is the problem it seems to me that you can not highlight them
> > all
> >> >> > because I tried to click shift and move down but not happened only
> > the
> >> >> > next
> >> >> > one got highlighted, or maybe I don't know how to do it here.
> >> >> > Sol
> >> >> > "Gary S. Terhune" <none> wrote in message
> >> >> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
> >> >> >> Using Excel Find, you found all the URLs and they were
> >> >> >> automatically
> >> > all
> >> >> >> highlighted, all at once?
> >> >> >>
> >> >> >> --
> >> >> >> Gary S. Terhune
> >> >> >> MS-MVP Shell/User
> >> >> >> www.grystmill.com
> >> >> >>
> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
> >> >> >> >I will have to go one by one and will never finish. I tried I
> > opened
> >> >> > Excel
> >> >> >> > and then imported the data from the xml file and then went to
> >> >> >> > find
> >> > all
> >> >> > and
> >> >> >> > it found all the entries but you can not copy and paste from
> >> >> >> > there
> >> > you
> >> >> >> > would
> >> >> >> > still have to copy each one separate. There must be an easier
> >> >> >> > way.
> >> >> >> > Solomon
> >> >> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> >> >> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> >> >> >> XML files are plain text. Use facilities for searching and
> > copying
> >> >> >> >> etc
> >> >> >> > that
> >> >> >> >> you would use for a text file.
> >> >> >> >> --
> >> >> >> >> Jeff Richards
> >> >> >> >> MS MVP (Windows - Shell/User)
> >> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
> >> >> >> >> > This question must probably does not belong here but I tried
> >> >> > different
> >> >> >> >> > groups but got no answer.
> >> >> >> >> > I would very much appreciate if some body can help I have an
> > XML
> >> >> >> >> > file
> >> >> >> > that
> >> >> >> >> > opens with internet explorer. Now I am trying to find for
> > example
> >> >> >> >> > all
> >> >> >> >> > of
> >> >> >> >> > the
> >> >> >> >> > following: ItemField Name="image-url. Then copy all the
value
> > for
> >> >> >> > example
> >> >> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> . all
the
> >> >> >> >> > web
> >> >> >> >> > addresses
> >> >> >> >> > found.
> >> >> >> >> > Sol
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>

 

[S1L1Y1]

Can I undo sort after I delete or cut /
Sol
"Jeff Richards" <JRichards@msn.com.au> wrote in message
news:%23UqMD2EvIHA.3564@TK2MSFTNGP03.phx.gbl...
> That's why it is so important that you provide a FULL description of what
> you are trying to do BEFORE we start to tackle your problem. You haven't
> explained why you need to use EXCEL, which is very limited for this type
of
> exercise.
>
> After the replace and just before the sort, cut and paste the whole thing
> into a blank EXCEL sheet. Add a column to the right with an incrementing
> number (using a formula), copy the column, and paste special as values
back
> to the same location as the original column. Then sort in EXCEL, delete
the
> rows you don't need, and re-sort by the extra column to get back to the
> original order. Delete the extra column. I don't know whether you an then
> finish it in EXCEL, (probably) or you need to export as text and finish in
> WORD, but the process is essentially the same.
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:u5U6c5DvIHA.4952@TK2MSFTNGP05.phx.gbl...
> > Bravo! Bravo! Bravo! YOU ARE GREAT.
> > We are starting to get there. Now I have a problem that it does not sort
> > in
> > the original order. When I copy and paste it to my Excel file it has to
> > match to the other columns.
> > Sol
> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> > news:e4SreC%23uIHA.6096@TK2MSFTNGP06.phx.gbl...
> >> This will work. Create the document as a txt file and use Open With to
> > open
> >> it in WORD. Use Find and Replace as indicated:
> >>
> >> Find What: Value="http
> >> Replace With: ^p~
> >> Replace All
> >>
> >> Find What: "/>
> >> Replace With:
> >> Replace All
> >>
> >> Sort
> >>
> >> Delete all lines not starting with ~
> >>
> >> Find What: ~
> >> Replace With: http
> >> Replace All
> >> --
> >> Jeff Richards
> >> MS MVP (Windows - Shell/User)
> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> news:e%23VI0G5uIHA.4848@TK2MSFTNGP05.phx.gbl...
> >> > <ItemField Name="price" Value="13.27"/>
> >> > <ItemField Name="product-url"
> >> >
Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>
> >> > <ItemField Name="merchant-site-category" Value="JEWELRY BOXES"/>
> >> > <ItemField Name="image-url"
> >> > Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>
> >> > <ItemField Name="upc" Value=""/>
> >> > <ItemField Name="isbn" Value=""/>
> >> > <ItemField Name="manufacturer" Value=""/>
> >> > <ItemField Name="manufacturer-part-no" Value=""/>
> >> > <ItemField Name="classification" Value="new"/>
> >> > <ItemField Name="in-stock" Value="Y"/>
> >> > <ItemField Name="shipping-price" Value="5.00"/>
> >> > <ItemField Name="shipping-weight" Value="1.2"/>
> >> >
> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> >> > news:%23bwV9U4uIHA.1768@TK2MSFTNGP03.phx.gbl...
> >> >> Your sample is too tiny to for me be sure, but I would use something
> > like
> >> >> this:
> >> >>
> >> >> Find Value="
> >> >> Replace with ^p~
> >> >>
> >> >> Find "
> >> >> Replace with ^p
> >> >>
> >> >> Sort
> >> >>
> >> >> Delete all lines not starting with ~
> >> >>
> >> >> Find ~
> >> >> Replace with
> >> >>
> >> >> (if i remember correctly that ^& is the find string).. If you post
a
> >> >> few
> >> >> lines - say 10 - then I can see if the above will work or not.
> >> >> --
> >> >> Jeff Richards
> >> >> MS MVP (Windows - Shell/User)
> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> news:%23DLpsS2uIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> >> >I was able to open it with word. Now I am trying to find all that
> > start
> >> >> >with
> >> >> > www.adc.com/, but the end is not the same. I am sending a sample
> >> >> > ="http://www.abc.com/catalog/b3_1_424_1.JPG" .
> >> >> > What do I enter in the find box?
> >> >> > Sol
> >> >> > "Gary S. Terhune" <none> wrote in message
> >> >> > news:OEe23gtuIHA.1772@TK2MSFTNGP03.phx.gbl...
> >> >> >> I did some experimenting of my own and saw what happens. For some
> >> > reason
> >> >> >> when you Find All, it turns into a multiple selection that can't
be
> >> >> > copied,
> >> >> >> unlike when you select several separate cells manually, where
> > copying
> >> > is
> >> >> > for
> >> >> >> some reason OK. Go figure.
> >> >> >>
> >> >> >> --
> >> >> >> Gary S. Terhune
> >> >> >> MS-MVP Shell/User
> >> >> >> www.grystmill.com
> >> >> >>
> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> >> news:OIgwyZsuIHA.1220@TK2MSFTNGP04.phx.gbl...
> >> >> >> > That is the problem it seems to me that you can not highlight
> >> >> >> > them
> >> > all
> >> >> >> > because I tried to click shift and move down but not happened
> >> >> >> > only
> >> > the
> >> >> >> > next
> >> >> >> > one got highlighted, or maybe I don't know how to do it here.
> >> >> >> > Sol
> >> >> >> > "Gary S. Terhune" <none> wrote in message
> >> >> >> > news:%23$6TR1guIHA.5580@TK2MSFTNGP04.phx.gbl...
> >> >> >> >> Using Excel Find, you found all the URLs and they were
> >> >> >> >> automatically
> >> >> > all
> >> >> >> >> highlighted, all at once?
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Gary S. Terhune
> >> >> >> >> MS-MVP Shell/User
> >> >> >> >> www.grystmill.com
> >> >> >> >>
> >> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> >> >> news:%23GmgAYfuIHA.4528@TK2MSFTNGP03.phx.gbl...
> >> >> >> >> >I will have to go one by one and will never finish. I tried I
> >> > opened
> >> >> >> > Excel
> >> >> >> >> > and then imported the data from the xml file and then went
to
> >> >> >> >> > find
> >> >> > all
> >> >> >> > and
> >> >> >> >> > it found all the entries but you can not copy and paste from
> >> >> >> >> > there
> >> >> > you
> >> >> >> >> > would
> >> >> >> >> > still have to copy each one separate. There must be an
easier
> >> >> >> >> > way.
> >> >> >> >> > Solomon
> >> >> >> >> > "Jeff Richards" <JRichards@msn.com.au> wrote in message
> >> >> >> >> > news:u$dNpMfuIHA.4736@TK2MSFTNGP04.phx.gbl...
> >> >> >> >> >> XML files are plain text. Use facilities for searching and
> >> > copying
> >> >> >> >> >> etc
> >> >> >> >> > that
> >> >> >> >> >> you would use for a text file.
> >> >> >> >> >> --
> >> >> >> >> >> Jeff Richards
> >> >> >> >> >> MS MVP (Windows - Shell/User)
> >> >> >> >> >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> >> >> >> >> >> news:%23pdmSFduIHA.748@TK2MSFTNGP05.phx.gbl...
> >> >> >> >> >> > This question must probably does not belong here but I
> >> >> >> >> >> > tried
> >> >> >> > different
> >> >> >> >> >> > groups but got no answer.
> >> >> >> >> >> > I would very much appreciate if some body can help I have
> >> >> >> >> >> > an
> >> > XML
> >> >> >> >> >> > file
> >> >> >> >> > that
> >> >> >> >> >> > opens with internet explorer. Now I am trying to find for
> >> > example
> >> >> >> >> >> > all
> >> >> >> >> >> > of
> >> >> >> >> >> > the
> >> >> >> >> >> > following: ItemField Name="image-url. Then copy all the
> > value
> >> > for
> >> >> >> >> > example
> >> >> >> >> >> > Value="http://www.abc.com/catalog/b3_1_424_1.JPG" /> .
all
> > the
> >> >> >> >> >> > web
> >> >> >> >> >> > addresses
> >> >> >> >> >> > found.
> >> >> >> >> >> > Sol
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>

 

[Jeff Richards]

Yes - if you create a column of incrementing values BEFORE doing the sort
then use that column to sort on AFTER doing the delete, like I said..
--
Jeff Richards
MS MVP (Windows - Shell/User)
"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:%23jfDti2vIHA.2064@TK2MSFTNGP05.phx.gbl...
> Can I undo sort after I delete or cut /
> Sol

 

[Jeff Richards]

You already got an answer to this one.

Create a formula in an adjacent column that uses the CONCATENATE function to
prepend a fixed text string to the beginning of the text in the first
column.

Put the formula in the first cell of the column, test it, then copy down to
automatically put it in each other cell. Copy and paste special (Values) to
turn it from a formula into a value.

These questions are best asked in an EXCEL group - they have nothing to do
with W98.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:up8tXV1vIHA.4772@TK2MSFTNGP03.phx.gbl...
> Jeff,
> If you can help me with one more thing I will very much appreciate I asked
> already this questions and got replies but I don't understand them.
> I have an Excel files with a column of only the end of the urls. I want to
> add to each one the same beginning of the url, www.adc.com/. How do I do
> it
> without having to go to each individual and paste?
> Sol