U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » Community » Newbie corner » CSV file

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

CSV file [message #43315]

Sun, 29 June 2014 12:56

idkfa46
Messages: 155
Registered: December 2011

Experienced Member

Hi,
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
...

I have found that functions in utilities:
- String CsvString(const String& text)
- Vector<String> GetCsvLine(Stream& s, int separator, byte charset)
but I'm in trouble trying to use them...

May I have an example?

Regards,
Matteo

Report message to a moderator

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

Hi,
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