strip "

[nikko50]

Hi there. I have an array called $fileArray. I would like to strip out all the quotes " in the array. What is the functuion for this

[tsinka]

Hi,

depends a little bit on the array but do something like this:

foreach(array_keys($fileArray) as $key) {
  $fileArray[$key] = str_replace('"','',$fileArray[$key]);
}

Another solution would be to strip the double quotes when building the array.

Thomas

[nikko50]

Hi Thomas. This is how my code looks now...

$fileArray = file("CSVload.txt");

$c = 0;
$r = 1;
while ($r <= count($fileArray)) {
$fields = explode(",", $fileArray[$c]);

$id = $fields[0];
$name = $fields[1];
$address = $fields[2];
$city = $fields[3];
$state = $fields[7];

$zip = $fields[4];
$phone = $fields[5];

[tsinka]

Ok,

then try something like this:

$fileArray = file("CSVload.txt"); 

foreach($fileArray as $value) {
  $value = str_replace('"','',$value);
  $fields = explode(",", $value); 

  $id = $fields[0]; 
  $name = $fields[1]; 
  $address = $fields[2]; 
  $city = $fields[3]; 
  $state = $fields[7]; 
  $zip = $fields[4]; 
  $phone = $fields[5];
......
}

But you might run into (memory) problems if the csv file is very large. I'd suggest to use fopen,fread instead.

Thomas

[Installer]

Nothing wrong with tsinka's solution, but if your array is Very Large, this can possibly quicken things some:

$unquoted_array = str_replace('"', '', $fileArray);  

foreach($unquoted_array as $value) { 
    $fields = explode(",", $value);
    ...
}

Or, perhaps, to incorporate tsinka's fopen() suggestion:

$fp = fopen($file_name, 'r');
$file_str = fread($fp, filesize($file_name));
fclose($fp);
$unquoted_file_str = str_replace('"', '', $file_str);
$unquoted_file_arr = explode ("\n", $unquoted_file_str);
foreach ($unquoted_file_arr as $value) {
    $fields = explode(',', $value);
    ...
}