Skipping blank lines while reading a file Options

[CharlesEF]

Hi All,

Sounds simple, right? Well, I find that it turns out not to be. Nothing I've tried has worked. So, maybe someone else has a better idea.

The attached sample file is part of a bigger file generated by Excel 2016. It is formatted as UTF-16 LE but I re-save it as UTF-8. The goal of the script is to print only non blank lines but I can't get it to work.

Does anyone have a better idea?


Thanks for any and all help,

Charles
 read_file.php ( 467bytes ) Number of downloads: 398
 sample.txt ( 16.75k ) Number of downloads: 383

I had to rename sample.sql to sample.txt in order to upload it. You will either have to change it back or change the script.

[CharlesEF]

A follow up to !empty not skipping blank lines. As I tested I found that there where 2 spaces at the end of the line. This made me realize the str_replace search order was wrong. It was finding and replacing based on \n then \r, not \r\n. This is the fix:

CODE

  $sql = str_replace(array("\r\n", "\n", "\r"), "", $sql);

This corrects the 2 space problem (now I just remove newlines). But, before removing newlines I tried replacing them with a space. !empty did not skip the blank lines. When I replace newlines with a 0 !empty did skip blank lines. I checked the docs and a space should be considered empty. Oh well, at least it works now.