[RESOLVED] formating the string

learnphp1

I have a csv file that is enclosed by "". i am inserting it in the database but need to take the "" out of the string. How can i do this.

eg. "a" all i want to insert is a

 
 while (($data = fgetcsv($handle, 1000, ",",'"')) !== FALSE) {

This is how i loop in the file

Thanks in advance

bradgrafelman

What does the CSV data look like? Specifying the fourth parameter in [man]fgetcsv/man will automatically remove that delimiter when the data is split into an array.

learnphp1

The data looks like this in csv file

"Bun" "WB" "'Yes' Light" "HU" "20"

But it does enter the quotes in database

learnphp1

bradgrafelman;10969791 wrote:
What does the CSV data look like? Specifying the fourth parameter in [man]fgetcsv/man will automatically remove that delimiter when the data is split into an array.

The data looks like this in csv file

"Bun" "WB" "'Yes' Light" "HU" "20"

But it does enter the quotes in database

bradgrafelman

There are no commas in the sample data you posted, and yet you specified a comma as the field delimiter in the [man]fgetcsv/man call... ?

EDIT: For example, if your field delimiter is actually a tab character, and you specify this in the call to fgetcsv(), then the array returned for the sample data you posted looks like:

Array
(
    [0] => Bun
    [1] => WB
    [2] => 'Yes' Light
    [3] => HU
    [4] => 20
)

learnphp1

bradgrafelman;10969800 wrote:
There are no commas in the sample data you posted, and yet you specified a comma as the field delimiter in the [man]fgetcsv/man call... ?

I just copied the data from a csv file. which means the file has commas in them i suppose.

"Bun" , "WB", "'Yes' Light", "HU" "20"

I have edited for ur ready reference.

bradgrafelman

Either way, the output will be the same assuming that the parameters you specify for fgetcsv() are correct.

Do a [man]print_r/man on $data and show us what the output looks like.

learnphp1

bradgrafelman;10969805 wrote:
Either way, the output will be the same assuming that the parameters you specify for fgetcsv() are correct.

Do a [man]print_r/man on $data and show us what the output looks like.

Sorry this is still not resolved

the data goes in is this

1 "Bundled" "WB "'Yes' Light" "HU 0

learnphp1

bradgrafelman;10969805 wrote:
Either way, the output will be the same assuming that the parameters you specify for fgetcsv() are correct.

Do a [man]print_r/man on $data and show us what the output looks like.

print_r gives me this result

Array ( [0] => "Bundled" [1] => "WB" [2] => "'Yes' Light" [3] => "HU" [4] => "20" ) Number of Records 1 File uploaded Successfully