Advertisement

05.14.2008 at 06:31AM PDT, ID: 23401303
[x]
Attachment Details

XML To Pipe Delimited .txt File

Asked by r270ba in Extensible Markup Language (XML), Microsoft Visual C#.Net, Extensible Stylesheet Language Transformation (XSLT)

Tags: ,

I need to take the information below and convert it to a pipe delimited .txt file.  I also need to appeand some static headers to the some static text to the .txt file as well (I guess you might would call it header information.  So I will post the XML file in this post and then post what the results of the .txt file should look like in the second post.

I also want to make sure that whatever method I use will be easy for an "end user" to parse the XML file into the .txt pipe delimited file.Start Free Trial
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
<?xml version="1.0" encoding="UTF-8" ?> 
- <form1>
- <!-- 
******************************************************************************
 
If you filled in a form:
 
    This file contains data that was entered into a form.
    It is not the form itself.
 
******************************************************************************
 
If you receive this data file:
 
    Please follow the directions below to process this data file using
    Adobe Acrobat Professional 7
 
**To view the completed form:
    1) Save this data file to your computer.
    2) Open a blank copy of the original PDF form that the form filler
       completed in order to generate this data file.
    3) In Acrobat, choose Advanced > Forms > Import Data to Current Form
       and browse for this data file.
    4) You will see the form with the data in it.
    5) To save a copy of the form with the data in it, choose File > Save As
       and save the file.
 
**To create a spreadsheet from one or more form data files you have received:
    1) Save the data files to a place on your computer, giving each file a
       unique name and making sure not to delete the '.xml' file extension.
    2) In Acrobat, choose File > Form Data > Create Spreadsheet from Data Files.
    3) Click the 'Add Files' button to chose the data files.
    4) After the data files are added, click the 'Create Spreadsheet' button
       to create a Spreadsheet that contains data from selected data files.
 
******************************************************************************
 
  --> 
  <Customer>test customer</Customer> 
  <City>city</City> 
  <State>SC</State> 
  <ProblemDescription>problem with the body</ProblemDescription> 
  <Manufacturer>Jacobsen</Manufacturer> 
  <UnitSerial>abc</UnitSerial> 
  <HourMeter>252</HourMeter> 
  <EngModel /> 
  <EngSerial>xyz</EngSerial> 
  <FailureDate>2008-05-06</FailureDate> 
  <RepairDate>2008-05-14</RepairDate> 
  <Allowances>Travel</Allowances> 
  <PrimaryPartFailed>039569</PrimaryPartFailed> 
  <FailureCode>Body</FailureCode> 
  <JobCode>bc-0267-1</JobCode> 
  <LaborHrAllowed>1</LaborHrAllowed> 
  <WorkPerformed>fixed the body</WorkPerformed> 
  <CaseNumber>1234</CaseNumber> 
  <Model>LF-3400</Model> 
  <CuttingSerial>1234</CuttingSerial> 
  <LaborMinAllowed>30</LaborMinAllowed> 
  <RoutineMntPerformedBy>Customer</RoutineMntPerformedBy> 
  <LaborHrActual>2</LaborHrActual> 
  <LaborMinActual>45</LaborMinActual> 
  <WorkPeformedBy>joe smith</WorkPeformedBy> 
  <PartQty1>1.00000000</PartQty1> 
  <PartNum1>929389</PartNum1> 
  <PartDesc1>part 1 description</PartDesc1> 
  <PartQty2>3.00000000</PartQty2> 
  <PartNum2>883020</PartNum2> 
  <PartDesc2>part 2 description</PartDesc2> 
  <PartQty3 /> 
  <PartNum3 /> 
  <PartDesc3 /> 
  <PartQty4 /> 
  <PartNum4 /> 
  <PartDesc4 /> 
  <PartQty5 /> 
  <PartNum5 /> 
  <PartDesc5 /> 
  <PartQty6 /> 
  <PartNum6 /> 
  <PartDesc6 /> 
  <PartQty7 /> 
  <PartNum7 /> 
  <PartDesc7 /> 
  <PartQty8 /> 
  <PartNum8 /> 
  <PartDesc8 /> 
  <MiscQty1>3.00000000</MiscQty1> 
  <MiscDesc1>quarts of oil</MiscDesc1> 
  <MiscCost1>15.00</MiscCost1> 
  <MiscQty2 /> 
  <MiscDesc2 /> 
  <MiscCost2 /> 
  <MiscQty3 /> 
  <MiscDesc3 /> 
  <MiscCost3 /> 
  <MiscQty4 /> 
  <MiscDesc4 /> 
  <MiscCost4 /> 
  <MiscQty5 /> 
  <MiscDesc5 /> 
  <MiscCost5 /> 
  <MiscQty6 /> 
  <MiscDesc6 /> 
  <MiscCost6 /> 
  </form1>
[+][-]05.14.2008 at 06:35AM PDT, ID: 21563967

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.14.2008 at 06:35AM PDT, ID: 21563978

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 06:27AM PDT, ID: 21573336

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 08:18AM PDT, ID: 21574595

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 09:23AM PDT, ID: 21575368

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.15.2008 at 09:23AM PDT, ID: 21575379

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 09:34AM PDT, ID: 21575522

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 10:01AM PDT, ID: 21575810

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 10:04AM PDT, ID: 21575845

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 10:06AM PDT, ID: 21575875

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 10:07AM PDT, ID: 21575893

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 11:48AM PDT, ID: 21576843

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 09:14AM PDT, ID: 21584069

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 12:20PM PDT, ID: 21585618

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 12:32PM PDT, ID: 21585722

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.17.2008 at 05:33AM PDT, ID: 21588990

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.17.2008 at 05:37AM PDT, ID: 21589030

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Extensible Markup Language (XML), Microsoft Visual C#.Net, Extensible Stylesheet Language Transformation (XSLT)
Tags: XML, XML
Sign Up Now!
Solution Provided By: r270ba
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.17.2008 at 05:54AM PDT, ID: 21589148

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.17.2008 at 05:56AM PDT, ID: 21589157

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 05:57AM PDT, ID: 21592531

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 05:23AM PDT, ID: 21597084

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 03:31PM PDT, ID: 21602166

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 04:08PM PDT, ID: 21602348

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 04:33PM PDT, ID: 21602429

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 03:44AM PDT, ID: 21604835

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.21.2008 at 04:28AM PDT, ID: 21613809

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628