OK, so I am trying to use awk as a method of accessing a table stored in a file to then provide the capability of a look up table.
The table is stored in a file named "/Users/jhaney/Desktop/assetTypeMapping.tsv" and looks like this:
The file is tab delimited because there is all likelihood that some of the fields will contain space characters and records are separated by UNIX new line characters.
-----------------------
proof of concept:
This script works great and does exactly what I want it to do.
-----------------------
The problem:
As aforementioned, I would like the freedom of allowing space characters in the data table. However, awk considers spaces to be field separators.
I have seen examples of how to set the field separator:
But I just can't figure out how to combine the two ideas together.
I tried:
But I keep getting awk syntax errors no matter how I combine the args.
So, basically, I want to search the first field of each line for "lookupVal" and, when found, return the second (or third, or fourth) field in that record.
Can anyone set me straight?
Last edited by Scott; 05-29-2015 at 03:16 PM..
Reason: Please use code tags
Hi,
# grep "^Listen" httpd.conf | awk '{print $2}'
FrontEnd_1_IP:8081
FrontEnd_2_IP:8081
8081
8082
8083
#
I need to get the values one at a time but I just can't manage to do that.
Thanks,
Bianca (20 Replies)
In the following code, Im trying to imbed many statements in a single awk statement. But it gives an error on that,
for i in `less usage_types_dwh.txt`
do
cd /u01/app/evident/analysis_lab/usg_type
grep $i svc_type.txt | head -1 | awk 'BEGIN {FS=","} {print $1 "==" $2 ":" $3 ":" $4;... (2 Replies)
I have this input file
0FB7,1083,Synchronized,FriNov121655,2816_7RAID5,05F:1_10F:1,10000000NoneNone,DC_db00p01
0FB7,1150,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A
06C4,0710,Synchronized,WedMar91105,2816_7RAID5,04E:1_11E:1,10000000NoneNone,DL_nb00p25... (1 Reply)
Hi guys,
i am trying to analyze a text file using awk and am not able to solve this issue.
This is the piece of code that I have written
BEGIN {
## Time to count MACs -> 5 seconds.
TIME_LIMIT = 5;
k = 50000;
}
## For every line.
{
time_in_seconds = $1... (2 Replies)
Hi Gurus,
I am facing a similar issue usiung an awk command. Below is my requirement:
---DATA---
A;F;G
A;D;E
A;D;E
B;Z;P
C;Z;Q
Expected:
A
F<TAB>G
D<TAB>E
D<TAB>E
B
D<TAB>E (1 Reply)
Hi all,
i am trying to use below command to see the output of hardware inventory, but i only see 2 first line no output of the command.
awk '/Hardware/ {print $0}' XXX_result.txt
Hardware inventory:
Hardware inventory:
any idea how to see whatever is under hardware inventory.
i... (11 Replies)
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
On AIX 5.3 and AIX 6.1, I have this script for checking printers being pingable or not.
for i in `lsallq`
do
echo "Queue Name: " $i
echo "----------------------------------------"
for j in `lsallqdev -q $i`
do
echo " Device Name:" $j
hname=`echo... (3 Replies)
Discussion started by: Daniel Gate
3 Replies
LEARN ABOUT SUSE
igawk
IGAWK(1) Utility Commands IGAWK(1)NAME
igawk - gawk with include files
SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ...
igawk [ all gawk options ] [ -- ] program-text file ...
DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).
AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like
@include getopt.awk
in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.
OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports.
EXAMPLES
cat << EOF > test.awk
@include getopt.awk
BEGIN {
while (getopt(ARGC, ARGV, "am:q") != -1)
...
}
EOF
igawk -f test.awk
SEE ALSO gawk(1)
Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.
AUTHOR
Arnold Robbins (arnold@skeeve.com).
Free Software Foundation Nov 3 1999 IGAWK(1)