03-01-2005
cut -f (or awk alternative)
I'm trying the following as i wish to get the last field in a report containing several fields, each line can have more fields than the previous, so I tried
rvwords=`echo $rvstatus |wc -w`
rvstat=`echo $rvstatus |cut -f $rvwords`
but it prints the whole variable contents of $rvstatus rather than just the seventh field, there are no delimeters (other than spaces / tabs) in the line, which would read along the lines of
0 1111 my file 102.00 1003.00 2.99
1 2222 my own file 111.00 112.98 200.10
...
Thanks in anticipation
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I'm trying to echo a variable that has values separated by colons, putting each value on a new line. So as an example, a variable I might have would contain:
My name is Earl:My name is Dorothy:My name is Bernard:
And I want the output:
My name is Earl
My name is Dorothy
My name... (5 Replies)
Discussion started by: michaeltravisuk
5 Replies
2. Shell Programming and Scripting
Hi, I'm very new to scripting.
grep $s $filename | awk '{print $2}' | cut -c 1-8
How can I optimize this using a single awk?
I tried:
awk '/$s/ {print $2}' $filename | cut -c 1-8
However didn't work, I think the awk is not recognizing $s and the verbal is something else. (6 Replies)
Discussion started by: firdousamir
6 Replies
3. Shell Programming and Scripting
select some fields from data file (source.csv)
The data in file(source.csv) is like
"x1,2",,"y",,"z"
How to get the 1st, 2nd and 3rd field from the file. Using awk or cut?
Note: "x1,2" is one field.
thanks, (16 Replies)
Discussion started by: anypager
16 Replies
4. Shell Programming and Scripting
i was trying to work on program to look for users never log on sever.. using awk
with awk is working
last| awk '{print $1}' |sort -u > /tmp/users1$$
cat /etc/passwd | awk -F: '{print $1}' |sort -u > /tmp/users2$$
comm -13 /tmp/users$$
rm -f /tmp/users$$
with cut it is not working
... (3 Replies)
Discussion started by: macrules
3 Replies
5. UNIX for Dummies Questions & Answers
Hi I'm new to unix programming so struggling with something thats probably simple to many of you
I have data files of the format :
ID, date, value1, value2, blank
on each line either value1 or value2 will be zero. I need my output file to contain
ID, date, non-zero value
The input... (3 Replies)
Discussion started by: thewench
3 Replies
6. Shell Programming and Scripting
how would i write a shell script to show the number of lines in which int variable appears in a c++ program.
how would i do this using cut or awk methods is it possbile and having a output similar to this
x, number of apperances =
y, number of apperances = (2 Replies)
Discussion started by: deadleg
2 Replies
7. Shell Programming and Scripting
I want to use awk instead of cut command.
Following is my code:
line="slNumber=US78AJF11643, slName=USJFKAAUSYDAAUL80441032900095, dummy sl found? sqlca.sqlcode=0"
sl_WORD=`echo $line| cut -f 1 -d','`
sl=`echo $sl_WORD | cut -f 2 -d'='`
echo "$sl"
Please suggest me about the code.
... (5 Replies)
Discussion started by: rinku
5 Replies
8. Shell Programming and Scripting
Hi,
I have a large number of input files with two columns of numbers.
For example:
83 1453
99 3255
99 8482
99 7372
83 175
I only wish to retain lines where the numbers fullfil two requirements. E.g:
=83
1000<=<=2000
To do this I use the following... (10 Replies)
Discussion started by: s052866
10 Replies
9. Shell Programming and Scripting
Example:
$ cat file1
2
3$ cat file2
1
2
3
4
5
6The following awk script works like a charm, NR==FNR is true for file1, the remainder runs for file2:
awk '
NR==FNR {A; next}
($1 in A)
' file1 file2
2
3Now have an empty file1:
>file1and run the awk script again.
The result is empty... (8 Replies)
Discussion started by: MadeInGermany
8 Replies
LEARN ABOUT PHP
mssql_fetch_field
MSSQL_FETCH_FIELD(3) MSSQL_FETCH_FIELD(3)
mssql_fetch_field - Get field information
SYNOPSIS
object mssql_fetch_field (resource $result, [int $field_offset = -1])
DESCRIPTION
mssql_fetch_field(3) can be used in order to obtain information about fields in a certain query result.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $field_offset
- The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is
retrieved. The $field_offset starts at 0.
RETURN VALUES
Returns an object containing field information.
The properties of the object are:
o name - column name. if the column is a result of a function, this property is set to computed#N, where #N is a serial number.
o column_source - the table from which the column was taken
o max_length - maximum length of the column
o numeric - 1 if the column is numeric
o type - the column type.
EXAMPLES
Example #1
mssql_fetch_field(3) example
<?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
$field = mssql_fetch_field($query, $i);
// Print the row
echo '<tr>';
echo '<td>' . $field->name . '</td>';
echo '<td>' . strtoupper($field->type) . '</td>';
echo '<td>' . $field->max_length . '</td>';
echo '</tr>';
}
echo '</tbody>';
echo '</table>';
// Free the query result
mssql_free_result($query);
?>
SEE ALSO
mssql_field_seek(3).
PHP Documentation Group MSSQL_FETCH_FIELD(3)