Home » Community » Newbie corner » CSV file
Re: CSV file [message #43319 is a reply to message #43315] |
Sun, 29 June 2014 22:46   |
 |
forlano
Messages: 1207 Registered: March 2006 Location: Italy
|
Senior Contributor |
|
|
idkfa46 wrote on Sun, 29 June 2014 12:56Hi,
I have a CSV file with a lot of informations about cities. How can i read the file and fill my DropList with all city names?
Here is en example of CVS: (city names in red)
ANDEZENO,(TO),4,0,7.869,45.037,001009,001,01,[color=red]Torino[/color],PIEMONTE
ANDRATE,(TO),4,0,7.875,45.527,001010,001,01,[color=red]Torino[/color],PIEMONTE
ANGROGNA,(TO),2,0,7.225,44.843,001011,001,01,[color=red]Torino[/color],PIEMONTE
ARIGNANO,(TO),4,0,7.902,45.04,001012,001,01,[color=red]Torino[/color],PIEMONTE
AVIGLIANA,(TO),3,0,7.397,45.079,001013,001,01,[color=red]Torino[/color],PIEMONTE
AZEGLIO,(TO),4,0,7.994,45.424,001014,001,01,[color=red]Torino[/color],PIEMONTE
BAIRO,(TO),4,0,7.755,45.386,001015,001,01,[color=red]Torino[/color],PIEMONTE
...
Ciao,
I use Split() to separate a String/row/record in several fields and get what I like.
For example:
FileIn in(filedbname);
while(!in.IsEof())
{
String line = in.GetLine();
Vector<String> fields = Split(line, ","); // , in your case
String city = fields[0];
String prov = fields[1];
//...
String region = fields[10];
}
I hope this is useful for you.
Luigi
[Updated on: Sun, 29 June 2014 22:48] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Mon May 12 15:23:29 CEST 2025
Total time taken to generate the page: 0.03071 seconds
|