It should work if you use {print $2} instead of {print} (print only field 2 instead of whole line), but there will be a leading space.
If you don't want the preceding space, try this: {sub(/^ /,"",$2); print $2} it means remove a single preceding space from the field 2 + print field 2. In fact it means substitute the preceding space with nothing ("").
If just the values associated with the keywords were wanted (instead of keyword and value), it would be simpler to use the default awk field delimiters and look for the keywords with the colons added:
or:
or if there might be lines where there is no whitespace or could be multiple whitespace characters after the colon, you could use:
or:
Last edited by Don Cragun; 12-11-2014 at 06:28 AM..
Reason: Remove extraneous }' from middle two awk commands.
This User Gave Thanks to Don Cragun For This Post:
I would like to write a shell script that will parse through a file similar to the sample below. The data in the file is redirected from rsync into a log file. I would like to call a shell script to parse through and pick out the number beside the percent sign inside the parentheses in the last... (5 Replies)
I have a rather large file with XML-style content. Each line contains one full XML entry. For example:
1:<Message><DNIS>1234</DNIS><UCID>3456</UCID><TransferGroup>XYZXYZ</TransferGroup></Message>
2:<Message><DNIS>9999</DNIS><UCID>2584</UCID><TransferGroup>ABCABC</TransferGroup></Message>... (1 Reply)
Hi,
I need to extract values from a CSV file based on some conditions as explained below:
File format details:
1. each set starts with AAA only
2. number of columns is fixed
3. number of rows per set may vary (as they are having different CCC rows)
Now, i need to extract 3rd column of... (3 Replies)
Hi Friends,
I have a file with the following values..
xyz.txt,12345.xml
abc.txt,04567.xml
cde.txt,12134.xml
I would like to extract all the 2nd column values twice as shown in the example like
12345,12345.xml
04567,04567.xml
12134,12134.xml
Please advice!!
In the formus one of... (7 Replies)
I am parsing a log with key values spread all over in the following fashion:
TEST 1 SCHEME 12 SET EMPTY
VARLEN SET TEST 1201 PARAM1 EMTY PARAM2 SET
SCHEME 12 REFRESH TEST 8
I need to extract test number, my result should be
1
1201
8
I use awk for processing this log and use... (4 Replies)
Hi,
I would like to search based of "java" and "-Dplatform.home=" and store these two values in bash variables.
ps -xef | grep <pid>
wlsuser 15160 15144 0 Feb 20 ? 17:27 /app1/jdk150_07/bin/IA64N/java -server -Xms1536m -Dplatform.home=/app1/bea/weblogic92... (13 Replies)
hi
I have a line as given below. I need to match "COLUMN_NAME" and get the every third value ie words in between quotes completely (' ')
Sample Input -
COLUMN_NAME Like '%value%' Or COLUMN_NAME Like '%value%' Or COLUMN_NAME Like '%value value%' Or COLUMN_NAME Like '%value%' OR... (5 Replies)
hello all,
I need your help in extracting values of some parameter within a line using awk.
for example:
i have the below line available in a file and i want to extract the values of only CustomerId, s_PackageId and s_HZINumbers in order the result to be as
... (13 Replies)