Dhanasekaran
Member
Hello,
I have a problem in reading the CSV file in our program.
Examle:
CSV row1 : 117021, 562012, Oilcompany Ltd, 1229802
CSV row2: 117021, 562076, L&C Brother Holdings, Inc, 1229541
Table Field 1 Field 2 Field 3 Field 4 Field 5
CSV row1 117021 562012 Oilcompany Ltd 1229802
CSV row2 117021 562076 L&C Brother Holdings Inc 1229541
The row 1 was looks good and reading the records as expected. The row 2 vendor name string as L&C Brother Holdings, Inc, this is spliting because the string having the comma inside, this is wrong.
Could someone pls tell me how to read L&C Brother Holdings, Inc as one string not two.
I have a problem in reading the CSV file in our program.
Examle:
CSV row1 : 117021, 562012, Oilcompany Ltd, 1229802
CSV row2: 117021, 562076, L&C Brother Holdings, Inc, 1229541
Table Field 1 Field 2 Field 3 Field 4 Field 5
CSV row1 117021 562012 Oilcompany Ltd 1229802
CSV row2 117021 562076 L&C Brother Holdings Inc 1229541
The row 1 was looks good and reading the records as expected. The row 2 vendor name string as L&C Brother Holdings, Inc, this is spliting because the string having the comma inside, this is wrong.
Could someone pls tell me how to read L&C Brother Holdings, Inc as one string not two.