I am facing as issue in substituting the variable here.
I am assigning value to a variable as given
=> format will have {printf "Error in field 1 or 3|"$0"\n"}
Now i want to echo it (format variable) as it is in script meaning i dont want $0 value to be substituted.
How can i achieve this??
How do I alias the FILE name into awk?
gawk -f awk_script FILE
or
FILE | gawk awk_script
for FILE in `find ./* -prune -type f -newer ./TIMEFILE`
do
# Need to have the actual FILE name ran thru an awk script
done (1 Reply)
I am new to UNIX and I need a sample awk or sed program to solve the following problem.
I have a file with the following format. The file is comma delimited. Each record has header information followed by looping detailed information. In addition the detailed information will vary based on a... (2 Replies)
Hi
can anyone pls help me out in knowing how a array of elements which are fetched from database is passed to the awk program.
Something like this
#!/bin/sh
AMT=`sqlplus -s usrname/pswd <<EOD
set pagesize 0 feedback off verify off heading off echo on
select amount from... (11 Replies)
Hey everyone! Can someone help me, i need to make a program using awk, that displays the current time (hh/mm/ss), i would really apreciate it! Thanks!
Alex. (4 Replies)
Hi,
I am working on a script where i am fetching a word from a parameter file and using it as output file name .
here is the part of parameter file contents : it basically contains SQL statements.
Select 'SSFNRTP' as TABLE_NAME,UCSTDT,CVOFIDKEY from (Select 'cofvof_interface' as... (2 Replies)
Write a script to calculate the average score and assign a letter grade for each student, also compute the average score for every test (the source data is in the file “grades”). Output all students' name, scores, and grades in descending order of the average score. Note: please save the output to... (17 Replies)
Hi, I am new to unix shell script and I have some trouble on the awk sub
I would like to pick the Date "July 10 2012" into $corr_date by using sub() function, but it is not successful.
The inputted text file:
pic.*.txt
July 10 2012 20:30:50 , 1234567.jpg
July 10 2012 20:30:52 , 5648978.jpg... (1 Reply)
Hello Everyone,
May I ask for your help regarding one of the UNIX command “awk”. So I executed a script and the output looks like this (see below):
output.txt
CONTRACTNAME ... (3 Replies)
MSSQL_FIELD_SEEK(3)MSSQL_FIELD_SEEK(3)mssql_field_seek - Seeks to the specified field offsetSYNOPSIS
bool mssql_field_seek (resource $result, int $field_offset)
DESCRIPTION
Seeks to the specified field offset. If the next call to mssql_fetch_field(3) won't include a field offset, this field would be returned.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $field_offset
- The field offset, starts at 0.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Using mssql_field_seek(3) on the example for mssql_fetch_field(3)
<?php
// Connect to MSSQL and select the database
mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');
// Send a select query to MSSQL
$query = mssql_query('SELECT * FROM [php].[dbo].[persons]');
// Construct table
echo '<h3>Table structure for 'persons'</h3>';
echo '<table border="1">';
// Table header
echo '<thead>';
echo '<tr>';
echo '<td>Field name</td>';
echo '<td>Data type</td>';
echo '<td>Max length</td>';
echo '</tr>';
echo '</thead>';
// Dump all fields
echo '<tbody>';
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
// Fetch the field information, notice the
// field_offset parameter is not set. See
// the mssql_field_seek call below
$field = mssql_fetch_field($query);
// Print the row
echo '<tr>';
echo '<td>' . $field->name . '</td>';
echo '<td>' . strtoupper($field->type) . '</td>';
echo '<td>' . $field->max_length . '</td>';
echo '</tr>';
// Move the internal seek pointer to the next
// row in the result set
mssql_field_seek($query, $i + 1);
}
echo '</tbody>';
echo '</table>';
// Free the query result
mssql_free_result($query);
?>
SEE ALSO mssql_fetch_field(3).
PHP Documentation Group MSSQL_FIELD_SEEK(3)