How can I prevent line break when reading a CSV text file with php?

Question

I have a CSV text file which contains serval entries of "books", each book is on one line (separator: line break), and each column is separated by a tabulation.

I'm reading the content the file with :

$books = file( "/path/to/file/mycsv.txt" , FILE_SKIP_EMPTY_LINES );

That way I can go throuhg each element of the "books" array and read my individual "book" data.

The problem is that each book has a "description" column, which also contains line breaks. On import, this messes up the data, as it creates a line break before the end of an item.

How can I prevent that ?

Are you aware of php.net/manual/en/function.fgetcsv.php ?

Tomalak
– Tomalak

2011-06-06 12:17:22 +00:00
Commented Jun 6, 2011 at 12:17 — Tomalak
– Tomalak, Commented Jun 6, 2011 at 12:17

Femi · Accepted Answer · 2011-06-06 12:18:05Z

3

Does your file include quotes around the description column, because if it does I believe fgetcsv handles that situation.

answered Jun 6, 2011 at 12:18

Femi

64.8k8 gold badges120 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sujit Agarwal · Accepted Answer · 2011-06-06 12:17:31Z

1

You can use PHP RTRIM to trim the line breaks. or you can use a inbuilt feature of php fgetcsv to fetch the file.

answered Jun 6, 2011 at 12:17

Sujit Agarwal

12.5k11 gold badges50 silver badges79 bronze badges

Collectives™ on Stack Overflow

How can I prevent line break when reading a CSV text file with php?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related