Jump to content
sktrinh12

Decode an xml node's content

Recommended Posts

Hi, I exported a very large xml file from a chromatography software. I want to extract the UV absorbance data (Abs vs. time). I found this node:

<GilsonDADAspenSpectralData><Result><SpectralDataXML><GilsonSpectralData><SpectralData>

Also:

<DataInfo><DataType>Absorbance</DataType><UserUnitsYAxis>1</UserUnitsYAxis><UserUnitsYAxisLabel>Absorbance</UserUnitsYAxisLabel><CompressedData Type="Simple" FirstValue="0" SecondValue="0" Size="Small" UnCompressedByteSize="81920" CompressedByteSize="19166" PercentReduction="76.60400390625" AsciiPercentReduction="90.6416015625" >

This is followed by some strange jargon (not in its entirety): 

Quote

<![CDATA[osUAAJwOAACp0qTFAAAEAAAAkc08Qy81REFUMYQOAACxlwABjQAAYB+/AgIC...

Is this some type of encoded data? The node mentions it is compressed data which led me to believe I need to decode or decompress the data to obtain what I need. I attached a txt file that contains snippets of the data. I am seeking x and y values to re-plot a graph (UV absorbance plot), so I would think this node should contain such data, but it contains some strange characters. I am not knowledgeable in xml or programming in general. Please share your expertise. Thanks.

 

*The full xml file can be downloaded here: https://drive.google.com/open?id=0B6PdLXCwSg3BbTRnamRRbDYySFk

snippet.txt

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...