Which is the best CSV parser?
I tried using Text::CSV - which works good for any Standard CSV records.
Recently I got a problem where in a file - the records are sometimes encapsulated and sometimes not. Can we handle this in one Parser.
Also intrestingly this worked for me while using Text-CSV v1.13; but failed when using Text-CSV v1.21.
The secnario what I have is something like below,
field1,field2,some desc with inch 10",field3
field1,field2,"some desc with sep, and other",field3
CSV object was set with encapsulation(") and this works well while using Text-CSV v1.13, but not with Text-CSV v1.21
Appreciate your views.