XML to tabbed - Fury-Tech Forums

freshtokyo · #1 (**permalink**) 09-15-2004, 01:18 PM

you guys know of a way to get an xml file converted to a tabbed text file?? here's the xml code.

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE edMoses SYSTEM "WhitePaper.dtd"[
]>
<ROOT><CAR><ADDLTEXT></ADDLTEXT><BANNER></BANNER><BODYTYPE>Extended Cab Pickup Truck</BODYTYPE><COLOR>Black</COLOR><CUSTID>edmoe</CUSTID><ENGINESIZE>4.3</ENGINESIZE><ENGINETYPE>6 Cyl.</ENGINETYPE><INDUCTION>Sequential-port F.I.</INDUCTION><MAKE>Chevrolet</MAKE><MILEAGE>21867</MILEAGE><MISCOPTIONS><OPTION>Air Conditioning</OPTION><OPTION>Power Steering</OPTION><OPTION>Radial Tires</OPTION><OPTION>Gauge Cluster</OPTION><OPTION>Tachometer</OPTION><OPTION>Tilt Steering Wheel</OPTION><OPTION>Interval Wipers</OPTION><OPTION>Driver Side Air Bag</OPTION><OPTION>Dual Sport Mirrors</OPTION><OPTION>Cloth Upholstery</OPTION><OPTION>Climate Control</OPTION><OPTION>Split Front Bench Seat</OPTION><OPTION>Step Bumper</OPTION><OPTION>Cargo Lamp</OPTION><OPTION>Argent Styled Wheels</OPTION><OPTION>Bed Liner</OPTION><OPTION>Passenger Side Air Bag</OPTION><OPTION>AM/FM Stereo Radio</OPTION><OPTION>Console/Storage</OPTION><OPTION>Airbag On/Off Switch</OPTION></MISCOPTIONS><MODELFAMILY>1500</MODELFAMILY><PHOTOCOLOR>TRUE</PHOTOCOLOR><PHOTOLOCAL>FALSE</PHOTOLOCAL><PHOTONAME>image01.jpg</PHOTONAME><PRICE>18900</PRICE><STOCKNUMBER>285310</STOCKNUMBER><TRANSMISSION>Automatic</TRANSMISSION><VIN>2GCEC19X731285310</VIN><YEAR>2003</YEAR></CAR><CAR><ADDLTEXT></ADDLTEXT><BANNER></BANNER><BODYTYPE>4 Dr Sedan</BODYTYPE><COLOR>Silver</COLOR><CUSTID>edmoe</CUSTID><ENGINESIZE>2.4</ENGINESIZE><ENGINETYPE>4 Cyl. DOHC</ENGINETYPE><INDUCTION>Sequential-port F.I.</INDUCTION><MAKE>Dodge</MAKE><MILEAGE>19758</MILEAGE><MISCOPTIONS><OPTION>Air Conditioning</OPTION><OPTION>Cruise Control</OPTION><OPTION>Power Steering</OPTION><OPTION>Power Door Locks</OPTION><OPTION>Power Windows</OPTION><OPTION>Cassette Player</OPTION><OPTION>Radial Tires</OPTION><OPTION>Alloy Wheels</OPTION><OPTION>Gauge Cluster</OPTION><OPTION>Tachometer</OPTION><OPTION>Tilt Steering Wheel</OPTION><OPTION>Tinted Glass</OPTION><OPTION>Interval Wipers</OPTION><OPTION>Rear Defroster</OPTION><OPTION>Driver Side Air Bag</OPTION><OPTION>Dual Sport Mirrors</OPTION><OPTION>Front Bucket Seats</OPTION><OPTION>Reclining Seats</OPTION><OPTION>Cloth Upholstery</OPTION><OPTION>Child-proof Locks</OPTION><OPTION>CD Player</OPTION><OPTION>Passenger Side Air Bag</OPTION><OPTION>AM/FM Stereo Radio</OPTION><OPTION>Console/Storage</OPTION></MISCOPTIONS><MODELFAMILY>STRATUS</MODELFAMILY><PHOTOCOLOR>TRUE</PHOTOCOLOR><PHOTOLOCAL>FALSE</PHOTOLOCAL><PHOTONAME>image02.jpg</PHOTONAME><PRICE>13900</PRICE><STOCKNUMBER>200540</STOCKNUMBER><TRANSMISSION>Automatic</TRANSMISSION><VIN>1B3EL46X74N200540</VIN><YEAR>2004</YEAR></CAR><CAR><ADDLTEXT></ADDLTEXT><BANNER></BANNER><BODYTYPE>4 Dr Sedan</BODYTYPE><COLOR>Black</COLOR><CUSTID>edmoe</CUSTID><ENGINESIZE>2.0</ENGINESIZE><ENGINETYPE>4 Cyl.</ENGINETYPE><INDUCTION>Sequential-port F.I.</INDUCTION><MAKE>Dodge</MAKE><MILEAGE>7545</MILEAGE><MISCOPTIONS><OPTION>Air Conditioning</OPTION><OPTION>Cruise Control</OPTION><OPTION>Power Steering</OPTION><OPTION>Power Door Locks</OPTION><OPTION>Power Windows</OPTION><OPTION>Radial Tires</OPTION><OPTION>Alloy Wheels</OPTION><OPTION>Gauge Cluster</OPTION><OPTION>Tachometer</OPTION><OPTION>Tilt Steering Wheel</OPTION><OPTION>Tinted Glass</OPTION><OPTION>Interval Wipers</OPTION><OPTION>Rear Defroster</OPTION><OPTION>Driver Side Air Bag</OPTION><OPTION>Dual Sport Mirrors</OPTION><OPTION>Front Bucket Seats</OPTION><OPTION>Reclining Seats</OPTION><OPTION>Cloth Upholstery</OPTION><OPTION>Child-proof Locks</OPTION><OPTION>CD Player</OPTION><OPTION>Passenger Side Air Bag</OPTION><OPTION>AM/FM Stereo Radio</OPTION><OPTION>Rear Spoiler</OPTION><OPTION>Console/Storage</OPTION></MISCOPTIONS><MODELFAMILY>NEON</MODELFAMILY><PHOTOCOLOR>TRUE</PHOTOCOLOR><PHOTOLOCAL>FALSE</PHOTOLOCAL><PHOTONAME>image03.jpg</PHOTONAME><PRICE>11900</PRICE><STOCKNUMBER>543730</STOCKNUMBER><TRANSMISSION>Automatic</TRANSMISSION><VIN>1B3ES56C14D543730</VIN><YEAR>2004</YEAR></CAR><CAR><ADDLTEXT>Test Additional Text</ADDLTEXT><BANNER></BANNER><BODYTYPE>Mini Van</BODYTYPE><COLOR>Red</COLOR><CUSTID>edmoe</CUSTID><ENGINESIZE>3.3</ENGINESIZE><ENGINETYPE>6 Cyl.</ENGINETYPE><INDUCTION>Sequential-port F.I.</INDUCTION><MAKE>Dodge</MAKE><MILEAGE>5922</MILEAGE><MISCOPTIONS><OPTION>Air Conditioning</OPTION><OPTION>Cruise Control</OPTION><OPTION>Power Seat</OPTION><OPTION>Power Steering</OPTION><OPTION>Power Door Locks</OPTION><OPTION>Power Windows</OPTION><OPTION>Cassette Player</OPTION><OPTION>Radial Tires</OPTION><OPTION>Alloy Wheels</OPTION><OPTION>Gauge Cluster</OPTION><OPTION>Tilt Steering Wheel</OPTION><OPTION>Tinted Glass</OPTION><OPTION>Interval Wipers</OPTION><OPTION>Rear Defroster</OPTION><OPTION>Driver Side Air Bag</OPTION><OPTION>Dual Sport Mirrors</OPTION><OPTION>Front Bucket Seats</OPTION><OPTION>Reclining Seats</OPTION><OPTION>Cloth Upholstery</OPTION><OPTION>Climate Control</OPTION><OPTION>Rear Window Wiper</OPTION><OPTION>Step Bumper</OPTION><OPTION>Luggage Rack</OPTION><OPTION>CD Player</OPTION><OPTION>Passenger Side Air Bag</OPTION><OPTION>AM/FM Stereo Radio</OPTION><OPTION>Console/Storage</OPTION></MISCOPTIONS><MODELFAMILY>CARAVAN</MODELFAMILY><PHOTOCOLOR>TRUE</PHOTOCOLOR><PHOTOLOCAL>FALSE</PHOTOLOCAL><PHOTONAME>image04.jpg</PHOTONAME><PRICE>22900</PRICE><STOCKNUMBER>553068</STOCKNUMBER><TRANSMISSION>Automatic</TRANSMISSION><VIN>1D4GP45R54B553068</VIN><YEAR>2004</YEAR></CAR><CAR><ADDLTEXT>This is Burst Text.</ADDLTEXT><BANNER></BANNER><BODYTYPE>Pickup Truck</BODYTYPE><COLOR>White</COLOR><CUSTID>edmoe</CUSTID><ENGINESIZE>4.7</ENGINESIZE><ENGINETYPE>8 Cyl.</ENGINETYPE><INDUCTION>Fuel Injected</INDUCTION><MAKE>Dodge</MAKE><MILEAGE>2103</MILEAGE><MISCOPTIONS><OPTION>Air Conditioning</OPTION><OPTION>Cruise Control</OPTION><OPTION>Power Steering</OPTION><OPTION>Radial Tires</OPTION><OPTION>Gauge Cluster</OPTION><OPTION>Tachometer</OPTION><OPTION>Tilt Steering Wheel</OPTION><OPTION>Interval Wipers</OPTION><OPTION>Rear Defroster</OPTION><OPTION>Driver Side Air Bag</OPTION><OPTION>Dual Sport Mirrors</OPTION><OPTION>Cloth Upholstery</OPTION><OPTION>Split Front Bench Seat</OPTION><OPTION>Deluxe Wheel Covers</OPTION><OPTION>Step Bumper</OPTION><OPTION>Cargo Lamp</OPTION><OPTION>CD Player</OPTION><OPTION>Passenger Side Air Bag</OPTION><OPTION>AM/FM Stereo Radio</OPTION><OPTION>Console/Storage</OPTION><OPTION>Airbag On/Off Switch</OPTION></MISCOPTIONS><MODELFAMILY>RAM 1500</MODELFAMILY><PHOTOCOLOR>TRUE</PHOTOCOLOR><PHOTOLOCAL>FALSE</PHOTOLOCAL><PHOTONAME>image05.jpg</PHOTONAME><PRICE>17900</PRICE><STOCKNUMBER>238647</STOCKNUMBER><TRANSMISSION>5 Speed Manual</TRANSMISSION><VIN>1D7HA16N14J238647</VIN><YEAR>2004</YEAR></CAR></ROOT>

**Technophile** · #2 (**permalink**) 09-15-2004, 01:51 PM

I know perl has several modules for processing XML files. Which module to use and how to code it probably depends on your XML file and the data it contains. Supposedly there's a program called XMLSpy that can do this stuff for you, but it isn't free and might not be available on the Mac. If you used perl I'd say google "perl xml" and start reading. I'm sure there's a way this can be done in php as well.

freshtokyo · #3 (**permalink**) 09-16-2004, 07:09 AM

um, i just found that MS Excel cracks it open perfectly. Then will save to a tabbed text file.

**Technophile** · #4 (**permalink**) 09-16-2004, 08:32 AM

Doh, should have thought of that. Go Excel.

**Tekime** · #5 (**permalink**) 09-16-2004, 10:04 AM

Word! (no pun intended)

Excel can be handy.