x y
x y
x y
x y
x y
0 3836
30 3915
60 5984
90 7388
...
That's why the code I posted read the first line from the file and, in its place, printed one instance of "x y".
i think you didn't observed this....
Quote:
Originally Posted by tintin72
Thanks guys!
The solutions by Krabu and Vidyadhar85 worked nicely. The x and y I put in for clarity, the original datafile contains only numbers. your solutions works for either case.
The solution by cfaJohnson...I couldn't get to work. It just hangs waiting for an input from me. Please could you rewrite it assuming that the letters x , y do not exist in the inputfile and that I would like the output piped to an "outputfile"? thanks.
Dear unix gurus,
I have a data file with header information about a subject and also 3 columns of n rows of data on various items he owns. The data file looks something like this:
adam peter
blah blah blah
blah blah blah
car
01 30 200
02 31 400
03 57 121
.. .. ..
.. .. ..
n y... (8 Replies)
Hi all,
I want to read some specific rows & columns in the .xls file with my script to get the data to be manipulated. Now, I can read the .xls file correctly & i can go to the specific sheet that I want but i have a problem to specify the specific rows & columns. I mean, I want to get the info... (0 Replies)
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Hi, I am trying to selectively merge two files based on keys reported in the 1st column.
File1:
#file1-header1
file1-header2
111 qwe rtz uio
198 asd fgh jkl
165 yxc
789 poi uzt rew
89 lkj
File2:
#file2-header2
file2-header2
165 ghz nko2 ... (2 Replies)
trying to sort an array, only the 4th column is uniq,
have this:
dog cat bird house1
dog cat bird house2
dog cat bird house3
rose daisy tulip house1
rose daisy tulip house3
would like this:
dog cat bird house1 house2 house3
rose daisy tulip house1 missing house3
any help... (6 Replies)
Discussion started by: jimmyf
6 Replies
LEARN ABOUT PHP
db2_escape_string
DB2_ESCAPE_STRING(3) 1 DB2_ESCAPE_STRING(3)db2_escape_string - Used to escape certain charactersSYNOPSIS
string db2_escape_string (string $string_literal)
DESCRIPTION
Prepends backslashes to special characters in the string argument.
PARAMETERS
o $string_literal
- The string that contains special characters that need to be modified. Characters that are prepended with a backslash are x00,
,
, , ', " and x1a.
RETURN VALUES
Returns $string_literal with the special characters noted above prepended with backslashes.
EXAMPLES
Example #1
A db2_escape_string(3) example
Result of using the db2_escape_string(3) function
<?php
$conn = db2_connect($database, $user, $password);
if ($conn) {
$str[0] = "All characters: x00 ,
,
, , ' , " , x1a .";
$str[1] = "Backslash (). Single quote ('). Double quote (")";
$str[2] = "The NULL character must be quoted as well";
$str[3] = "Intersting characters: x1a , x00 .";
$str[4] = "Nothing to quote";
$str[5] = 200676;
$str[6] = "";
foreach( $str as $string ) {
echo "db2_escape_string: " . db2_escape_string($string). "
";
}
}
?>
The above example will output:
db2_escape_string: All characters: ,
,
, \ , ' , " , .
db2_escape_string: Backslash (\). Single quote ('). Double quote (")
db2_escape_string: The NULL character must be quoted as well
db2_escape_string: Intersting characters: , .
db2_escape_string: Nothing to quote
db2_escape_string: 200676
db2_escape_string:
SEE ALSO db2_prepare(3).
PHP Documentation Group DB2_ESCAPE_STRING(3)