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

4 visualizzazioni (ultimi 30 giorni)

Ricardo Cachu il 26 Set 2019

Commentato: Stephen23 il 26 Set 2019

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 :)