Do it in a small steps. Test input/output and learn incremental:
1. Find all your chunks and learn their structure:
2. It looks like you want process lines with only 3 fields, pipe the output to the next awk:
Maybe it's not enough and you want something like
or
3. You should get the even(!) number of lines. You can check it piping to "wc -l"
4. You can squeeze your lines with:
5. And cut them with
6. And then you can format your numbers with printf:
The final result:
And one more time - you can change, tune, test every your step separately.
I'm trying to compare the first column values in two different files that use a numerical value as the key and output the more meaningful value found in the second column of file1 in front of the matching line(s) in file2. My problem is that file2 has multiple records. For example given:
FILE1... (4 Replies)
I'm trying to use Awk to get the id and name fields ($1 and $2) of file1 combined with their corresponding multiline records in file2 that are separated by blank line. Both files are ordered so that the first line of file1 corresponds to the first set of multiline records in file2 and so on.
... (4 Replies)
Hi,
I have a file of the following from:
Afghanistan
gdpcapit|800
Akrotiri
Albania
gdpcapit|6000
now I want have the gdpcapit value next to the country when there is one like this:
Afghanistan 800
gdpcapit|800
Akrotiri
Albania 6000
gdpcapit|6000
How do I do this? I've... (4 Replies)
Dear Team,
How do we match two patterns on the same line using awk?Are there any logical operators which i could use in awk like awk '\gokul && chennai\' <filename>
Eg:
Input file:
gokul,10/11/1986,coimbatore.
gokul,10/11/1986,bangalore.
gokul,12/04/2008,chennai.... (2 Replies)
Hello!
i wanna match in a config file, one text with more than one lines, something like this:
CACHE_SIZE{
10000 M
}
I have problems with the ends of line, i think that i can match the end of the line with \n, but i can't get it
Someone can help me with the regular expression?
... (18 Replies)
Hi friends,
Could you please help me to resolve the below issue.
Input file :-
<Node>
<username>abc</username>
<password>ABC</password>
<Node>
<Node>
<username>xyz</username>
<password>XYZ</password>
<Node>
<Node>
<username>mnp</username>
... (3 Replies)
am trying to grab the fields marked in red for monitoring purposes. each vfiler can have anywhere from 0-50 Path(s).
in order to get here i run the following
for filer in `cat filers.list` ; do ssh $filer vfiler status | awk '{print $1}' ; done
this returns
vfiler0
vfilert
vfiler2
... (2 Replies)
In a LaTeX manuscript, I need to replace many occurrences of
\emph{some string}
with some string, i.e. whatever string is inside. The string inside often may extend over several lines, and there may be other occurences of curly brackets inside it. So for example
\emph{this \it{is} a... (5 Replies)
Using the awk below I am able to combine all the matching dates in $1, but I can not seem to remove the non-matching from the file. Thank you :).
file
20161109104500.0+0000,x,5631
20161109104500.0+0000,y,2
20161109104500.0+0000,z,2
20161109104500.0+0000,a,4117... (3 Replies)