Help with finding a string and printing value in the next column Post: 302380059

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Printing highest value from one column

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

2. UNIX for Dummies Questions & Answers

creating a file using the fist column and printing second column

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...

3. Shell Programming and Scripting

Help finding a field value then printing line

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...

4. Shell Programming and Scripting

grep on string and printing line after until another string has been found

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...

5. UNIX for Dummies Questions & Answers

Printing a particular column using SED

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...

6. Shell Programming and Scripting

Reformatting single column text file starting new line when finding particular string

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. Shell Programming and Scripting

Printing second column of several files into one

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...

8. UNIX for Dummies Questions & Answers

Printing out lines that have the same value in the first column but different value in the second

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...

9. Shell Programming and Scripting

Inconsistent column printing

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...

10. Shell Programming and Scripting

Printing most frequent string in column

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...

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)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Printing highest value from one column

Discussion started by: phil_heath

2. UNIX for Dummies Questions & Answers

creating a file using the fist column and printing second column

Discussion started by: viralnerd

3. Shell Programming and Scripting

Help finding a field value then printing line

Discussion started by: Grueben

4. Shell Programming and Scripting

grep on string and printing line after until another string has been found

Discussion started by: rxc23816