Visit Our UNIX and Linux User Community


Need comma separated output


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need comma separated output
# 1  
Old 08-29-2013
Need comma separated output

Hi,

I am having the file with server names & its corresponding process, i need your help how to convert into comma separated output between server & app

Code:
#cat apps.txt
Server1
oracle
was
Server2
http
webadmin
Server3
tsm
db2

My requirement is like below.

Code:
Server1,oracle/was
Server2,http/webadmin
Server3,tsm/db2

# 2  
Old 08-29-2013
Easy with paste:
Code:
paste -s -d',/\n' file
Server1,oracle/was
Server2,http/webadmin
Server3,tsm/db2

# 3  
Old 08-29-2013
Hi Rudic, Thanks for your quick tip

having 1 more doubt, how to use paste command for the following

Code:
#cat apps.txt
Server1
oracle
Server2
http
webadmin
oracle
Server3
tsm
webadm

The output required as follows

Code:
Server1,oracle
Server2,http/webadmin/oracle
Server3,tsm/webadm

# 4  
Old 08-29-2013
for gnu flavor awk try:
Code:
awk '$1=$1 {sub("/",","); sub("/$",""); print RS $0}' RS="Server"  FS="\n" OFS=/ apps.txt

# 5  
Old 08-29-2013
Easy with awk:
Code:
awk     '$1 ~ /Server/  {printf "\n"; printf "%s,", $1; SL=""; next}
                        {printf "%s%s", SL, $1; SL="/"}
         END            {printf "\n"}
        ' file
Server1,oracle
Server2,http/webadmin/oracle
Server3,tsm/webadm

This User Gave Thanks to RudiC For This Post:
# 6  
Old 08-29-2013
Hi Rudic,

No words to explain.. U r great. Thanks ..

Regards,
Siva

Previous Thread | Next Thread
Test Your Knowledge in Computers #701
Difficulty: Easy
MySQL NOT LIKE is a sardonic DB operator used to exclude those rows which are not liked by Oracle Corporation executives.
True or False?

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to extract fields from a CSV i.e comma separated where some of the fields having comma as value?

can anyone help me!!!! How to I parse the CSV file file name : abc.csv (csv file) The above file containing data like abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies

2. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ... (3 Replies)
Discussion started by: as7951
3 Replies

3. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies

4. Shell Programming and Scripting

How to split the comma separated file?

Hi, I have a filein unix like ABC,CDE BCD,KHL and the output i need is like column1 column2 ABC,CDE ABC ABC,CDE CDE BCD,KHL BCD BCD,KHL KHL. Can some body help me out? Hi, The code is working fine. But in my file each row does not have always 1 comma. It may... (6 Replies)
Discussion started by: jagdishrout
6 Replies

5. Shell Programming and Scripting

Need Help - comma inside double quote in comma separated csv,

Hello there, I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process. Input in the csv file is , 1,234,"abc,12,gh","GH234TY",34 I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies

6. Shell Programming and Scripting

Comma separated file

Hi all, I have the following files types: FileA: 100, 23, 33, FileB: 22, 45, 78, and i want to make File C: 100,22 23,45 33,78 any nice suggestions for making it easy. (3 Replies)
Discussion started by: hen1610
3 Replies

7. Shell Programming and Scripting

Output of command in comma separated list

Hi; I have an output of a particular command say $command fstl:r-x ajay:r-x how can i get this in comma separated list, eg: fstl:r-x,ajay:r-x Thnks; (4 Replies)
Discussion started by: ajaypadvi
4 Replies

8. Shell Programming and Scripting

Perl script to parse output and print it comma separated

I need to arrange output of SQL query into a comma separated format and I'm struggling with processing the output... The output is something like this: <Attribute1 name><x amount of white spaces><Atribute value> <Attribute2 name><x amount of white spaces><Atribute value> <Attribute3... (2 Replies)
Discussion started by: Juha
2 Replies

9. Shell Programming and Scripting

Need comma separated processing

I have a file like this OUTLN OPEN Y SCOTT OPEN N USER4 OPEN Y DBSNMP EXPIRED & LOCKED N ... (4 Replies)
Discussion started by: ilugopal
4 Replies

Featured Tech Videos