php-windows Digest 1 Jul 2008 09:10:10 -0000 Issue 3499
Topics (messages 28984 through 28987):
Re: Remove End of Line Characters
28984 by: Zephaniah ha Levi
28985 by: Wei, Alice J.
28986 by: Jacob Kruger
28987 by: M. Sokolewicz
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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:[EMAIL PROTECTED]
Sent: Monday, June 30, 2008 1:25 PM
To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
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
[EMAIL PROTECTED]
________________________________________
From: Zephaniah ha Levi [EMAIL PROTECTED]
Sent: Monday, June 30, 2008 1:41 PM
To: Wei, Alice J.; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
Sent: Monday, June 30, 2008 1:25 PM
To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
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." <[EMAIL PROTECTED]>
To: "Zephaniah ha Levi" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
________________________________________
From: Zephaniah ha Levi [EMAIL PROTECTED]
Sent: Monday, June 30, 2008 1:41 PM
To: Wei, Alice J.; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
Sent: Monday, June 30, 2008 1:25 PM
To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
--
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
--- End Message ---
--- Begin Message ---
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
--- End Message ---
