I've been reading about, and testing printf options for a while now, and am stuck on how to handle the above situation where one of the fields in a column is blank-whitespace. I tried using printf in the above code, specifically the following line using the first six fields only (i want to format the rest of the fields too, but for testing purposes only tried the first six to show my problem):
Code:
NR > 2 && (NR % 2 == 0 ) {printf "%-5s%-8s: %-10s: %-15s: %-10s: %-5s:\n",$1,$2,$3,$4,$5,$6} /^$/{NR=0}
I GET RETURNED:
FEB 20-98 : VLY : 1041 : 2094 : 8 :
JAN 7-98 : VLY : 1030 : 2064 : 6 :
MAR 9-98 : VLY : $500 : 1024 : 2060 :
MAR 13-98 : VLY : $1,350 : 1004 : 2022 :
MAR 27-98 : VLY : $675 : 1013 : 2020 :
MAY 1-98 : VLY : $1,500 : 0594 : 1594 :
MAY 9-98 : HILL : $2,000 : 0581 : 1570 :
MAY 15-98 : HILL : 1003 : 2011 : 7 :
MAY 21-98 : HILL : 0593 : 2010 : 7 :
FEB 22-98 : VLY : $675 : 1013 : 2020 :
APR 3-98 : VLY : $675 : 1001 : 2011 :
MAR 8-99 : VLY : $500 : 1024 : 2060 :
MAR 13-99 : VLY : $1,350 : 1004 : 2022 :
: : : : :
AUG 25-98 : RIDC : 1011 : 2011 : 9 :
Which messes up which columns go where. So, how can i handle formatting a field that is whitespace?
It should be:
Code:
FEB 20-98 : VLY : : 1041 : 2094 : 8 :
JAN 7-98 : VLY : : 1030 : 2064 : 6 :
MAR 9-98 : VLY : $500 : 1024 : 2060 :
MAR 13-98 : VLY : $1,350 : 1004 : 2022 :
MAR 27-98 : VLY : $675 : 1013 : 2020 :
MAY 1-98 : VLY : $1,500 : 0594 : 1594 :
MAY 9-98 : HILL : $2,000 : 0581 : 1570 :
MAY 15-98 : HILL : : 1003 : 2011 : 7 :
MAY 21-98 : HILL : : 0593 : 2010 : 7 :
FEB 22-98 : VLY : $675 : 1013 : 2020 :
APR 3-98 : VLY : $675 : 1001 : 2011 :
MAR 8-99 : VLY : $500 : 1024 : 2060 :
MAR 13-99 : VLY : $1,350 : 1004 : 2022 :
AUG 25-98 : RIDC : : 1011 : 2011 : 9 :
I have a set of files of multi-line records with the records separated by a blank line. I needed to add a record number to the front of each line followed by a colon and did the following:
awk 'BEGIN {FS = "\n"; RS = ""}{for (i=1; i<=NF; i++)print NR,":",$i}' ~/Desktop/data98-1-25.txt >... (3 Replies)
Hi Sorry to multipost. I am opening the new thread because the earlier threads head was misleading to my current doubt.
and i am stuck.
list=`cat /u/Test/programs`;
psg "ServTest" | awk -v listawk=$list '{
cmd_name=($5 ~ /^/)? $9:$8
for(pgmname in listawk)
... (6 Replies)
I have a file has following records
policy glb id 1233 name Permit ping from "One" to "Second" "Address1" "Any" "ICMP-ANY" permit
policy id 999251
service "snmp-udp"
exit
policy glb id 1234 name Permit telnet from "One" to "Second" "Address2" "Any" "TCP-ANY" permit
policy id 1234... (3 Replies)
Some records in a file look like this, with any number of lines between start and end flags:
/Start
Some stuff
Banana 1
Some more stuff
End/
/Start
Some stuff
End/
/Start
Some stuff
Some more stuff
Banana 2
End/
...how would I process this file to find records containing the... (8 Replies)
Hi all,
I So, I've got a monster text document comprising a list of various company names and associated info just in a long list one after another. I need to sort them alphabetically by name...
The text document looks like this:
Company Name:
the_first_company's_name_here
Address:... (2 Replies)
Now that I've parsed out the data that I desire I'm left with variable length multi-line records that are field seperated by new lines (\n) and record seperated by a single empty line ("")
At first I was considering doing something like this to append all of the record rows into a single row:
... (4 Replies)
I have a file with data records separated by multiple equals signs, as below.
==========
RECORD 1
==========
RECORD 2
DATA LINE
==========
RECORD 3
==========
RECORD 4
DATA LINE
==========
RECORD 5
DATA LINE
==========
I need to filter out all data from this file where the... (2 Replies)
Hey, not too good at this, so I only managed a clumsy and SLOW solution to my problem that needs a drastic speed up. Any ideas how I write the following in awk only?
Code is supposed to do...
For every line read column values $6, $7, $8 and do a calculation with the same column values of every... (6 Replies)
Greetings Experts,
As part of automating the sql generation, I have the source table name, target table name, join condition stored in a file join_conditions.txt which is a delimited file (I can edit the file if for any reason). The reason I needed to store is I have built SELECT list without... (5 Replies)
IMAGICKDRAW.LINE(3) 1 IMAGICKDRAW.LINE(3)ImagickDraw::line - Draws a line
SYNOPSIS
bool ImagickDraw::line (float $sx, float $sy, float $ex, float $ey)
DESCRIPTION
Warning
This function is currently not documented; only its argument list is available.
Draws a line on the image using the current stroke color, stroke opacity, and stroke width.
PARAMETERS
o $sx
- starting x coordinate
o $sy
- starting y coordinate
o $ex
- ending x coordinate
o $ey
- ending y coordinate
RETURN VALUES
No value is returned.
EXAMPLES
Example #1
ImagickDraw.line(3)
<?php
function line($strokeColor, $fillColor, $backgroundColor) {
$draw = new ImagickDraw();
$draw->setStrokeColor($strokeColor);
$draw->setFillColor($fillColor);
$draw->setStrokeWidth(2);
$draw->setFontSize(72);
$draw->line(125, 70, 100, 50);
$draw->line(350, 170, 100, 150);
$imagick = new Imagick();
$imagick->newImage(500, 500, $backgroundColor);
$imagick->setImageFormat("png");
$imagick->drawImage($draw);
header("Content-Type: image/png");
echo $imagick->getImageBlob();
}
?>
PHP Documentation Group IMAGICKDRAW.LINE(3)