Jun 29, 2009 at 01:07 PM

Uploading CSV file into internal table

90 Views

Hi,

I want to upload a CSV file into internal table.The flat file is having values as below:

'AAAAA','2003-10-11 07:52:37','167','Argentina',NULL,NULL,NULL,NULL,NULL,'MX1',NULL,NULL,'AAAA BBBB',NULL,NULL,NULL,'1',NULL,NULL,'AR ',NULL,NULL,NULL,'ARGENT','M1V','MX1',NULL,NULL,'F','F','F','F','F',NULL,'1',NULL,'MX','MMI ',NULL

'jklhg','2004-06-25 08:01:57','456','hjllajsdk','MANAGUA ',NULL,NULL,'265-5139','266-5136 al 38','MX1',NULL,NULL,'hjgkid GRÖBER','sdfsdf dfs asdfsdf 380 ad ased,','200 as ads, sfd sfd abajao y 50 m al sdf',NULL,'1',NULL,NULL,'NI ',NULL,NULL,NULL,'sdfdfg','M1V','dds',NULL,NULL,

Here I can not even split at ',' because some of the values are having value like NULL and some have values with comma too,

The delimiter is a quote and the separator is a comma here.

Can anyone help on this?

Thanks.

Edited by: Ginger on Jun 29, 2009 9:08 AM