Posted 28 March 2006 - 06:05 PM
Well, this time, something new (to me)..
I was reading a file to export it to db, and the file have a textarea with some \n, \t, \n\t, \t\n, (...).
I want to write it in a blob in the db.. but.. its export wrong..
I've tried to use ltrim, rtrim, trim, but its only remove left and right .. not int the middle..
So, i've seen the preg_replace in the documentation, but ive never saw it before..
Someone help me?
Posted 28 March 2006 - 06:10 PM
I say old chap, that is rather amusing!
Posted 28 March 2006 - 06:20 PM
I have one DB in the server X, I have to read the data and write into the DB at server H.
So, I export it to a [data.txt] file, because I need to rewrite some data and turn it compatible with the new DB.
The "textarea" i've been said is just a BLOB in the old DB, but when i write it in the file, this write with that \n and \t characters.
I export the file, read and replace the adaptations, and import to new DB, in theory.
This old-blob give me a headshake with itself string.. I need to replace the \n for new lines to write and lost the \t (tabs), so I can write it into the new-blob..
Clean now? sorry for bad sentences.. ^^"!
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users