Filtering output from given input


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Filtering output from given input
# 1  
Old 12-01-2014
Filtering output from given input

Hi All,
I have a input file as below. Input file may contain more hostlists.

sample Input file
Code:
   $ cat hostlist.lst
   cs18-db1-1-sjl
   cs22-db1-1-was
   na88-db1-1-chi
   na21-db1-2-was

I want the output like below format. Pls help. Thanks !
Output format:

Code:
cs18-db1-1-sjl:A cs22-db1-1-was:B na88-db1-1-chi:C na21-db1-2-was:D

Regards
Kamal
# 2  
Old 12-01-2014
It might help to say which shell you are working with, which OS you are using and - first of all - what you have tried so far to get the desired result.

To me it seems the task has three things which need to be done:

1) read a line (machine name?)
2) add a colon and a consecutive letter to it. (btw.: what to do after the 26th host?)
3) print the result out without a line break (another question: what to do after reaching the maximum line length?)

Which part do you have troubles with?

I hope this helps.

bakunin
# 3  
Old 12-01-2014
Hi Bakunin,
Thanks for the reply

- Hostlist usually less than 15 hosts only. So it wont go until 26
- I am using bash shell & linux OS
- I need a output in single line like i mentioned earlier

Code:
cs18-db1-1-sjl:A cs22-db1-1-was:B na88-db1-1-chi:C na21-db1-2-was:D

Regards
Kamal
# 4  
Old 12-01-2014
Quote:
Originally Posted by kamauv234
Hi Bakunin,
Thanks for the reply

- Hostlist usually less than 15 hosts only. So it wont go until 26
- I am using bash shell & linux OS
- I need a output in single line like i mentioned earlier

Code:
cs18-db1-1-sjl:A cs22-db1-1-was:B na88-db1-1-chi:C na21-db1-2-was:D

Regards
Kamal
Hello Kamal,

Following may help you in same.

Code:
awk 'BEGIN{split("ABCDEFGHIJKLMNOPQRSTUVWXYZ", A, "")} {print $0 ":" A[++i]} END{ORS="";print "\n"}' ORS=" " Input_file

Output will be as follows.
Code:
cs18-db1-1-sjl:A cs22-db1-1-was:B na88-db1-1-chi:C na21-db1-2-was:D


Thanks,
R. Singh

Last edited by RavinderSingh13; 12-01-2014 at 10:38 AM..
These 2 Users Gave Thanks to RavinderSingh13 For This Post:
# 5  
Old 12-01-2014
Thanks a lot ... perfectly working !!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Filtering netstat command output

Hi All, I am trying to collect the listen ports info from netstat command in centos 7 From that info i am trying to collect all the foreign address IP for those ports. I am using below script to do the same. netstat -an |grep -w "LISTEN" |grep -v "127.0.0.1" |awk '{print $4}' >... (3 Replies)
Discussion started by: sravani25
3 Replies

2. Shell Programming and Scripting

Complex Output Filtering

Hi, I have this command on my linux jmap -heap $pid | grep '%\|:' the output of which is like below: I need a smart way to check if any of these memory usage crosses 95%, 90% and 85% i need to triggerAlert accordingly. I know how to trigger email alerts however I need a good way to... (3 Replies)
Discussion started by: mohtashims
3 Replies

3. Shell Programming and Scripting

INPUT/OUTPUT question

Hi All, Is it wrong to do something like this: ssh -T $PROXY_USER@$PROXY_SERVER < script.txt > ssh_output.log I ran and it works fine and does what I need. I wanted to pass a set of commands to the ssh session and store an output in the log file. Thanks (4 Replies)
Discussion started by: rdogadin
4 Replies

4. UNIX for Dummies Questions & Answers

filtering out certain output

hi guys, i have a long output and cant figure out a flexible way to show the meta members from a device. please help. some device have 2,4 or 8 meta members but for this example i have 4 meta members, what is a flexible way to pull them out from this output? need your inputs thanks. ... (4 Replies)
Discussion started by: prodigy06
4 Replies

5. Shell Programming and Scripting

filtering and formatting the output

Hi Team, I have input file like below. UNDEF : SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_CREATE_SUB_KEY, OTHER_PERMISSION : PROCR_READ, USER_NAME : oracle, GROUP_NAME : dba} UNDEF : SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION :... (4 Replies)
Discussion started by: kamauv234
4 Replies

6. Shell Programming and Scripting

filtering input from read command

I need help understanding a script I'm modifying which someone else has written. Basically I’m looping through a buffer that holds records fetched from a database query. I need a way to separate the primary key values from other attributes in the result. Heres the code: BUFF=buffer_file >... (5 Replies)
Discussion started by: d3mon_spawn
5 Replies

7. Shell Programming and Scripting

filtering print output

I have these data below and i want my output to print only the 3rd files. For example, in /opt/home/nyfix/.k5login, i want to print only "nyfix". /opt/home/nyfix/.k5login /opt/home/security/.k5login /opt/home/noc/.k5login what is the appropriate command in shell scripting ? (2 Replies)
Discussion started by: linuxgeek
2 Replies

8. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies

9. Shell Programming and Scripting

filtering and sending sar output via email

We have a program which create sar output files which has a weeks data... To read file we use sar -f sa15 command which has multiple days data( a weeks data)....we need to only get last 48 hours data and email it to different users.... I guess we can use combination of sar -o or even awk.... (3 Replies)
Discussion started by: noorm
3 Replies

10. Shell Programming and Scripting

filtering a range of ports out of a netstat output

i'd like to grep a range of ports on a netstat -nt output, localaddress, say :1 to :1023. how do i do it via sed/awk/grep? Thanks, Marc (1 Reply)
Discussion started by: marcpascual
1 Replies
Login or Register to Ask a Question