XML parser question

Question

jencinas69 0 Junior Poster in Training

15 Years Ago

Question

My xml parser is runing into an error when I try to parse the attached csv I think is because of the three commas before the description, I clean the file manually and leave only 1 comma and it work. I there any way I can identify the extram commas and get ride of the with the csv2xml parser php file ?

files attache in zip format

Thank you

php

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

files.zip (64.22 KB)

2 Contributors
1 Reply
65 Views
23 Hours Discussion Span
Latest Post 15 Years Ago Latest Post by digital-ether

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

digital-ether 399 Nearly a Posting Virtuoso Team Colleague · Answer 1 · 2008-06-17T18:06:56+00:00

Question
My xml parser is runing into an error when I try to parse the attached csv I think is because of the three commas before the description, I clean the file manually and leave only 1 comma and it work. I there any way I can identify the extram commas and get ride of the with the csv2xml parser php file ?
files attache in zip format
Thank you

You could run the csv file through preg_replace_all() and have the redundant commas removed.

eg:

$txt = preg_replace("/,+/", ',', $txt);

Seems to me that the function that parses the CSV to XML is ok, only the CSV file is malformed since it defines only 3 columns in the first row but has more then three columns of data in some of the subsequent rows (the extra commas).