« Previous Next »

Thread: get the filename/path from query

Last post 09-07-2007 4:57 AM by Kaine. 2 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (3 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 03-02-2007, 2:31 AM

    get the filename/path from query

    Reply Contact

    Hello
    I have 1500 xml files I have to search trough to find some interesting values.

    What I also would like to find is the filename of each occuranse.
    There should only be on in each file if it exists at all in the file.

    This is my query right now:
    select datum, medlemsnr, fakturanr, artikelnr, artikelnamn, artikelgrupp,Levererat
    from C:\temp\Inforportal_elonstat\xml\*.xml
    where artikelnr='101132'

    I would like to add the filename or path  like this:
    select filename,datum, medlemsnr, fakturanr, artikelnr, artikelnamn, artikelgrupp,Levererat
    from C:\temp\Inforportal_elonstat\xml\*.xml
    where artikelnr='101132'

    the filename is not in the xml-file itself.

    Is this possible?

    /Anders
    Tags:

  • 03-02-2007, 12:06 PM In reply to

    RE: get the filename/path from query

    Mark as Answer
    Reply Contact
    Yes. look at the documentation for the XML Input Format.
    By default, installed to C:\Program Files\Log Parser 2.2\LogParser.chm
    Tags:

  • 09-07-2007, 4:57 AM In reply to

    • Kaine
    • Not Ranked
    • Joined on 09-07-2007, 4:50 AM
    • Posts 1

    Re: RE: get the filename/path from query

    Mark as Answer
    Reply Contact

    I seem to be missing something here...

    I've been going through the help file looking for a way to do this too but i have been unable to find it...

    I can find the filename in the TEXTLINE input format fields list - but there doesn't seem to be one in the XML input

    Any clues?

    Cheers,

    -K-
Page 1 of 1 (3 items)
Microsoft Communities