Find in XML and Copy

| 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 19, 2008

Re: Find in XML and Copy

Find In Context [an application] or similar might be what poster is looking

for.

Ultra Edit, NotePad++, and several other programs have a Find In Files

search tool, which may also work.

--

MEB http://peoplescounsel.orgfree.com

--

_________

"Gary S. Terhune" <none> wrote in message

news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

| In short, you want to find all the web addresses in the XML file and list

| them in something like a text file? If not that, Copy them to where? Is

this

| just a once-off job or are you planning on processing a lot of these

things?

| If the former, I should think it's pretty obvious -- use Edit>Find,

| Copy/Paste,etc. For the latter, what you request sounds like an easy job

for

| VBScript. I certainly don't know of any ready-made tool that would do the

| job.

|

| --

| Gary S. Terhune

| MS-MVP 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 19, 2008

Re: Find in XML and Copy

Thank You. It is both for now a one time job, and in the future I might need

it again. With the Edit>Find,

> Copy/Paste the problem is I have to keep on clicking next,and there are

more then 300 entries .

Sol

"Gary S. Terhune" <none> wrote in message

news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

> In short, you want to find all the web addresses in the XML file and list

> them in something like a text file? If not that, Copy them to where? Is

this

> just a once-off job or are you planning on processing a lot of these

things?

> If the former, I should think it's pretty obvious -- use Edit>Find,

> Copy/Paste,etc. For the latter, what you request sounds like an easy job

for

> VBScript. I certainly don't know of any ready-made tool that would do the

> job.

>

> --

> Gary S. Terhune

> MS-MVP 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 19, 2008

Re: Find in XML and Copy

Also I am not familiar with VBScript.

Sol

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

news:%23zHeRoduIHA.420@TK2MSFTNGP02.phx.gbl...

> Thank You. It is both for now a one time job, and in the future I might

need

> it again. With the Edit>Find,

> > Copy/Paste the problem is I have to keep on clicking next,and there are

> more then 300 entries .

> Sol

> "Gary S. Terhune" <none> wrote in message

> news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

> > In short, you want to find all the web addresses in the XML file and

list

> > them in something like a text file? If not that, Copy them to where? Is

> this

> > just a once-off job or are you planning on processing a lot of these

> things?

> > If the former, I should think it's pretty obvious -- use Edit>Find,

> > Copy/Paste,etc. For the latter, what you request sounds like an easy job

> for

> > VBScript. I certainly don't know of any ready-made tool that would do

the

> > job.

> >

> > --

> > 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 19, 2008

Re: Find in XML and Copy

Boolean searches? I dunno. Don't know enough about the language to say.

Would seem to me to be a fairly complicated search term. Locate the URL only

if directly following Str2. And then define its beginning and end. And then,

like I said, Copy to what? Do those tools you cite generate lists?

But I know even less about the OP's desired results, so there you go.

--

Gary S. Terhune

MS-MVP Shell/User

"MEB" <meb@not here@hotmail.com> wrote in message

news:eskRnYduIHA.672@TK2MSFTNGP02.phx.gbl...

> Find In Context [an application] or similar might be what poster is

> looking

> for.

>

> Ultra Edit, NotePad++, and several other programs have a Find In Files

> search tool, which may also work.

>

> --

> MEB http://peoplescounsel.orgfree.com

> --

> _________

>

> "Gary S. Terhune" <none> wrote in message

> news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

> | In short, you want to find all the web addresses in the XML file and

> list

> | them in something like a text file? If not that, Copy them to where? Is

> this

> | just a once-off job or are you planning on processing a lot of these

> things?

> | If the former, I should think it's pretty obvious -- use Edit>Find,

> | Copy/Paste,etc. For the latter, what you request sounds like an easy job

> for

> | VBScript. I certainly don't know of any ready-made tool that would do

> the

> | job.

> |

> | --

> | 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 19, 2008

Re: Find in XML and Copy

I will copy to a list or excel file.

Sol

"Gary S. Terhune" <none> wrote in message

news:eTII3uduIHA.672@TK2MSFTNGP02.phx.gbl...

> Boolean searches? I dunno. Don't know enough about the language to say.

> Would seem to me to be a fairly complicated search term. Locate the URL

only

> if directly following Str2. And then define its beginning and end. And

then,

> like I said, Copy to what? Do those tools you cite generate lists?

>

> But I know even less about the OP's desired results, so there you go.

>

> --

> Gary S. Terhune

> MS-MVP Shell/User

>

> "MEB" <meb@not here@hotmail.com> wrote in message

> news:eskRnYduIHA.672@TK2MSFTNGP02.phx.gbl...

> > Find In Context [an application] or similar might be what poster is

> > looking

> > for.

> >

> > Ultra Edit, NotePad++, and several other programs have a Find In Files

> > search tool, which may also work.

> >

> > --

> > MEB http://peoplescounsel.orgfree.com

> > --

> > _________

> >

> > "Gary S. Terhune" <none> wrote in message

> > news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

> > | In short, you want to find all the web addresses in the XML file and

> > list

> > | them in something like a text file? If not that, Copy them to where?

