Hello I have my data in csv file like this: 111111,0,CANCUN REGION 96,QUINTANA ROO,PENINSULAR,12,1D,BIMESTRAL PAR,2018,12,108,91.02 111112,0,CANCUN REGION 96,QUINTANA ROO,PENINSULAR,12,1D,BIMESTRAL PAR,2018,2,141,122.57 111113,0,CANCUN REGION 96,QUINTANA ROO,PENINSULAR,12,1D,BIMESTRAL PAR,2018,5,67,46.69 ... (6million more data) The file is 500MB, it's so much that MATLAB can't import with it because my computer begins to freeze. So this is what I need to do: Where it say "CANCUN REGION" it the name of a city, in the file there are so many names and I only need to work with CANCUN REGION Then, when I have only the data of the city I want, I need to do an excel, there will be the first number and four, two and one before the last one and save the excel as "REGION CANCUN" . Exemple: 111111, BIMESTRAL PAR, 12,108 Please tell me some method that I can work or funtions maybe can be usefull :)

read a csv file with text

조회 수: 10 (최근 30일)

Ricardo Cachu 2019년 9월 26일

댓글: Stephen23 2019년 9월 26일

Hello

I have my data in csv file like this:

111111,0,CANCUN REGION 96,QUINTANA ROO,PENINSULAR,12,1D,BIMESTRAL PAR,2018,12,108,91.02

111112,0,CANCUN REGION 96,QUINTANA ROO,PENINSULAR,12,1D,BIMESTRAL PAR,2018,2,141,122.57

111113,0,CANCUN REGION 96,QUINTANA ROO,PENINSULAR,12,1D,BIMESTRAL PAR,2018,5,67,46.69

... (6million more data)

The file is 500MB, it's so much that MATLAB can't import with it because my computer begins to freeze.

So this is what I need to do:

Where it say "CANCUN REGION" it the name of a city, in the file there are so many names and I only need to work with CANCUN REGION
Then, when I have only the data of the city I want, I need to do an excel, there will be the first number and four, two and one before the last one and save the excel as "REGION CANCUN" . Exemple: 111111, BIMESTRAL PAR, 12,108

Please tell me some method that I can work or funtions maybe can be usefull :)