text file import trouble

This is my situtation - can someone give me a nod in the right direction?

I am building some code for someone to automate lists of quotes. He sent me a text file where he cut and pasted the quotes (these are HK movie quotes. Looked something like this:

A bit suffocated on the chest.[
A fan called for disturbance.[
A gentleman should help the need.[
A man who disguised as woman beated me.[

1375 of them altogether.

I used this code to read the file and insert them into the database:



This seemed to work fine until I realised my MySQL LIKE statements were not working. An initial A was not an initial A. THen I did a MySQL dump and discovered this:

INSERT INTO bwg_quotes VALUES (1, 'A bit suffocated on the chest.', NULL, 0);
INSERT INTO bwg_quotes VALUES (2, 'rnA fan called for disturbance.', NULL, 0);
INSERT INTO bwg_quotes VALUES (3, 'rnA gentleman should help the need.', NULL, 0);
INSERT INTO bwg_quotes VALUES (4, 'rnA man who disguised as woman beated me.', NULL, 0);

(1375 of them)

How do I get rid of the initial linefeed characters - I can't see them except when I do the dump?

The "rn" are carriage return and line feed characters. You can either use trim() to remove these when you load quotes into the database, or one using MySQL functions for the data already in the db:

Got ya - thank you