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.
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.