codeigniter - PHP Reading string as exponential number

640

I am reading a CSV file to import data. I am having a column with some auto-generated numbers(text & Numbers). The problem is in some of the rows my script reads the value as exponential number.

Example: 58597E68 is considered 5.86E+72

I need it to read as String as not number. The issue occurs only if I am having the character (E) in middle of the auto-generated number.

$feed = 'path-to-csv/import.csv';
    if (!file_exists($feed)) {
        //$feed = 'import.csv';
        exit('Cannot find the CSV file: ' . $feed);
    }
    $row=0;

    if (($handle = fopen($feed, 'r')) !== FALSE) {
        while (($data_csv_rows = fgetcsv($handle, 1000000, ',')) !== FALSE) {

            $row++;
            if ($row == 1) {
                continue;
            } // skipping header row
            echo "Row " . ($row-1) . "<br>";print_r($data_csv_rows);echo "<br><br>";
        }
    }

950

Answer

Solution:

The problem is not your CSV but the original software (probably Excel) that produced the CSV.

CSV is a simple data format when you find something like5.86E+72 it's like that in the CSV data and it's too late to fix it.

To avoid this make sure you .

Some PHP code to find this kind of bad data in a field:

if (strpos($value, 'E+') !== FALSE) {
    preg_match('~E\+[0-9]+$~', $value, $preg_result);
        if (isset($preg_result[0])) {
            die('Probably wrong data found within "'.$value.'".');
        }
    }
}

In your case it seems that58597E68 is converted tofloat(5.8597E+72).

At least with I can not recreate the problem, see https://3v4l.org/RZ1eA.

By definition it would be correct, since there are no " around this data, so PHP tries to determinate the type of this data and if it is potentally a numeric value... So be sure add " around strings. PHP String to Numeric Conversion documentation.

Update: I can not reproduce your use-case!58597E68 becomes"58597E68" withstr_getcsv() and withfgetcsv() It is not autoconverted to float! See https://3v4l.org/oXkBu for details! I suspect there is something wrong with the data you provide us or your validation.

People are also looking for solutions to the problem: php - Laravel - query from database and save to another

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question