Input file:
$ cat file.txt
h1|u|1
h2|5|1|1
rec1|1239400800|Sat|fan1|AX|2|10035|-|2|50
rec2|1239400800|Sat|fan1|AX|2|-|-|2|17
rec5|1239400801|Sat|fan3|AY|5|10035|-|2|217
rec8|1239400804|Sat|fan5|AX|2|5|-|2|970
Required Output:
- Lines starting with "h1" or "h2", no action required, just print.
- Lines starting with "rec", divide the values starting from 6th field by 2.
Required output is:
h1|u|1
h2|5|1|1
rec1|1239400800|Sat|fan1|AX|1|5017|-|1|25
rec2|1239400800|Sat|fan1|AX|1|-|-|1|8
rec5|1239400801|Sat|fan3|AY|2|5017|-|1|108
rec8|1239400804|Sat|fan5|AX|1|2|-|1|485
The python script:
fp = open("file.txt", "rU")
lines = fp.readlines()
fp.close()
for line in lines:
if line.startswith("h1"):
print line,
if line.startswith("h2"):
print line,
if line.startswith("rec"):
f=line.split("|")
r = f[5:]
l = []
for each in r:
try:
l.append(str(int(each)/2))
except ValueError:
l.append(each)
t = "|".join(f[0:5]) + "|" + "|".join(l)
print t.rstrip()
Posts
2 Comments:
awk -v OFS="|" -F"|" '/^rec/ { $6=int($6/2); print } /^h(1|2)/ { print }' file.txt
Sorry misread the required output:
awk -v p=6 -v d=2 -v OFS="|" -F"|" '/^rec/ { for( i=p; i<=NF; ++i ) { $i=int($i/d); if( ! $i ) { $i = "-" } } ; print } /^h(1|2)/ { print }' file.txt
Post a Comment