You are here:  » Unable to auto-detect format for the following CSV example

Support Forum



Unable to auto-detect format for the following CSV example

Submitted by PHPGuru on Sat, 2008-01-19 13:16 in

Hi Everyone,

First of all, congratulations to MagicParser developer. Nice job!

I tried to parse the following CSV but MagicParser is failing:

'ID';'Referrer ID';'Parent ID';'First name';'Company'
'ksjfdfkj';'30984309';'';'MY NAME';'MY COMPANY'

At first, I thought that it was a problem on my side but when I tried this CSV on MagicParser website demo area, results are the same:

Field:
ID;Referrer ID;Parent ID;First name;Company

Content:
ksjfdfkj;30984309;;MY NAME;MY COMPANY

When I define the format manually, it works. So the problem is on format detection. How can I fix this?

Thanks for any help.

Submitted by support on Sat, 2008-01-19 13:21

Hi there,

Semi-colon separated values is not auto-detected; because it is not possible to successfully differentiate this format from other separation characters as the semi-colon frequently appears within normal text fields, so in this situation you will need to specify a format string.

Cheers,
David.