Can we convert 3 awk statements in a single statement Post: 302958385

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to convert unix command into Awk statement

Hi all, How can i use the below unix command in AWK . Can any one please suggest me how i can use. sed -e "s/which first.sh/which \$0/g" $shell > $shell.sal where $0=current program name(say current.sh) $shell=second.sh

2. Shell Programming and Scripting

Using two shell variables in single AWK statement

meas is a shell variable, and this works perfectly fine for me: awk -v var=$meas -F, '$1==var' /abcd/efgh.txt > temp1.csv However, i want to introduce another shell variable, named, defnfile in the statement, in place of hardcoded path for efgh.txt like: awk -v var=$meas -F, '$1==var'...

3. Shell Programming and Scripting

single quotes in awk statement

Hi, I have written a code to modify a string say, StringA=abc,def,ghi I need to change it to something like: StringB=This means abc='ABC', This mean def='DEF', This means ghi= 'GHI' StringB=$(echo $StringA | awk -F',' 'BEGIN { OFS="," } { for (i=1; i<=NF;i++) $i="This means...

4. Shell Programming and Scripting

awk pattern match and search in single statement

Hi All, I am trying to alter all lines between EXEC SQL and END-EXEC that have an INCLUDE in them. The following code search="INCLUDE " cp -f ${WORK}/$file.in ${WORK}/$file.wrk2 for item in `echo $search `; do > ${WORK}/$file.wrk1 awk -vITEM="$item" '{ if ( $0...

5. Shell Programming and Scripting

Can we use two shebang statements in a single shell script?

Hi, As per my understanding, we can use two shebang statements in a single shell script. Please see below snippet- #!/bin/bash .......## some code A #!/bin/csh .......## some code B exit 0; Here, code A will be executed using bash shell and code B will be executed with c shell. ...

6. Shell Programming and Scripting

Search several string and convert into a single line for each search string using awk command AIX?.

I need to search the file using strings "Request Type" , " Request Method" , "Response Type" and by using result set find the xml tags and convert into a single line?. below are the scenarios. Cat test Nov 10, 2012 5:17:53 AM INFO: Request Type Line 1....

7. Shell Programming and Scripting

Convert to case statements from if/elif

Hello, I wrote the case on code but it mistakes. I am not sure. If/elif code: #!/bin/ksh you=$LOGNAME hour=`date | awk '{print substr($4, 1, 2)}'` print "The time is: $(date)" if (( hour > 0 && $hour < 12 )) then print "Good morning, $you!" elif (( hour == 12 )) then

8. Shell Programming and Scripting

Curl statement throwing extra statements

Hi all, I am running a curl statement in my script to extract some information form a remote server. My curl statement is : curl --socks5 142.133.134.164:1082 'http://11.229.52.71:8011/WebApp/common/version' This gives me an output of : $ curl --socks5 142.133.134.164:1082...

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

10. Shell Programming and Scripting

Single quotes insert statement using awk

Hi, Need help, using awk command to insert statement awk -v q="'" '{ print "db2 connect to repolab > /dev/null; " "\n" "db2 -x \" select name from IBMPDQ.PROFILE where managed_database = " q $1"_"$3"__0" q "\"" } ' profile.txt | sh - | awk -v i="'" ' { print "db2 connect to repolab >...

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

How to convert unix command into Awk statement

Discussion started by: krishna_gnv

2. Shell Programming and Scripting

Using two shell variables in single AWK statement

Discussion started by: indianjassi

3. Shell Programming and Scripting

single quotes in awk statement

Discussion started by: tostay2003

4. Shell Programming and Scripting

awk pattern match and search in single statement

Discussion started by: Bruble