Question: I have a problem about my program. The guild of programming is -- The file ITEMS.DAT is a fixed field length text file with the

I have a problem about my program. The guild of programming is

--

The file ITEMS.DAT is a fixed field length text file with the following format: Columns Description 1- 8 Part Number 6 Color code imbedded in part number 9-26 Item description 27-34 Price in format 9999.99 36-45 Available Date in format 12/31/2016

46 end of line marker Color codes are 1=Red, 2=Blue, 3=White, 4=Black

You will need to convert the color code into a color name for the XML file. The CUSTOMER.pip file is a pipe delimited text file containing lastname|firstname|partnumber|TransactionDate the TransactionDate is in the form MM/DD/YYYY, for example 10/21/2016 Read data from ITEMS.DAT and CUSTOMER.pip to create a file named Transactions.XML with the structures detailed below. Sample input files should produce the XML output below. Your program should react to any input files and produce an XML file appropriate to the input data. Note that leading or trailing spaces on the extracted input data are acceptable at this point in the course. ITEMS.DAT PC12K2RTUsed Car 02350.00m412/31/2016 CUSTOMER.pip Bright|Rich|PC12K2RT|10/21/2011 Your program must generate the following Transactions.XML file. Bright Rich 10/21/2016 PC12K2RT Blue Used Car 2350.00 Read only a single data record from each input file to produce a XML file containing a single transaction data record.

---

I am not sure about what I use code. Could someone make a program and explain it?

Thank you

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!