12-14-2009
Much appreciated everyone!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a file that looks like this:
s6 98
s6 91
s6 56
s5 32
s5 10
s5 4
So what I want to do is print only the highest value for each value in the column:
So the file will look like this:
s6 98
s5 32
Thanks (4 Replies)
Discussion started by: phil_heath
4 Replies
2. UNIX for Dummies Questions & Answers
Hello all. I have a problem that I need help solving.
I would like to convert the following file:
human pool1_12 10e-02 45 67
human pool1_1899 10e-01 45 29
human pool1_1829 10e-01 43 26
horse pool1_343 10e-20 65 191
horse pool1_454 10e-09 44 43... (5 Replies)
Discussion started by: viralnerd
5 Replies
3. Shell Programming and Scripting
Hello,
I'm trying to only print out the file systems that are greater than 90% full.
So far I've got:
df -k >sawky8
cat sawky8 | grep -v Filesystem | sed "s/%//g;" >sawky9
cat sawky9 | awk '{print $4}' | read stot
print $stot
if ;then
echo $LINE
Problem is it stops after the first... (2 Replies)
Discussion started by: Grueben
2 Replies
4. Shell Programming and Scripting
Hello Everyone,
I just started scripting this week. I have no background in programming or scripting.
I'm working on a script to grep for a variable in a log file
Heres what the log file looks like. The x's are all random clutter
xxxxxxxxxxxxxxxxxxxxx START: xxxxxxxxxxxx... (7 Replies)
Discussion started by: rxc23816
7 Replies
5. UNIX for Dummies Questions & Answers
Hi,
i want to display only the particular column using SED command.
For example,
ps -ef|grep ash |sed -n '1p'|cut -d ' ' -f2
this gives 29067
ps -ef|grep ash |sed -n '1p'|awk '{print $2}'
this also gives the same
in the same way i need the solution using sed.
Please... (4 Replies)
Discussion started by: pandeesh
4 Replies
6. Shell Programming and Scripting
Hi, I have a single colum file and I need to reformat the file so that it creates a new line every time it come to an IP address and the following lines are corresponding rows until it comes to the next IP address.
I want to turn this
172.xx.xx.xx
gwpusprdrp02_pv
seinwnprd03... (7 Replies)
Discussion started by: kieranfoley
7 Replies
7. Shell Programming and Scripting
HI All,
I have exactly 100 text files with extension .txt. The files contain numbers like this:
1.txt
0.4599994 65914
0.40706193 190743
0.39977244 185019
0.39831382 74906
0.3915928 122428
0.38844505 39999
0.38820446 72691
0.38787442 176430
0.38670844 28791
0.38597047 91091... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a text file that looks like the following:
ILMN_1343291 6 74341083 74341772
ILMN_1343291 6 74341195 74341099
ILMN_1343295 12 6387581 6387650
ILMN_1651209 1 1657001 1657050
ILMN_1651209 5 83524260 83524309
I... (1 Reply)
Discussion started by: evelibertine
1 Replies
9. Shell Programming and Scripting
Hi,
I have a file that has inconsistently numbered columns.
Like row1 has 23 columns, and row 2 has 34 columns etc.
I would like to re-order the first 8 columns as required and from the 9th column till the end, I would like to print it as it is.
I tried to read the re-ordered 8 columns... (7 Replies)
Discussion started by: jacobs.smith
7 Replies
10. Shell Programming and Scripting
I am trying to put together an script that will output the most frequent string in a column. This is what I have:
awk '{count++} END {for ( i in count ) print i, count }'
Of course, my script is outputting all different strings and counts. However, I just need the most frequent one (there... (7 Replies)
Discussion started by: Xterra
7 Replies
LEARN ABOUT PHP
odbc_specialcolumns
ODBC_SPECIALCOLUMNS(3) 1 ODBC_SPECIALCOLUMNS(3)
odbc_specialcolumns - Retrieves special columns
SYNOPSIS
resource odbc_specialcolumns (resource $connection_id, int $type, string $qualifier, string $owner, string $table, int $scope, int
$nullable)
DESCRIPTION
Retrieves either the optimal set of columns that uniquely identifies a row in the table, or columns that are automatically updated when
any value in the row is updated by a transaction.
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $type
- When the type argument is SQL_BEST_ROWID, odbc_specialcolumns(3) returns the column or columns that uniquely identify each row
in the table. When the type argument is SQL_ROWVER, odbc_specialcolumns(3) returns the column or columns in the specified table,
if any, that are automatically updated by the data source when any value in the row is updated by any transaction.
o $qualifier
- The qualifier.
o $owner
- The owner.
o $table
- The table.
o $scope
- The scope, which orders the result set.
o $nullable
- The nullable option.
RETURN VALUES
Returns an ODBC result identifier or FALSE on failure.
The result set has the following columns:
oSCOPE
oCOLUMN_NAME
oDATA_TYPE
oTYPE_NAME
oPRECISION
oLENGTH
oSCALE
oPSEUDO_COLUMN
PHP Documentation Group ODBC_SPECIALCOLUMNS(3)