When you can't show us correct spacing in your sample data when you are grabbing characters based on where those characters appear in a line, it is hard to help you.
When you pick 30 characters starting at offset 13 in a field that contains 2 characters (as in your 1st script), you aren't going to get much. When you only set value when an input line only contains the two characters BT and you don't have any lines that only contain those two characters (as in your 2nd script), you aren't going to get much either.
Is there some reason why you can't just use:
Code:
awk '
/^BT/ { if($2 > 0)
plus += $2
else minus += $2
}
END { print plus, minus
}' AMT*
i have a file - it will be in sorted order on column 1
abc 0 1
abc 2 3
abc 3 5
def 1 7
def 0 1
--------
i'd like (awk maybe?) to get the results (any ideas)???
abc 5 9
def 1 8 (2 Replies)
Hi,
I have below as i/p file:
5ABC 36488989 K 000010000ASB BYTRES
5PQR 45757754 K 000200005KPC HGTRET
5ABC 36488989 K 000045000ASB HGTRET
5GTH 36488989 K 000200200ASB BYTRES
5FTU ... (2 Replies)
Hi all,
I searched through the forum but i can't manage to find a solution. I need to join a set of files placed in a directory (~1600) by column, and obtain an output with first and second column common to each file, but following columns are taken from the file in the list (precisely the fourth... (10 Replies)
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
I have a file (let say file B) like this:
File B:
A1 3 5
A1 7 9
A2 2 5
A3 1 3
The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines... (3 Replies)
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (1 Reply)
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (12 Replies)
Discussion started by: as7951
12 Replies
LEARN ABOUT BSD
ptx
PTX(1) General Commands Manual PTX(1)NAME
ptx - permuted index
SYNOPSIS
ptx [ option ] ... [ input [ output ] ]
DESCRIPTION
Ptx generates a permuted index to file input on file output (standard input and output default). It has three phases: the first does the
permutation, generating one line for each keyword in an input line. The keyword is rotated to the front. The permuted file is then
sorted. Finally, the sorted lines are rotated so the keyword comes at the middle of the page. Ptx produces output in the form:
.xx "tail" "before keyword" "keyword and after" "head"
where .xx may be an nroff or troff(1) macro for user-defined formatting. The before keyword and keyword and after fields incorporate as
much of the line as will fit around the keyword when it is printed at the middle of the page. Tail and head, at least one of which is an
empty string "", are wrapped-around pieces small enough to fit in the unused space at the opposite end of the line. When original text
must be discarded, `/' marks the spot.
The following options can be applied:
-f Fold upper and lower case letters for sorting.
-t Prepare the output for the phototypesetter; the default line length is 100 characters.
-w n Use the next argument, n, as the width of the output line. The default line length is 72 characters.
-g n Use the next argument, n, as the number of characters to allow for each gap among the four parts of the line as finally printed.
The default gap is 3 characters.
-o only
Use as keywords only the words given in the only file.
-i ignore
Do not use as keywords any words given in the ignore file. If the -i and -o options are missing, use /usr/share/misc/eign as the
ignore file.
-b break
Use the characters in the break file to separate words. In any case, tab, newline, and space characters are always used as break
characters.
-r Take any leading nonblank characters of each input line to be a reference identifier (as to a page or chapter) separate from the
text of the line. Attach that identifier as a 5th field on each output line.
The index for this manual was generated using ptx.
FILES
/usr/bin/sort
/usr/share/misc/eign
BUGS
Line length counts do not account for overstriking or proportional spacing.
7th Edition October 22, 1996 PTX(1)