I have a long text file that need to be processed by php. The text file is actually a backup of MySQL database. I need you to strip off unwanted text from each line. Below is are samples of lines from that text file:
(1, 'Test', '', 0, 0, 0, ''),
(11755, 'Sony Recovery Cd', '', 0, 0, 0, ''),
(3, 'Dvd Player', '', 0, 0, 0, ''),
(4, 'Portable Dvd Player', '', 0, 0, 0, ''),
(5, 'Dvd Player Software', '', 0, 0, 0, ''),
(6, 'Free Dvd Player', '', 0, 0, 0, ''),
After you strip off unwanted lines, the list should look like this:
Test
Sony Recovery Cd
Dvd Player
Portable Dvd Player
Dvd Player Software
Free Dvd Player
I also want the programmer to make sure that there are no redundant sapce characters between words. Also make sure that there are no character sapce at the beginning or end of each line.