Reading delimited CSV files

[PB&J Lover]

Hello PB users,

Is there a simple (native) way to read in a comma delimited csv file with PB? In another language they had inputto which allowed you to give it a character for the delimiter.

Or do I have to do it the hard way and parse each line?

Thanks again.

[Num3]

Command is StringField(String$, Index, Delimiter$)

[PB&J Lover]

Yes, I did know to use that. I was just asking if there was a way to read in a delimted file directly. But this will work. Thanks.

[thefool]

I was just asking if there was a way to read in a delimted file directly.

isnt that directly?

[PB&J Lover]

Well, no. First I have to read in the string, then I set up a parcing routine with with FindString() but I'll also have to move the position variable for each find.

A direct method would be:

Code: Select all

A$(x) = inputto$(#File,Delimiter$)

Where "inputto$" reads the delimited file directly into a variable as a loop advances the index (this sort of thing is very PB-like).

But I can set up the parcing routine for each line read in.

Thanks.

[Dare2]

That would be good.

If PureBasic implemented a "split" function, creating arrays from char delimited strings, it would be good too, and much faster than doing this through a countfield/stringfield loop process.

And (on a roll) allowing the seperator to be longer than one char would also be good!

[thefool]

ah okay misunderstood it.

[aszid]

I've dealt with loading CSV files a few times before, i would post my code for you, but i'm at work and it's at home >.<

Anyhow, what would be really awesome is a version of the php explode command for PB. it is so much more usefull than *just* csv files.