Is

> > this

> > | just a once-off job or are you planning on processing a lot of these

> > things?

> > | If the former, I should think it's pretty obvious -- use Edit>Find,

> > | Copy/Paste,etc. For the latter, what you request sounds like an easy

job

> > for

> > | VBScript. I certainly don't know of any ready-made tool that would do

> > the

> > | job.

> > |

> > | --

> > | 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 19, 2008

Re: Find in XML and Copy

You still haven't answered the main question: Copy to where? A simple text

list? Something more complicated?

From what you say, you need a program or script, or other tool. Much too

tedious by hand. I don't think what MEB suggests is what you're looking for,

but you should at least check them out.

--

Gary S. Terhune

MS-MVP Shell/User

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

news:%23zHeRoduIHA.420@TK2MSFTNGP02.phx.gbl...

> Thank You. It is both for now a one time job, and in the future I might

> need

> it again. With the Edit>Find,

>> Copy/Paste the problem is I have to keep on clicking next,and there are

> more then 300 entries .

> Sol

> "Gary S. Terhune" <none> wrote in message

> news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

>> In short, you want to find all the web addresses in the XML file and list

>> them in something like a text file? If not that, Copy them to where? Is

> this

>> just a once-off job or are you planning on processing a lot of these

> things?

>> If the former, I should think it's pretty obvious -- use Edit>Find,

>> Copy/Paste,etc. For the latter, what you request sounds like an easy job

> for

>> VBScript. I certainly don't know of any ready-made tool that would do the

>> job.

>>

>> --

>> Gary S. Terhune

>> MS-MVP Shell/User

http://www.google.com/search?hl=en&q=vbscript

>>

>> "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 19, 2008

Re: Find in XML and Copy

Maybe you'd like to learn? It's quick (and dirty) compared to most

programming languages.

--

Gary S. Terhune

MS-MVP Shell/User

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

news:ez2tjrduIHA.552@TK2MSFTNGP06.phx.gbl...

> Also I am not familiar with VBScript.

> Sol

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

> news:%23zHeRoduIHA.420@TK2MSFTNGP02.phx.gbl...

>> Thank You. It is both for now a one time job, and in the future I might

> need

>> it again. With the Edit>Find,

>> > Copy/Paste the problem is I have to keep on clicking next,and there

>> > are

>> more then 300 entries .

>> Sol

>> "Gary S. Terhune" <none> wrote in message

>> news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

>> > In short, you want to find all the web addresses in the XML file and

> list

>> > them in something like a text file? If not that, Copy them to where? Is

>> this

>> > just a once-off job or are you planning on processing a lot of these

>> things?

>> > If the former, I should think it's pretty obvious -- use Edit>Find,

>> > Copy/Paste,etc. For the latter, what you request sounds like an easy

>> > job

>> for

>> > VBScript. I certainly don't know of any ready-made tool that would do

> the

>> > job.

>> >

>> > --

>> > 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 19, 2008

Re: Find in XML and Copy

First is a snap, and one or more of those programs MEB suggested might

actually do such a thing, though I still think they'd have a hard time

actually, properly, locating the strings you want to copy out. No problem

with VBScript. Might take me a couple of hours, but I don't practice much.

For an Excel file, you'd just make the extension CSV instead of TXT.

--

Gary S. Terhune

MS-MVP Shell/User

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

news:eNptA1duIHA.420@TK2MSFTNGP02.phx.gbl...

>I will copy to a list or excel file.

> Sol

> "Gary S. Terhune" <none> wrote in message

> news:eTII3uduIHA.672@TK2MSFTNGP02.phx.gbl...

>> Boolean searches? I dunno. Don't know enough about the language to say.

>> Would seem to me to be a fairly complicated search term. Locate the URL

> only

>> if directly following Str2. And then define its beginning and end. And

> then,

>> like I said, Copy to what? Do those tools you cite generate lists?

>>

>> But I know even less about the OP's desired results, so there you go.

>>

>> --

>> Gary S. Terhune

>> MS-MVP Shell/User

>>

>> "MEB" <meb@not here@hotmail.com> wrote in message

>> news:eskRnYduIHA.672@TK2MSFTNGP02.phx.gbl...

>> > Find In Context [an application] or similar might be what poster is

>> > looking

>> > for.

>> >

>> > Ultra Edit, NotePad++, and several other programs have a Find In Files

>> > search tool, which may also work.

>> >

>> > --

>> > MEB http://peoplescounsel.orgfree.com

>> > --

>> > _________

>> >

>> > "Gary S. Terhune" <none> wrote in message

>> > news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

>> > | In short, you want to find all the web addresses in the XML file and

>> > list

>> > | them in something like a text file? If not that, Copy them to where?

> Is

>> > this

>> > | just a once-off job or are you planning on processing a lot of these

>> > things?

>> > | If the former, I should think it's pretty obvious -- use Edit>Find,

>> > | Copy/Paste,etc. For the latter, what you request sounds like an easy

> job

>> > for

>> > | VBScript. I certainly don't know of any ready-made tool that would do

>> > the

