Remove ¶-symbol from CSV import

Question

I'm importing a CSV file, but for some reason, every line ends with the ¶-symbol... So my database is contaminated with all this symbol. And above all, it's ruining my workflows.

So I would like to strip those symbols.

I've tried with $csv_value = preg_replace( '/\s+/', '', $csv_value); but this line of code also deleted my spaces...

How can I just remove the ¶ symbol from my $csv_value?

score 1 · Accepted Answer · edited May 23 '17 at 11:56

1

¶ - it is newline symbol, try this:

$result = preg_replace('/[^[:print:]]/', '', $csv_value);

This question already answered, other examples you can find on this link: PHP: How to remove all non printable characters in a string?

edited May 23 '17 at 11:56

Community

1
1

answered Jul 30 '13 at 13:38

galkindev

156
4

Thanks for your effort, but still not solution :( – Michiel Jul 30 '13 at 13:40
Indeed, this was my solution!! Thanks a lot! – Michiel Jul 30 '13 at 13:55

score 0 · Answer 2 · answered Jul 30 '13 at 13:33

0

The ¶ symbol is denoted as a line break, so try this:

$csv_value = preg_replace( '/\n+/', '', $csv_value);

answered Jul 30 '13 at 13:33

JWMarchant

356
2
8

Remove ¶-symbol from CSV import

2 Answers2