single line input to multiple line output with sed

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting single line input to multiple line output with sed
# 1  
Old 07-13-2008
single line input to multiple line output with sed

hey gents,

I'm working on something that will use snmpwalk to query the devices on my network and retreive the device name, device IP, device model and device serial. I'm using Nmap for the enumeration and sed to clean up the results for use by snmpwalk. Once i get all the data organized I'm going to send it to a mysql db. My problem starts once all my sed is done and snmpwalk has done its thing.

Final sed results:

what I want though is:

If I can get sed or awk to do this I will not have to do it with mysql commands.

thanks for any assistance.

This is taking place on:
Fedora Core 8 with sed 4.1.5
# 2  
Old 07-13-2008
Try this:

awk -F, '{for(i=1;i<=NF;i++){printf("%s%s",$i,i%4?",":"\n")}}' file

If you get errors use nawk, gawk or /usr/xpg4/bin/awk on Solaris.

# 3  
Old 07-14-2008
Awesome Franklin52,

Worked like a champ. If you don't mind elaborating on the code so I can understand what is going on.

Thank you.
# 4  
Old 07-14-2008
You can do it directly in sed if you wish:
(use /usr/xpg4/bin/sed on Solairs)

sed 's/\([^,]*,\)\{4\}/&\
/g' file

For old versions of sed:

sed 's/\([^,]*,[^,]*,[^,]*,[^,]*,\)/&\
/g' file

# 5  
Old 07-14-2008
No luck Radoulov,
i received an error that reads

sed: -e expression #1, char 22: unterminated `s' command

char 22 is a } and phpdesigner2008 doesn't see a problem with that.
# 6  
Old 07-14-2008
Without the entire code it would be difficult to debug,
try copy/pasting the code (there is an escaped new line):

zsh-4.3.4% cat file
zsh-4.3.4% sed 's/\([^,]*,\)\{4\}/&\
quote> /g' file

With GNU sed you could even write it like this:

zsh-4.3.4% sed -r 's/([^,]*,){4}/&\n/g' file

# 7  
Old 07-15-2008

In like flyn. the bottom code you supplied also worked awesome. thank you for your help. Can you take a min to explain how it works? I understand the basics of sed
's = substitute
first set /XXX/ is the regexp i want to identify
second sed /XXX/ is what I want it changed to and
g' = do it globally

but i can't read whats going on.

oh and the reason I was having a problem yesterday is because when I put your code in a file so that I could pipe my file through it I didn't take the last single ' off the back of the g.

Thank you

Last edited by mitch; 07-15-2008 at 11:17 AM.. Reason: add info
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Output to file print as single line, not separate line

example of problem: when I echo "$e" >> /home/cogiz/file.txt result prints to file as:AA BB CC I need it to save to file as this:AA BB CC I know it's probably something really simple but any help would be greatly appreciated. Thank You. Cogiz (7 Replies)
Discussion started by: cogiz
7 Replies

2. Shell Programming and Scripting

Multiple pattern match and print the output in a single line

I need to match two patterns in a log file and need to get the next line of the one of the pattern (out of two patterns) that is matched, finally need to print these three values in a single line. Sample Log: 2013/06/11 14:29:04 <0999> (725102) Processing batch 02_1231324 2013/06/11... (4 Replies)
Discussion started by: rpm120
4 Replies

3. Shell Programming and Scripting

sed command to grep multiple pattern present in single line and delete that line

here is what i want to achieve.. i have a file with below contents cat fileName blah blah blah . .DROP this REJECT that . --sport 7800 -j REJECT --reject-with icmp-port-unreachable --dport 7800 -j REJECT --reject-with icmp-port-unreachable . . . more blah blah blah --dport 3306... (14 Replies)
Discussion started by: vivek d r
14 Replies

4. Shell Programming and Scripting

convert single line output to multiple line

Hi all, I have a single line output like below echo $ips want to convert above single line output as below format. Pls advice how to do ? Regards Kannan (6 Replies)
Discussion started by: kamauv234
6 Replies

5. Shell Programming and Scripting

Joining multi-line output to a single line in a group

Hi, My Oracle query is returing below o/p ---------------------------------------------------------- Ins trnas value a lkp1 x a lkp1 y b lkp1 a b lkp2 x b lkp2 y ... (7 Replies)
Discussion started by: gvk25
7 Replies

6. Shell Programming and Scripting

Merge multi-line output into a single line

Hello I did do a search and the past threads doesn't really solve my issue. (using various awk commands) I need to combine the output from java -version into 1 line, but I am having difficulties. When you exec java -version, you get: java version "1.5.0_06" Java(TM) 2 Runtime... (5 Replies)
Discussion started by: flagman5
5 Replies

7. Shell Programming and Scripting

Two Input Lines Into Single Output Line (CSV)

Hi all, My search karate must be weak because I'm about certain something very like this has been asked and answered here many times. I'll give you the exact scenario I've wasted a few hours of my Saturday on: :wall: I'm trying to read through a very large number (~200) of router and... (28 Replies)
Discussion started by: svermill
28 Replies

8. Shell Programming and Scripting

SED - Multiple String - Single Line

Would appear to me to be a farily simple question but having search all the threads I can't find the answer .. I just want sed to output the single line in a file that contains two string anywhere on the line.. e.g. currently using this command sed -n -e'/str1/p' -e '/str2/p' < file and... (3 Replies)
Discussion started by: flopster
3 Replies

9. Shell Programming and Scripting

Putting multiple sed commands on a single line

Hi, I want to make sed write a part of fileA (first 7 lines) to file1 and the rest of fileA to file2 in a single call and single line in sed. If I do the following: sed '1,7w file1; 8,$w file2' fileA I get only one file named file1 plus all the characters following file1. If I try to use curly... (1 Reply)
Discussion started by: varelg
1 Replies

10. Shell Programming and Scripting

make multiple line containing a pattern into single line

I have the following data file. zz=aa azxc-1234 aa=aa zz=bb azxc-1234 bb=bb zz=cc azxc-1234 cc=cc zz=dd azxc-2345 dd=dd zz=ee azxc-2345 ee=ee zz=ff azxc-3456 ff=ff zz=gg azxc-4567 gg=gg zz=hh azxc-4567 hh=hh zz=ii azxc-4567 ii=ii I want to make 2nd field pattern matching multiple lines... (13 Replies)
Discussion started by: VTAWKVT
13 Replies
Login or Register to Ask a Question

Featured Tech Videos