Csv file data reading

what if csv file like this?

branch,date,item,amount,city Mirovice,2018-11-22T09:27:33Z,Spinach - Baby,332.65,Khao Wong Weepangali,2018-07-02T16:01:26Z,Dates,937.59,Yu’erhong Sambonggede,2018-01-13T20:28:23Z,Cheese - Cheddar With Claret,642.75,Hampang Quán Hàu,2018-10-22T19:27:00Z,Chick Peas - Canned,996.92,Desa Werasari Liwonde,2018-01-11T04:04:13Z,Bread Crumbs - Japanese Style,768.55,San Ignacio Faeanak Dua,2018-10-11T15:40:07Z,Sea Bass - Whole,170.57,Mabasa Bacnotan,2018-07-06T16:11:41Z,Beef Tenderloin Aaa,926.00,Tijão Bhalil,2018-05-06T00:05:04Z,Cake - Miini Cheesecake Cherry,603.03,La Dorada ‘Ayn Ḩalāqīm,2018-06-19T09:29:16Z,Bar Special K,592.09,Beltinci Néa Pélla,2018-03-05T16:43:13Z,Beef Cheek Fresh,652.37,Causip Zhongling,2018-11-05T17:23:30Z,Beef Wellington,530.45,Peicheng Era,2018-03-30T02:00:44Z,Fudge - Cream Fudge,133.83,Casal da Serra Huiqi,2018-03-08T02:07:25Z,"Beef - Ox Tongue, Pickled",567.17,Neiva Hwado,2018-01-18T11:43:46Z,Stainless Steel Cleaner Vision,214.39,Dili Laironja,2018-12-25T13:51:34Z,Sauce - Balsamic Viniagrette,885.29,Fangtai

Remember this there is more than one item which are separated with comma.......

1 answer

  • answered 2019-01-11 05:27 Poojan

    it is like name,surname,hobbies a,b,swim,walk

    so here 2 values fro hobbies and it also separated with the "," so how to retrieve this data