VB2005 Express XML style files
Posted on 2006-03-29
Hello All (I am a real beginner with this so please bear with me)
I am hoping to use VB2005 Express to make alterations to the text files produced by our document management system. I have had a look at some of the tools in VB to deal with XML but need some direction - I currently have 1/2 a million of these files to modify :(
The main problem is the text files I am dealing with are not 100% XML, the header structure is:
<FILE_NAME>This is the file name</FILE_NAME>
<BOX_NUMBER>This is the box nuber</BOX_NUMBER>
<Job_Number>This is a job number</Job_Number>
<Job_Name>This is the job name</Job_Name>
<Client_Name>This is the client name</Client_Name>
<Section>This is the section name</Section>
<Sub_Contractors>This is the Sub Contractos name</Sub_Contractors>
<Supply_Only_Orders>This is the suppliers name</Supply_Only_Orders>
The text file then holds the OCD'd tet of the document plus co-ordinate data etc.
What I would like to do is read the information in from the fields above and replace information as required. I could use INSTR and MID to get the info but hope there is a cleaner way.