Remove End of Line Characters
in [Windows]
|
Prev: sonant basilary
Next: Executing Shell Scripts in PHP
From: "Wei, Alice J." on 30 Jun 2008 13:24 Hi, I have a simple file as follows: There are in the total of 513 words in sinus.txt, lung.txt and stomach.txt. 151 sinus.txt 105 lung.txt 257 stomach.txt What I want to do is to print the first line in the Description column, and have each of the following lines be entered into the database by assigning the number as $words, and the filename into the Filename column. The script in the following performs exactly the way I wanted, except for the fact that in my database, each of the entries looks something like this: sinus.txt followed by a square for each of the variables that contains text. I don't have this problem for my numbers at all. for ($i=1; $i <= 3; $i++) { echo $i . ": " . $lines4[$i] . "\n"; list($words, $file) = explode(" ", $lines4[$i]); echo "File: $file has $words words\n\n"; substr($file, 0, -3); //substr($lines4['0'],0,-1); $query3="INSERT INTO youtoo(Description,Filename,Words) VALUES ('$lines4[0]','$file', '$words')"; $result1= mssql_query($query3) or die ("Couldn't Create New Entry into Database $myDB"); } I tried using rtrim(), chop() using the $line4 as I have declared and there is no use. Finally, I used substr(), but this does not seem to get what I wanted either, and the square is still in the way. I checked my text file in the text editor, and I see nothing that could have produced the square during the database entering process. Does anyone know what I have done wrong here? Anything is appreciated. Alice ====================================================== Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington ajwei(a)indiana.edu
From: "Zephaniah ha Levi" on 30 Jun 2008 13:41 My guess is that the squares are line feed or carriage returns. Do a str_replace on \r and \n -----Original Message----- From: Wei, Alice J. [mailto:ajwei(a)indiana.edu] Sent: Monday, June 30, 2008 1:25 PM To: php-windows(a)lists.php.net Subject: [PHP-WIN] Remove End of Line Characters Hi, I have a simple file as follows: There are in the total of 513 words in sinus.txt, lung.txt and stomach.txt. 151 sinus.txt 105 lung.txt 257 stomach.txt What I want to do is to print the first line in the Description column, and have each of the following lines be entered into the database by assigning the number as $words, and the filename into the Filename column. The script in the following performs exactly the way I wanted, except for the fact that in my database, each of the entries looks something like this: sinus.txt followed by a square for each of the variables that contains text. I don't have this problem for my numbers at all. for ($i=1; $i <= 3; $i++) { echo $i . ": " . $lines4[$i] . "\n"; list($words, $file) = explode(" ", $lines4[$i]); echo "File: $file has $words words\n\n"; substr($file, 0, -3); //substr($lines4['0'],0,-1); $query3="INSERT INTO youtoo(Description,Filename,Words) VALUES ('$lines4[0]','$file', '$words')"; $result1= mssql_query($query3) or die ("Couldn't Create New Entry into Database $myDB"); } I tried using rtrim(), chop() using the $line4 as I have declared and there is no use. Finally, I used substr(), but this does not seem to get what I wanted either, and the square is still in the way. I checked my text file in the text editor, and I see nothing that could have produced the square during the database entering process. Does anyone know what I have done wrong here? Anything is appreciated. Alice ====================================================== Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington ajwei(a)indiana.edu -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
From: "Wei, Alice J." on 30 Jun 2008 14:46 Hi, for ($i=1; $i <= 3; $i++) { echo $i . ": " . $lines4[$i] . "\n"; list($words, $file) = explode(" ", $lines4[$i]); $carriage= array("\r\n", "\r", "\n"); str_replace($carriage, "", $lines4[$i]); echo "File: $file has $words words\n\n"; $query3="INSERT INTO youtoo(Description,Filename,Words) VALUES ('$lines4[0]','$file', '$words')"; $result1= mssql_query($query3) or die ("Couldn't Create New Entry into Database $myDB"); } Is this the change you told me to change? Or, am I having some other issues here in this revised code? I have just checked my database, and it is still giving me the same square. Could there be something else that I have missed? Thanks for your help. Alice ====================================================== Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington ajwei(a)indiana.edu ________________________________________ From: Zephaniah ha Levi [zleviticus(a)fitnessnow.org] Sent: Monday, June 30, 2008 1:41 PM To: Wei, Alice J.; php-windows(a)lists.php.net Subject: RE: [PHP-WIN] Remove End of Line Characters My guess is that the squares are line feed or carriage returns. Do a str_replace on \r and \n -----Original Message----- From: Wei, Alice J. [mailto:ajwei(a)indiana.edu] Sent: Monday, June 30, 2008 1:25 PM To: php-windows(a)lists.php.net Subject: [PHP-WIN] Remove End of Line Characters Hi, I have a simple file as follows: There are in the total of 513 words in sinus.txt, lung.txt and stomach.txt. 151 sinus.txt 105 lung.txt 257 stomach.txt What I want to do is to print the first line in the Description column, and have each of the following lines be entered into the database by assigning the number as $words, and the filename into the Filename column. The script in the following performs exactly the way I wanted, except for the fact that in my database, each of the entries looks something like this: sinus.txt followed by a square for each of the variables that contains text.. I don't have this problem for my numbers at all. for ($i=1; $i <= 3; $i++) { echo $i . ": " . $lines4[$i] . "\n"; list($words, $file) = explode(" ", $lines4[$i]); echo "File: $file has $words words\n\n"; substr($file, 0, -3); //substr($lines4['0'],0,-1); $query3="INSERT INTO youtoo(Description,Filename,Words) VALUES ('$lines4[0]','$file', '$words')"; $result1= mssql_query($query3) or die ("Couldn't Create New Entry into Database $myDB"); } I tried using rtrim(), chop() using the $line4 as I have declared and there is no use. Finally, I used substr(), but this does not seem to get what I wanted either, and the square is still in the way. I checked my text file in the text editor, and I see nothing that could have produced the square during the database entering process. Does anyone know what I have done wrong here? Anything is appreciated. Alice ====================================================== Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington ajwei(a)indiana.edu -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
From: "Jacob Kruger" on 30 Jun 2008 15:01 Are you using Jaws at all? Not sure of other screenreaders, but in Jaws if you have the cursor on that character, if you then hit the numpad 5 character 3 times quickly, it'll return the character code for that character and you could then try replace that character specifically as such? Not 100% sure it'll work, and in some versions, I'm not 100% sure Jaws was actually 'telling' you the correct character code, but Jaws 9 now seems fine/accurate enough. HTH Jacob Kruger Blind Biker Skype: BlindZA '...Fate had broken his body, but not his spirit...' ----- Original Message ----- From: "Wei, Alice J." <ajwei(a)indiana.edu> To: "Zephaniah ha Levi" <zleviticus(a)fitnessnow.org>; <php-windows(a)lists.php.net> Sent: Monday, June 30, 2008 8:46 PM Subject: RE: [PHP-WIN] Remove End of Line Characters Hi, for ($i=1; $i <= 3; $i++) { echo $i . ": " . $lines4[$i] . "\n"; list($words, $file) = explode(" ", $lines4[$i]); $carriage= array("\r\n", "\r", "\n"); str_replace($carriage, "", $lines4[$i]); echo "File: $file has $words words\n\n"; $query3="INSERT INTO youtoo(Description,Filename,Words) VALUES ('$lines4[0]','$file', '$words')"; $result1= mssql_query($query3) or die ("Couldn't Create New Entry into Database $myDB"); } Is this the change you told me to change? Or, am I having some other issues here in this revised code? I have just checked my database, and it is still giving me the same square. Could there be something else that I have missed? Thanks for your help. Alice ====================================================== Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington ajwei(a)indiana.edu ________________________________________ From: Zephaniah ha Levi [zleviticus(a)fitnessnow.org] Sent: Monday, June 30, 2008 1:41 PM To: Wei, Alice J.; php-windows(a)lists.php.net Subject: RE: [PHP-WIN] Remove End of Line Characters My guess is that the squares are line feed or carriage returns. Do a str_replace on \r and \n -----Original Message----- From: Wei, Alice J. [mailto:ajwei(a)indiana.edu] Sent: Monday, June 30, 2008 1:25 PM To: php-windows(a)lists.php.net Subject: [PHP-WIN] Remove End of Line Characters Hi, I have a simple file as follows: There are in the total of 513 words in sinus.txt, lung.txt and stomach.txt. 151 sinus.txt 105 lung.txt 257 stomach.txt What I want to do is to print the first line in the Description column, and have each of the following lines be entered into the database by assigning the number as $words, and the filename into the Filename column. The script in the following performs exactly the way I wanted, except for the fact that in my database, each of the entries looks something like this: sinus.txt followed by a square for each of the variables that contains text. I don't have this problem for my numbers at all. for ($i=1; $i <= 3; $i++) { echo $i . ": " . $lines4[$i] . "\n"; list($words, $file) = explode(" ", $lines4[$i]); echo "File: $file has $words words\n\n"; substr($file, 0, -3); //substr($lines4['0'],0,-1); $query3="INSERT INTO youtoo(Description,Filename,Words) VALUES ('$lines4[0]','$file', '$words')"; $result1= mssql_query($query3) or die ("Couldn't Create New Entry into Database $myDB"); } I tried using rtrim(), chop() using the $line4 as I have declared and there is no use. Finally, I used substr(), but this does not seem to get what I wanted either, and the square is still in the way. I checked my text file in the text editor, and I see nothing that could have produced the square during the database entering process. Does anyone know what I have done wrong here? Anything is appreciated. Alice ====================================================== Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington ajwei(a)indiana.edu -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
From: "M. Sokolewicz" on 1 Jul 2008 05:10
Wei, Alice J. wrote: > Hi, > > for ($i=1; $i <= 3; $i++) { > > echo $i . ": " . $lines4[$i] . "\n"; > list($words, $file) = explode(" ", $lines4[$i]); > $carriage= array("\r\n", "\r", "\n"); > str_replace($carriage, "", $lines4[$i]); > echo "File: $file has $words words\n\n"; > $query3="INSERT INTO youtoo(Description,Filename,Words) VALUES ('$lines4[0]','$file', '$words')"; > $result1= mssql_query($query3) or die ("Couldn't Create New Entry into Database $myDB"); > > } > > Is this the change you told me to change? Or, am I having some other issues here in this revised code? > I have just checked my database, and it is still giving me the same square. Could there be something else that I have missed? > > Thanks for your help. > > Alice You do realise that you're not assigning the result of the str_replace to anything, right? Thus, the entire statement is basically... useless (you're replacing all \r, \n, \r\n (this last one will never exist since all \r and \n, including \r\n have already been replaced) in a copy of $lines4[$i], and then never using that). Please, post a couple of lines from the files and what you want them to become (exactly). I'm a bit confused with just the "first line in the Description column, and have each of the following lines be entered into the database by assigning the number as $words, and the filename into the Filename column" without being able to see what you're talking about in the first place. - Tul |