I'm on a Win XP Pro SP3 box, using Delphi 7 Ent & PHP 5.1.4.
I'm using Ultra Edit v14 as my text editor to create text based test files.
When reading a text file in Delphi and PHP , the following characters are at the end of each line: "\r\n".
How can I strip these characters once I've read them into a variable? Is there a MySQL function to strip the characters when doing a mySQL INSERT or UPDATE command?
A Delphi, PHP or MySQL solution would be perfect.