11-06-2013
@RavinderSingh13
Not to very much help, since format of column are lost.
information should be just below data
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello Experts,
I am back, with another doubt. I am not sure what it relates to this time - awk or the print command actually. I'll explain the scenario:
I have a huge file, and it has some traces(logs). In between those logs, there are statements with some SQL queries. All I want to do is... (4 Replies)
Discussion started by: hkansal
4 Replies
2. UNIX for Dummies Questions & Answers
Hi Friends,
Scripting newb here. So I'm trying to create a geektool script that uses awk and printf to output certain fields from top (namely command, cpu%, rsize, pid and time, in that order).
Here's the input from the top process that I'm putting into awk:
PID COMMAND %CPU ... (3 Replies)
Discussion started by: thom.mattson
3 Replies
3. Shell Programming and Scripting
Hi
I need to check if field separator I am using in awk statement is " : ", for example:
TIME=12:59
HOUR=`echo "$TIME" | awk '{FS=":"; print $1}'`
MINUTES=`echo "$TIME" | awk '{FS=":"; print $2}'`
Is there a way to check within the above awk statement ?
Thanks for help -A (2 Replies)
Discussion started by: aoussenko
2 Replies
4. Shell Programming and Scripting
Hi;
i have a file and i want to get;
- If the last word in line 14 is NOT equal to "Set."; then print 2nd, 3rd, 4th and 5th values of 3rd line.
and my code is:
nawk 'NR==14 {if ($NF!="Set.") (NR==3{print $2,$3,$4,$5}) }' file.txt
but no result?? :confused::(:confused::( (4 Replies)
Discussion started by: gc_sw
4 Replies
5. Shell Programming and Scripting
Hi, all
I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes.
sample input:
for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies
6. Shell Programming and Scripting
I am using this code to insert something into a csv file:
awk -F";" -v url=$url -v nr=$nr 'NR==nr{$2=url$2}1' file
Why do I get the output
field1 field2
instead of
field1;field2
I have given -F";", so the field separator should surely be ";". (1 Reply)
Discussion started by: locoroco
1 Replies
7. UNIX for Dummies Questions & Answers
In awk, how do I print all fields with a specified output field separator?
I have tried the following, which does not print the output FS:
echo a b c d | awk 'BEGIN{OFS = ";"}{print $0}' (3 Replies)
Discussion started by: locoroco
3 Replies
8. Shell Programming and Scripting
I need to set awk field separator to ";", but I need to avoid ";EXT".
so that
echo a;b;c;EXTd;e;f | awk -F";" '{print $3}'
would give "c;EXTd" (2 Replies)
Discussion started by: locoroco
2 Replies
9. Shell Programming and Scripting
Hi Experts ,
file :
- How to construct the awk filed separator so that $1, $2 $3 , can be assigned to the each "" range.
I am trying : awk -F"]" '{print $1}'
but it is printing the entire file. Not first field.
The desired output needed for first field... (9 Replies)
Discussion started by: rveri
9 Replies
10. UNIX for Beginners Questions & Answers
Hi, can some some help to get me the right results,
I have few text files, need to grep few columns from each file and get the results in one row with comma separated.
my code is
#folder=/nz/kit/log/backupsvr
folder=/export/home/nz/valai/tmpfiles/
echo $folder
for entry in `ls... (4 Replies)
Discussion started by: ValaiG
4 Replies
LEARN ABOUT SUSE
funcolumnlookup
funcolumnlookup(3) SAORD Documentation funcolumnlookup(3)
NAME
FunColumnLookup - lookup a Funtools column
SYNOPSIS
#include <funtools.h>
int FunColumnLookup(Fun fun, char *s, int which,
char **name, int *type, int *mode,
int *offset, int *n, int *width)
DESCRIPTION
The FunColumnLookup() routine returns information about a named (or indexed) column. The first argument is the Fun handle associated with
this set of columns. The second argument is the name of the column to look up. If the name argument is NULL, the argument that follows is
the zero-based index into the column array of the column for which information should be returned. The next argument is a pointer to a
char *, which will contain the name of the column. The arguments that follow are the addresses of int values into which the following
information will be returned:
o type: data type of column:
o A: ASCII characters
o B: unsigned 8-bit char
o I: signed 16-bit int
o U: unsigned 16-bit int (not standard FITS)
o J: signed 32-bit int
o V: unsigned 32-bit int (not standard FITS)
o E: 32-bit float
o D: 64-bit float
o mode: bit flag status of column, including:
o COL_ACTIVE 1 is column activated?
o COL_IBUF 2 is column in the raw input data?
o COL_PTR 4 is column a pointer to an array?
o COL_READ 010 is read mode selected?
o COL_WRITE 020 is write mode selected?
o COL_REPLACEME 040 is this column being replaced by user data?
o offset: byte offset in struct
o n: number of elements (i.e. size of vector) in this column
o width: size in bytes of this column
If the named column exists, the routine returns a positive integer, otherwise zero is returned. (The positive integer is the index+1 into
the column array where this column was located.)
If NULL is passed as the return address of one (or more) of these values, no data is passed back for that information. For example:
if( !FunColumnLookup(fun, "phas", 0, NULL NULL, NULL, NULL, &npha, NULL) )
gerror(stderr, "can't find phas column
");
only returns information about the size of the phas vector.
SEE ALSO
See funtools(7) for a list of Funtools help pages
version 1.4.2 January 2, 2008 funcolumnlookup(3)