Doubt while reading a CSV format file.
i am having adoubt reagrding CSV format file.
see the below code
READ DATASET p_file INTO g_string.
IF sy-subrc NE 0.
REPLACE 'Zebith FOODSERVICE, INC'
WITH 'Zebith FOODSERVICE INC'.
IF sy-index LT p_first.
SPLIT g_string AT ',' INTO TABLE itab_split.
My doubts suppose we have data in the g_string like this
'5774' , 'Zebith foodService inc' , 'xxxxx' , '23564' , '984560' , ' 2/15/2007' , '28' , '1,487'
How will the data will be stored in itab_split.Since we are using comma as a seperator suppose within the amount or Quanity field if we have "," comma then how the data will be stored in itab_split ?will it treT THE aMOUNT VALUE '1,487' AS A INDIVIDUAL VALUE IN ITAB_SPLIT AS 1,487 OR A SEPERATED VALUES "1" AND "487"?