But since my variable that I am looking out for an10, an31 and an40 are in different fields, in the new files, I cant obtain an uniform output with the above command.
Any idea how to get the desired output using the desired command
Last edited by Don Cragun; 05-19-2015 at 03:48 AM..
Reason: Add CODE and ICODE tags again.
It's not that easy to infer your requirements from what you've posted, so I hope I'm on the right path. Why don't you help us help you by thinking twice and giving a detailed and precise spec?
Try to pipe your data through
Code:
awk '
BEGIN {FS=","
for (i=split("findline,an10,an31,an40", t); i; i--) FLD[t[i]]=i
}
/findline=00/ {for(i=1; i<=NF;i++) {T=$i; sub (/=.*$/, _, T)
if (T in FLD )
OUT[FLD[T]]=$i
}
for (f=1; f<=4; f++) printf "%s ", OUT[f];
print ""
}
'
findline=00 an10=23 an31=32 an40=45
findline=00 an10=24 an31=35 an40=95
Since you only supplied the output from your gzip command, there was no way for us to test with that command in scripts we were trying to build and test for you.
With what RudiC provided and the pipeline that we thought you had created, we assumed you would be able to change the first line of RudiC's script from:
Code:
awk '
to:
Code:
gzip -dcr/file path/filename.gz | awk '
to get what you want.
If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk.
This User Gave Thanks to Don Cragun For This Post:
Dear all,
I have a huge txt file (DATA.txt) with the following content . From this txt file, I want the following output using some shell script.
Any help is greatly appreciated.
Greetings,
emily
DATA.txt (snippet of the huge text file)
407202849... (2 Replies)
I have a result like this
root@server # grep -rl maldet /etc/cron*
/etc/cron.d/maldet_daily
/etc/cron.d/malcron
/etc/cron.d/malcrondaily
/etc/cron.d/malcronweekly
What I need is, I need an if/else condition such that, if there is any output other than /etc/cron.d/maldet_daily in the... (8 Replies)
Hi,
I am unable to get beyond the exit function. The shell script is used to look for masked files and copy paste them to another location. Please refer to the code below for more information.
Thanks
Brinjit
#!/usr/bin/ksh... (10 Replies)
currently I have process from a raw file to this stage
ALTER TABLE "EXCEL_ADMIN"."TC_TXN_VOID" ADD CONSTRAINT "PK_TC_TXN_VOID" PRIMARY KEY ("TC_TXN_IID")
ALTER TABLE "EXCEL_ADMIN"."TC_TXN_AMT" ADD CONSTRAINT "PK_TC_TXN_AMT" PRIMARY KEY ("TC_TXN_AMT_IID")
ALTER TABLE... (10 Replies)
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
I am trying to add a line to a BASH shell script to print out a large variable length table on a web page. I am very new to this obviously, but I tried this with awk and it prints out every line twice. What I am doing wrong?
echo "1^2^3%4^5^6%7^8^9%" | awk 'BEGIN { RS="%"; FS="^"; } {for (i =... (6 Replies)
Hi,
My name is Tex I am past 60 and in need of perl help. My hobby is genealogy and I am using a perl program to display my data on my web pages. I don't even know enough to know how to ask in the right way for the help
I need.
This program is written in perl it is open and has been updated... (2 Replies)
hi buddies,
i want to learn something,so that we have several users on a sun server and via telnet, we are connecting to server same username and password root/something as root
and after connection i want to see what other roots or users are doing on the server, i want to see their command.... (2 Replies)
05-19-2015
