I am having difficulty parsing some Tab separate files that do not have a header row. Occasionally magicparser will concatenate two fields instead of reading them separately. If i try to open the file in Excel it works fine (the values are all in their own fields)
Any suggestions?
Hi David,
Im not autodetecting the format string - im manually using csv|9|0|0. Could it have something to do with different sized tabs? I will email you the file to take a look
Hi,
This could happen if quoted text has been incorrectly auto-detected. From your description, the format string in use should be:
csv|9|0|0
(tab-separated, no header row, not quoted text)
If you're still having the same problem after using the above format string in your call to MagicParser_parse(); would it be possible for you to email me the file (as an attachement) so that I can take a look for you? Reply to your reg code or forum registration email is the easiest way to get me...
Cheers,
David.