Any idea how to parse an xml log?

  • Hi,

    I have a field which contains XML data information and I need to parse the information.

    Any idea how/what should I do?

    Thx.

    PS: I tried to provide an example however every time I put bracket signs always disappears

  • You might be able to read it into a string and and pass it to the XML Notepad listed in the link below.

    I currently save the strings into a file then use XML notepad to open the files.

    David

    http://msdn.microsoft.com/en-us/library/aa905339.aspx

  • Thx for the suggestion. Finally I used OPENXML function very easy and give the result as expected.

    However definitely I will take a look at your idea which might be useful in the future.

    Have a nice day! 😎

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply