Hi all,
I have some large XML files, from 80 MB to 250 MB that I need to extract some date from. Due to the size I cannot successfully open the files to convert the data.
There are a number of nodes that are are not required for this 'current' exercise, so am thinking that a way around it is to remove these nodes.
The basic format is as follows
What I would like to do it do a search and replace and remove all of the notes node. from the <notes> to the </notes>
Any ideas?
Thanks in advance, Steve
I have some large XML files, from 80 MB to 250 MB that I need to extract some date from. Due to the size I cannot successfully open the files to convert the data.
There are a number of nodes that are are not required for this 'current' exercise, so am thinking that a way around it is to remove these nodes.
The basic format is as follows
Code: Select all
<adviser>
<clients>
<client>
<title>
<key>MR</key>
<description>Mr</description>
</title>
<firstName>Anthony</firstName>
<surname>Winkler</surname>
<preferredName>Tony</preferredName>
<dateOfBirth>1982-11-01 12:00:00.0</dateOfBirth>
<gender>M</gender>
<notes>
<note>
<id>250664</id>
<noteTopic>
<refType>
<fieldLocation>
<key>CLIENT_NOTES</key>
<description>Notes</description>
</fieldLocation>
<key>NOTE_TOPIC</key>
<description>Topic</description>
</refType>
<key>ADVICE</key>
<description>Advice</description>
<id>4417</id>
</noteTopic>
<description>Advice</description>
<creationDate>2008-04-17 12:00:00.0</creationDate>
<noteText>Advice scopes and strategies: <br />1. Income protection / Salary continuance - Income protection: ACCEPTED<br />2. Life insurance - Consolidate your Debts: ACCEPTED<br />3. TPD - Consolidate your Debts: ACCEPTED<br />4. Trauma - Consolidate your Debts: ACCEPTED<br /><br />Advice recommendations: ACCEPTED ALL RECOMMENDATIONS<br /><br />Notes:
</noteText>
<isStandard>true</isStandard>
<attachments>
<attachmentsItem>
<id>161159</id>
<attachmentType>
<key>SERVER</key>
<description>Server file system</description>
</attachmentType>
<fileName>Std-SoA-17-Dec-07_5667_27001_205336.doc</fileName>
<fileSize>190</fileSize>
<creationDate>2008-04-17 02:27:25.0</creationDate>
</attachmentsItem>
</attachments>
</note>
</notes>
<client>
<clients>
<adviser>
Code: Select all
<adviser>
<clients>
<client>
<title>
<key>MR</key>
<description>Mr</description>
</title>
<firstName>Anthony</firstName>
<surname>Winkler</surname>
<preferredName>Tony</preferredName>
<dateOfBirth>1982-11-01 12:00:00.0</dateOfBirth>
<gender>M</gender>
<client>
<clients>
<adviser>
Thanks in advance, Steve