01-28-2008
Awk array proble!!!Please help
I need help with a problem that I have not been able to figure out.
I have a file that is about 650K lines. Records are seperated by
blank lines, fields seperated by new lines. I was trying to make
a report that would add up 2 fields and associate them with a CP.
example output would be something like this:
CP31
----
TCS 10 54087
TCS 342 35173
TOTAL 59260
CP33
----
TCS 8 48790
TCS 286 33614
TOTAL 82404
In a nutshell I have to sum up the first 2 fields of EDM blocks and WRC
blocks and then associate them with what TCS & CP they belong to. I would like
to use AWK, and was trying to use arrays, but with no luck. Maybe multi-
dimensional, have not had any experiance with these. Any help would be very
much appreciated.
Thanks in advance.
I attached a txt doc of partial file. I hope this makes sense.
Last edited by timj123; 01-29-2008 at 09:01 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i had written one script
that make connection with remote host
get some file and close the connection ..
it works fine .. but when i put this scrip in between control structure commands like "if , case " then it give me error like" syntax error at line 26 : `<<' unmatched"
please tell me... (6 Replies)
Discussion started by: ravindra shukla
6 Replies
2. Shell Programming and Scripting
hi all,
i am again surrounded by a big problem,,,
i have 2 files
file1.txt file2.txt
aaaa xxxx xxxxx
xxxxxxxxxxxxxxx
zzzz zzzz zzz bbb
aaaa xx xxxx xxxx
xxx zzzz zzzz zzz... (1 Reply)
Discussion started by: go4desperado
1 Replies
3. Shell Programming and Scripting
Hi,
How can find Array is NULL or not.
i wrote script using arrays but i want dislpy an message if arrary was Empty.
pls help me on this. (2 Replies)
Discussion started by: koti_rama
2 Replies
4. Linux
# Timer for thread to sleep
thread.sleep =15000
# To run the thread as daemon process
thread.run = true
# Copy command
thread.cmd = C:\Program Files\Java\jdk1.5.0\bin\java CopyFile
This is .properties file. CopyFile is name of program.
is that ok. if i use cp command inplace of... (0 Replies)
Discussion started by: sari
0 Replies
5. Shell Programming and Scripting
I have a raw data file:
70,1,1,-53.25
70,1,1,,,,-57.50
70,1,1,,,,,,,,,,-48.00
I want to have a output file with the formatting below:
70,1,1,-53.25,,,,-57.50,,,,,-48.00
I mean if these rows have the first similar three variables which will be group into one row. And I try to write a... (1 Reply)
Discussion started by: anhtt
1 Replies
6. Shell Programming and Scripting
Hi all,
i have a data array as follows.
array=ertfgj2345
array=456ttygkd
.
.
.
array=errdjt3235
so number or elements in the array can varies depending on how big the data input is.
now i have a variable, and it is $1 (there are $2, $3 and so on, i am only interested in $1).
... (9 Replies)
Discussion started by: usustarr
9 Replies
7. Shell Programming and Scripting
Hello experts,
I'm stuck with this script for three days now. Here's what i need.
I need to split a large delimited (,) file into 2 files based on the value present in the last field.
Samp: Something.csv
bca,adc,asdf,123,12C
bca,adc,asdf,123,13C
def,adc,asdf,123,12A
I need this split... (6 Replies)
Discussion started by: shell_boy23
6 Replies
8. Shell Programming and Scripting
HI Guys,
I want to echo below line in my file :-
lpd | grep AL | nawk '{print "1dLA - " $0}
How can i echo same Output (4 Replies)
Discussion started by: pareshkp
4 Replies
9. Shell Programming and Scripting
Hello All,
Can you please help me with the below.
#!/bin/bash
ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5 EXTRACT_DT:30-SEP-12 VER_NUM:1"
ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5... (14 Replies)
Discussion started by: Ariean
14 Replies
10. Shell Programming and Scripting
Here's my code:
awk -F '' 'NR==FNR {
if (/time/ && $5>10)
A=$2" "$3":"$4":"($5-01)
else if (/time/ && $5<01)
A=$2" "$3":"$4-01":"(59-$5)
else if (/time/ && $5<=10)
A=$2" "$3":"$4":0"($5-01)
else if (/close/) {
B=0
n1=n2;
... (2 Replies)
Discussion started by: klane
2 Replies
TCS(1) General Commands Manual TCS(1)
NAME
tcs - translate character sets
SYNOPSIS
tcs [ -slcv ] [ -f ics ] [ -t ocs ] [ file ... ]
DESCRIPTION
Tcs interprets the named file(s) (standard input default) as a stream of characters from the ics character set or format, converts them to
runes, and then converts them into a stream of characters from the ocs character set or format on the standard output. The default value
for ics and ocs is utf, the UTF encoding described in utf(6). The -l option lists the character sets known to tcs. Processing continues
in the face of conversion errors (the -s option prevents reporting of these errors). The -c option forces the output to contain only cor-
rectly converted characters; otherwise, 0x80 characters will be substituted for UTF encoding errors and 0xFFFD characters will substituted
for unknown characters.
The -v option generates various diagnostic and summary information on standard error, or makes the -l output more verbose.
Tcs recognizes an ever changing list of character sets. In particular, it supports a variety of Russian and Japanese encodings. Some of
the supported encodings are
utf The Plan 9 UTF encoding, known by ISO as UTF-8
utf1 The deprecated original UTF encoding from ISO 10646
ascii 7-bit ASCII
8859-1 Latin-1 (Central European)
8859-2 Latin-2 (Czech .. Slovak)
8859-3 Latin-3 (Dutch .. Turkish)
8859-4 Latin-4 (Scandinavian)
8859-5 Part 5 (Cyrillic)
8859-6 Part 6 (Arabic)
8859-7 Part 7 (Greek)
8859-8 Part 8 (Hebrew)
8859-9 Latin-5 (Finnish .. Portuguese)
koi8 KOI-8 (GOST 19769-74)
jis-kanji
ISO 2022-JP
ujis EUC-JX: JIS 0208
ms-kanji
Microsoft, or Shift-JIS
jis (from only) guesses between ISO 2022-JP, EUC or Shift-Jis
gb Chinese national standard (GB2312-80)
big5 Big 5 (HKU version)
unicode
Unicode Standard 1.0
tis Thai character set plus ASCII (TIS 620-1986)
msdos IBM PC: CP 437
atari Atari-ST character set
EXAMPLES
tcs -f 8859-1
Convert 8859-1 (Latin-1) characters into UTF format.
tcs -s -f jis
Convert characters encoded in one of several shift JIS encodings into UTF format. Unknown Kanji will be converted into 0xFFFD char-
acters.
tcs -lv
Print an up to date list of the supported character sets.
SOURCE
/sys/src/cmd/tcs
SEE ALSO
ascii(1), rune(2), utf(6).
TCS(1)