coool Posted July 25, 2007 Share Posted July 25, 2007 Hi I'm using PHP to read row by row a text file and insert it in my database everything is working fine, BUT ! i've noticed that about 10 columns have a return charachter - that's making a problem because the php consider these return charachters as a new line (new row) example: apple 1 fruit orange 2 fruit bana na 1 fruit ___________________ $output = str_replace("\t", "|", $data); $values = explode("\n", $output,-1); foreach($values as $row) { $col = explode("|", $row); //... etc } how can i escape or replace the \n in the column value by a space !!! i tried to str_replcae all \n by a space but that doesn't work as this removes all \n i.e there's only one row to read which contains all the data Link to comment https://forums.phpfreaks.com/topic/61690-reading-text-problem-carriage-return-character/ Share on other sites More sharing options...
coool Posted July 25, 2007 Author Share Posted July 25, 2007 imagine that this is the example apple 1 fruit 74 orange 2 fruit 213 bana na 1 fruit 345 so I'm sure that the final \n have a number before it.. but i don't know about the value !! so assuming that the value have only characters i want to replace any \n or \r found inside that value by a space !! okay the last record of every line is a number (not a character) i.e. why don't i say... replace all \n that is after a character with a space !! I'm trying to form the regx !! this doesn't work but it's near ! $data = preg_replace("/\[a-zA-Z]\\n\$/", "\\s", $data); any help in forming the regx please !? Link to comment https://forums.phpfreaks.com/topic/61690-reading-text-problem-carriage-return-character/#findComment-307131 Share on other sites More sharing options...
akitchin Posted July 25, 2007 Share Posted July 25, 2007 try specifying a newline character that immediately proceeds any non-digit, rather than specifying that it proceed a letter: $data = preg_replace("/([^0-9])\\n/", "$1\\s", $data); i'm not always spot-on the first time with regex, so i can't make any promises. Link to comment https://forums.phpfreaks.com/topic/61690-reading-text-problem-carriage-return-character/#findComment-307148 Share on other sites More sharing options...
coool Posted July 26, 2007 Author Share Posted July 26, 2007 I've solved the problem.. thanks Link to comment https://forums.phpfreaks.com/topic/61690-reading-text-problem-carriage-return-character/#findComment-308254 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.