CODEWITHSUNDEEP
phpcsvexport-to-csv
Code Mania
Code Mania

Reputation: 29

Issue in parsing csv data php | regex replace commas inside of quotes

Anyone share code in php to parse csv data . While am parsing data i got values inside double quotes as separate array so my logic will change . I need to store this data to mysql DB. My sample csv file is below

com,24,2.1.0.5,en,mido,2020-11-01T03:29:32Z,1604201372915,2020-11-01T03:29:32Z,1604201372915,5,,Nice👍👍,2020-11-01T06:34:23Z,1604212463397,"Hi Raju, Thank you so much",497230

com,24,2.1.0.5,en,athene_f,2020-11-01T04:19:52Z,1604204392095,2020-11-01T04:19:52Z,1604204392095,5,,So so,2020-11-01T06:33:58Z,1604212438170,"Hi dev, Thanks",497230

code

$csv_file = 'csv/test.csv';

$file = fopen($csv_file, "r");
fgetcsv($file);
$count=0;
while (($getData = fgetcsv($file, 10000, ",")) !== FALSE)
 {
$getData = preg_replace('/[\x00-\x1F\x80-\xFF]/', '', $getData);
$getData = implode(",", $getData);
$getData = '\''.substr($getData , 1, -1).'\'';
$getData =explode(",", $getData);
$exp_array = explode(",", $getData);
$package_name  = trim($getData[0]); 
$app_version_code  = trim($getData[1]); 
$app_version_name  = trim($getData[2]); 
$reviewer_language = trim($getData[3]); 

 ob_get_clean();

}

expected output

Array
(
    [0] => com
    [1] => 24
    [2] => 2.1.0.5
    [3] => en
    [4] => mido
    [5] => 2020-11-01T03:29:32Z
    [6] => 1604201372915
    [7] => 2020-11-01T03:29:32Z
    [8] => 1604201372915
    [9] => 5
    [10] => 
    [11] => Nice👍👍
    [12] => 2020-11-01T06:34:23Z
    [13] => 1604212463397
    [14] => Hi Raju, Thank you so much
    [15] => 497230
)

Upvotes: 0

Views: 97

Answers (2)

Honk der Hase
Honk der Hase

Reputation: 2488

These 2 lines are 100% incorrect...

$getData =explode(",", $getData);
$exp_array = explode(",", $getData);

givn, that $getData contains a string, after explode() it will be an array (reassigned to $getData).

On the next line, this array is tried to be exploded again, but this will fail and give you warnings or errors.

Turn up error reporting level and display all errors on screen during development.

Upvotes: 0

Cully
Cully

Reputation: 6975

I just ran this and got the output you indicated you were expecting:

<?php

$file = fopen('input.txt', "r");

while (($data = fgetcsv($file, 10000, ",")) !== FALSE) {
    print_r($data);
}

Here's input.txt:

com,24,2.1.0.5,en,mido,2020-11-01T03:29:32Z,1604201372915,2020-11-01T03:29:32Z,1604201372915,5,,Nice👍👍,2020-11-01T06:34:23Z,1604212463397,"Hi Raju, Thank you so much",497230
com,24,2.1.0.5,en,athene_f,2020-11-01T04:19:52Z,1604204392095,2020-11-01T04:19:52Z,1604204392095,5,,So so,2020-11-01T06:33:58Z,1604212438170,"Hi dev, Thanks",497230

And here's the output:

Array
(
    [0] => com
    [1] => 24
    [2] => 2.1.0.5
    [3] => en
    [4] => mido
    [5] => 2020-11-01T03:29:32Z
    [6] => 1604201372915
    [7] => 2020-11-01T03:29:32Z
    [8] => 1604201372915
    [9] => 5
    [10] =>
    [11] => Nice👍👍
    [12] => 2020-11-01T06:34:23Z
    [13] => 1604212463397
    [14] => Hi Raju, Thank you so much
    [15] => 497230
)
Array
(
    [0] => com
    [1] => 24
    [2] => 2.1.0.5
    [3] => en
    [4] => athene_f
    [5] => 2020-11-01T04:19:52Z
    [6] => 1604204392095
    [7] => 2020-11-01T04:19:52Z
    [8] => 1604204392095
    [9] => 5
    [10] =>
    [11] => So so
    [12] => 2020-11-01T06:33:58Z
    [13] => 1604212438170
    [14] => Hi dev, Thanks
    [15] => 497230
)

If you are not getting the expected output, one other thing to check is the file encoding on your CSV file. It could be that your PHP script is expecting your file to be utf-8 encoded, but your file is using another encoding. There are lots of resources online for detecting file encoding and converting using PHP.

Upvotes: 1

Related Questions