Why does this awk statement work? Post: 302500445

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

my case statement doesn't work..

CO UNixware 7.1.1 Hi friends, I have chopped my case statementt out of my .profile and put it in another script called setsid. The case statement works when run from my .profile but not from my setsid file. All that the script does is set an environmental variable based on user input....

2. Shell Programming and Scripting

i can't get my if statement to work, please help

I can't get this IF to work... I need to verify user input with the proper format and only options that could have been entered. shell using is sh (Solaris 8) thank you. code: -------------------------------------------- procMonth=$1 correctValues="01 02 03 04 05 06 07 08 09 10...

3. UNIX for Dummies Questions & Answers

Ksh Why Won't IF Statement work?

I'm trying to figure out why this if statement won't work: if || $zipcount != 6 ]] then echo ${myline} echo "ZIPCODE WARNING! ${zipcode} ${zipcount}" fi if ]] then echo ${myline} echo "STATE WARNING!...

4. Shell Programming and Scripting

awk: assign variable with -v didn't work in awk filter

I want to filter 2nd column = 2 using awk $ cat t 1 2 2 4 $ VAR=2 #variable worked in print $ cat t | awk -v ID=$VAR ' { print ID}' 2 2 # but variable didn't work in awk filter $ cat t | awk -v ID=$VAR '$2~/ID/ { print $0}'

5. Shell Programming and Scripting

awk inside another awk statement

hi all, i have two files 1) a.txt one two three 2) abc "one" = 10 pqr "three" = 20 345 "two" = 0 this is what i want in third file

6. Shell Programming and Scripting

Parse file using awk and work in awk output

hi guys, i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 this the file raw format: Number of...

7. UNIX for Dummies Questions & Answers

SQL statement is not work on unix script

Hi, I have the following basic script. However, the statement (line 5) is not work. The output data is not able to set my request format a30. Any advise? :mad: echo " Column filename format a30"|sqlplus4 echo Input file list to check: read filelist for file in `cat $filelist.txt` do...

8. Shell Programming and Scripting

My if statement doesn't work why?

I have the following and for some reason I can't have two options together. I mean if I choose -u and -p it won't work... why? #!/bin/bash resetTime=1 mytotalTime=0 totalHour=0 totalMin=0 averagemem=0 finalaverage=0 times=0 function usage() { cat << EOF USAGE: $0 file EOF }

9. Shell Programming and Scripting

How come this if statement doesn't work?

greetings, the following code isn't working as i expect it to. the first dbl brackets do but the second set gets ignored. ie: if i'm on t70c6n229 it echoes "Something" and i expect it not to. what am i missing? if " ]] || " ]]; then echo "Something" fi thanx!

10. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE...

LEARN ABOUT PHP

odbc_result

ODBC_RESULT(3)								 1							    ODBC_RESULT(3)

odbc_result - Get result data

SYNOPSIS

       mixed odbc_result (resource  $result_id, mixed  $field)

DESCRIPTION

	Get result data

PARAMETERS

	      o $result_id
		- The ODBC resource.

	      o $field
		-  The	field name being retrieved. It can either be an integer containing the column number of the field you want; or it can be a
		string containing the name of the field.

RETURN VALUES

	Returns the string contents of the field, FALSE on error, NULL for NULL data, or TRUE for binary data.

EXAMPLES

	The first call to odbc_result(3) returns the value of the third field in the current record of the query result. The second function  call
       to  odbc_result(3) returns the value of the field whose field name is "val" in the current record of the query result. An error occurs if a
       column number parameter for a field is less than one or exceeds the number of columns (or fields) in  the  current  record.  Similarly,	an
       error occurs if a field with a name that is not one of the fieldnames of the table(s) that is(are) being queried.

       Example #1

	      odbc_result(3) examples

	      <?php
	      $item_3	= odbc_result($Query_ID, 3);
	      $item_val = odbc_result($Query_ID, "val");
	      ?>

NOTES

	Field indices start from 1. Regarding the way binary or long column data is returned refer to odbc_binmode(3) and odbc_longreadlen(3).

PHP Documentation Group 													    ODBC_RESULT(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

my case statement doesn't work..

Discussion started by: sureshy

2. Shell Programming and Scripting

i can't get my if statement to work, please help

Discussion started by: MrJaunty

3. UNIX for Dummies Questions & Answers

Ksh Why Won't IF Statement work?

Discussion started by: developncode

4. Shell Programming and Scripting

awk: assign variable with -v didn't work in awk filter

Discussion started by: honglus