>> > | job.

>> > |

>> > | --

>> > | 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 19, 2008

Re: Find in XML and Copy

Right a simple list.

Sol

"Gary S. Terhune" <none> wrote in message

news:uaE2o8duIHA.4952@TK2MSFTNGP05.phx.gbl...

> You still haven't answered the main question: Copy to where? A simple text

> list? Something more complicated?

>

> From what you say, you need a program or script, or other tool. Much too

> tedious by hand. I don't think what MEB suggests is what you're looking

for,

> but you should at least check them out.

>

> --

> Gary S. Terhune

> MS-MVP Shell/User

>

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

> news:%23zHeRoduIHA.420@TK2MSFTNGP02.phx.gbl...

> > Thank You. It is both for now a one time job, and in the future I might

> > need

> > it again. With the Edit>Find,

> >> Copy/Paste the problem is I have to keep on clicking next,and there

are

> > more then 300 entries .

> > Sol

> > "Gary S. Terhune" <none> wrote in message

> > news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

> >> In short, you want to find all the web addresses in the XML file and

list

> >> them in something like a text file? If not that, Copy them to where? Is

> > this

> >> just a once-off job or are you planning on processing a lot of these

> > things?

> >> If the former, I should think it's pretty obvious -- use Edit>Find,

> >> Copy/Paste,etc. For the latter, what you request sounds like an easy

job

> > for

> >> VBScript. I certainly don't know of any ready-made tool that would do

the

> >> job.

> >>

> >> --

> >> 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 19, 2008

Re: Find in XML and Copy

Well, then, you have my answer, and those of MEB.

--

Gary S. Terhune

MS-MVP Shell/User

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

news:%23yvdzbeuIHA.4952@TK2MSFTNGP05.phx.gbl...

> Right a simple list.

> Sol

> "Gary S. Terhune" <none> wrote in message

> news:uaE2o8duIHA.4952@TK2MSFTNGP05.phx.gbl...

>> You still haven't answered the main question: Copy to where? A simple

>> text

>> list? Something more complicated?

>>

>> From what you say, you need a program or script, or other tool. Much too

>> tedious by hand. I don't think what MEB suggests is what you're looking

> for,

>> but you should at least check them out.

>>

>> --

>> Gary S. Terhune

>> MS-MVP Shell/User

>>

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

>> news:%23zHeRoduIHA.420@TK2MSFTNGP02.phx.gbl...

>> > Thank You. It is both for now a one time job, and in the future I might

>> > need

>> > it again. With the Edit>Find,

>> >> Copy/Paste the problem is I have to keep on clicking next,and there

> are

>> > more then 300 entries .

>> > Sol

>> > "Gary S. Terhune" <none> wrote in message

>> > news:utgvDOduIHA.1872@TK2MSFTNGP04.phx.gbl...

>> >> In short, you want to find all the web addresses in the XML file and

> list

>> >> them in something like a text file? If not that, Copy them to where?

>> >> Is

>> > this

>> >> just a once-off job or are you planning on processing a lot of these

>> > things?

>> >> If the former, I should think it's pretty obvious -- use Edit>Find,

>> >> Copy/Paste,etc. For the latter, what you request sounds like an easy

> job

>> > for

>> >> VBScript. I certainly don't know of any ready-made tool that would do

> the

>> >> job.

>> >>

>> >> --

>> >> 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 19, 2008

Re: Find in XML and Copy

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 19, 2008

Re: Find in XML and Copy

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 20, 2008

Re: Find in XML and Copy

Using Excel Find, you found all the URLs and they were automatically all

highlighted, all at once?

--

Gary S. Terhune

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

>> >

>>

>

May 20, 2008

Re: Find in XML and Copy

Something wrong with your clock, Franc.

--

Gary S. Terhune

MS-MVP Shell/User

"Franc Zabkar" <fzabkar@iinternode.on.net> wrote in message

news:qsd2349m5uqvokrnp4iafq9lkbqf9jmd89@4ax.com...

> On Mon, 19 May 2008 12:50:55 -0400, "S1L1Y1" <s1l1y1@yahoo.com> put

> finger to keyboard and composed:

>

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

>

> Can you give us a link to a complete .xml file as an example?

>

> - Franc Zabkar

> --

> Please remove one 'i' from my address when replying by email.

May 20, 2008

Re: Find in XML and Copy

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

"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 20, 2008

Re: Find in XML and Copy

On Mon, 19 May 2008 17:31:18 -0700, "Gary S. Terhune" <none> put

finger to keyboard and composed:

>Something wrong with your clock, Franc.

Thanks.

Note to self: change motherboard battery

- Franc Zabkar

--

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

May 20, 2008

Re: Find in XML and Copy

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

>> >

>>

>

May 20, 2008

Re: Find in XML and Copy

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

>

> "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 20, 2008

Re: Find in XML and Copy

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

="http://www.abc.com/catalog/b3_1_424_1.JPG" .

>

> "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 20, 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;

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

> >> >

> >>

> >

>

May 21, 2008

Re: Find in XML and Copy

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

"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

>>

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

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

"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