dongmin1166
2018-12-10 11:19 阅读 27
已采纳

fgetcsv错误地解释数字[关闭]

I have a problem when I read csv files that contain values like 886468000000, it gets parsed as 8,86468E+11, which is a huge problem for my app, because I need to parse and retain the number in original form.

I google around the documentation and found nothing, I also tried retypging the exponential string representation as float during parsing , but that does not work either, it returns 8, which is obviously incorrect.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    duanniedang3946 duanniedang3946 2018-12-10 13:40

    After testing with PHP 7.2.8 x86 and x64 below are my observations.

    The reason that 8,86468E+11 is being converted to 8 is because of PHP's type-casting behavior when a comma is used instead of a period as the decimal separator. See below:

    echo (float) '8,86468E+11'; // 8 wrong
    
    echo (float) 8,86468E+11; // 88646800000000000 still wrong but getting close
    
    echo (float) '8.86468E+11'; // 886468000000 success!
    
    echo (float) 8.86468E+11; // 886468000000 success!
    

    The primary issue for you is that your decimal separator is a comma instead of a period so to remedy this you will need to make use of str_replace():

    $my_num_from_csv = '8,86468E+11';
    
    $my_num_from_csv = (float) str_replace( ',', '.', $my_num_from_csv );
    
    echo $my_num_from_csv; //886468000000
    
    点赞 评论 复制链接分享

相关推荐