fgetcsv - explode - ...

[nightowl]

I am looking for a way to simulate the fgetcsv() functionality for a string. fgetcsv() only support reading from a file ...

I have an array which holds the different lines but using explode() on each line ignores the " " to enclose a field, making it split on each , instead of just the field delimiters.

myfield1, "1,23" returns array ("myfield1", "\"1", "23\"") with explode instead of array("myfield1", "1,23")

explode on "," does not work either - not all fields are enclosed 🙁

Any idea ?

[AstroTeg]

You will need to build your own function to handle comma delimited strings (or you could try finding a code snippet either here or out on the 'net).

Its not difficult to build your own:

• for() the length of the string

• for a quote you encounter, determine if you are in or out of a string

• if you're in a string, then grab each character and save it or keep track of it

• if you're out of a string, look for a comma (if you find a comma, then the string you were working with is done and time to start the next string)

• by technical definition, if the string does not have quotes, it should be handled as a number when possible. This is up to you if you need the number stored as an integer or if storing it as a string is acceptable.

• if you encounter a carriage return ("\n") then that line is done and you can start a new one (any strings you are in are done as well)

• rinse and repeat

I probably have some code around that does this, but I don't have access to my library at the moment...

[Phodetheus]

surely all you need to do is strip out any quotes from your string before doing the explode.

 function stripquotes($instring) {
  	$striped = "";
	$length = strlen($instring);
	for ($loop = 0 ; $loop <= $length ; $loop++) {
		$char = substr($instring, $loop, 1);
		if ($char == "\"") $char = " ";
		if ($char == "'") $char = " ";
		$striped .= $char;
	} 
  return($striped);
  }