Find in XML and Copy

May 21, 2008

Re: Find in XML and Copy

I was able to open it with word. Now I am trying to find all that start with

http://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

> http://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

> >> http://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

> >> >> >

> >> >>

> >> >

> >>

> >

>

May 21, 2008

Re: Find in XML and Copy

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

> http://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

>> http://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

>> >> http://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

>> >> >> >

>> >> >>

>> >> >

>> >>

>> >

>>

>

May 21, 2008

Re: Find in XML and Copy

<ItemField Name="product-url"

Value="http://www.adc.com/servlet/the-424/JEWELRY-BOX-GIFTWARE/Detail"/>

<ItemField Name="image-url"

Value="http://www.adc.com/catalog/b3_1_424_1.JPG"/>

"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

> > http://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

> >> http://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

> >> >> http://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

> >> >> >> >

> >> >> >>

> >> >> >

> >> >>

> >> >

> >>

> >

>

May 22, 2008

Re: Find in XML and Copy

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 = fso.OpenTextFile(f & "\URLs_" & Left(fn, Len(fn) -

3) & "txt", 8)

End If

Set fl = fso.OpenTextFile(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

http://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

>

May 22, 2008

Re: Find in XML and Copy

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

>> > http://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

>> >> http://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

>> >> >> http://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

>> >> >> >> >

>> >> >> >>

>> >> >> >

>> >> >>

>> >> >

>> >>

>> >

>>

>

May 22, 2008

Re: Find in XML and Copy

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

http://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

>>> > http://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

>>> >> http://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

>>> >> >> http://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

>>> >> >> >> >

>>> >> >> >>

>>> >> >> >

>>> >> >>

>>> >> >

>>> >>

>>> >

>>>

>>

>

May 22, 2008

Re: Find in XML and Copy

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

> >> > http://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

> >> >> http://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

> >> >> >> http://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

> >> >> >> >> >

> >> >> >> >>

> >> >> >> >

> >> >> >>

> >> >> >

> >> >>

> >> >

> >>

> >

>

May 22, 2008

Re: Find in XML and Copy

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.

May 22, 2008

Re: Find in XML and Copy

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

>> >> > http://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

>> >> >> http://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

>> >> >> >> http://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

>> >> >> >> >> >

>> >> >> >> >>

>> >> >> >> >

>> >> >> >>

>> >> >> >

>> >> >>

>> >> >

>> >>

>> >

>>

>

May 22, 2008

Re: Find in XML and Copy

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?

May 22, 2008

Re: Find in XML and Copy

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

http://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

>> >> > http://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

>> >> >> http://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

>> >> >> >> http://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

>> >> >> >> >> >

>> >> >> >> >>

>> >> >> >> >

>> >> >> >>

>> >> >> >

>> >> >>

>> >> >

>> >>

>> >

>>

>

May 26, 2008

Re: Find in XML and Copy

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, http://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

> >> > http://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

> >> >> http://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

> >> >> >> http://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

> >> >> >> >> >

> >> >> >> >>

> >> >> >> >

> >> >> >>

> >> >> >

> >> >>

> >> >

> >>

> >

>

May 26, 2008

Re: Find in XML and Copy

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

> >> >> > http://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

> >> >> >> http://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

> >> >> >> >> http://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

> >> >> >> >> >> >

> >> >> >> >> >>

> >> >> >> >> >

> >> >> >> >>

> >> >> >> >

> >> >> >>

> >> >> >

> >> >>

> >> >

> >>

> >

>

May 26, 2008

Re: Find in XML and Copy

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

May 26, 2008

Re: Find in XML and Copy

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, http://www.adc.com/. How do I do

> it

> without having to go to each individual and paste?

> Sol

May 26, 2008

Re: Find in XML and Copy

I am very not knowledgeable so I would appreciate if you can explain.

Sol

"Jeff Richards" <JRichards@msn.com.au> wrote in message

news:O3EsHG3vIHA.3384@TK2MSFTNGP03.phx.gbl...

> 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

>

May 27, 2008

Re: Find in XML and Copy

Why are you using EXCEL for this job? It's not a good tool for this sort of

task, and now you say that you are not very knowledgeable about it. You

seem determined to make this job as difficult as possible.

You create a column of incrementing numbers by putting a 1 in the first cell

and then a formula in the cell below it that adds one to the value from the

cell above. Then copy down from the second cell to the bottom of the range.

You convert the column from formulas to values by copying the column then

using paste special and selecting values and pasting it back to where it

came from.

You sort by selecting the whole spreadsheet, choosing sort, and nominating

the column containing the text data.

Then delete the lines you aren't interested in - they will be in blocks

before and after the lines you need.

Sort back into the original sequence by selecting the whole sheet, selecting

sort, and nominating the column with the numbers in it.

These are elementary EXCEL questions that are best asked in an EXCEL

newsgroup.

--

Jeff Richards

MS MVP (Windows - Shell/User)

"S1L1Y1" <s1l1y1@yahoo.com> wrote in message

news:e66LI%233vIHA.4736@TK2MSFTNGP04.phx.gbl...

>I am very not knowledgeable so I would appreciate if you can explain.

> Sol

> "Jeff Richards" <JRichards@msn.com.au> wrote in message

> news:O3EsHG3vIHA.3384@TK2MSFTNGP03.phx.gbl...

>> 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

>>

>

Sign In

Find in XML and Copy

Recommended Posts

Guest S1L1Y1

Popular Days

Popular Days

Guest Jeff Richards

Guest S1L1Y1

Guest Gary S. Terhune

Guest Jeff Richards

Guest Gary S. Terhune

Guest S1L1Y1

Guest Franc Zabkar

Guest Jeff Richards

Guest Jeff Richards

Guest Gary S. Terhune

Guest S1L1Y1

Guest S1L1Y1

Guest Jeff Richards

Guest Jeff Richards

Guest S1L1Y1

Guest Jeff Richards

Similar Content

this copy of windows is not genuine buld 7601

Can't find KB5005568

How do I find out if I still have a copy of win 10 on my laptop after someone reloaded 8.1?

Large file copies SOOOO SLOWWWWW!

Couldn't find the matching SID for the account domain

Browse

Activity

Site Info