facing problem in getting output on single line


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting facing problem in getting output on single line
# 1  
Old 08-02-2008
facing problem in getting output on single line

i am using these two grep commands

grep "^tipo" dump3_out.dat|awk -F"," '{for(i=1;i<=NF;i++){A=$i;B=substr($i, index($i, "=")+1);{print B }}}'|paste -s -d"||\n"|sed -e 's/^ //g' -e 's/| /|/g' >> result.dat
grep -n "^ind" dump3_out.dat|cut -d "=" -f2|cut -d "," -f2|cut -d "n" -f1|tr -d '^ ' >> result.dat

my out put appears as:

abonado simplex|dic1 - none|estandar
0
abonado simplex|dic1 - none|estandar
0
abonado simplex|dic1 - none|estandar
0
abonado simplex|dic1 - none|estandar
0

i want my out as :

abonado simplex|dic1 - none|estandar|0
abonado simplex|dic1 - none|estandar|0
abonado simplex|dic1 - none|estandar|0
abonado simplex|dic1 - none|estandar|0


please help
# 2  
Old 08-02-2008
Post a portion of the file dump3_out.dat. Maybe there's easier way to get the desired output.

Regards
# 3  
Old 08-02-2008
this is my dump3_out

tipo = abonado simplex, Idiomas = dic1 - none, Operador = estandar
Serv. portadora admitido: modem
ind = 0 numero telefonico = 79260960, att = 0
Carrier Contratado: naz = INDEFINIDO - int = INDEFINIDO
Origen = SELENA
tin = 0, inv = 0, tas = 0, cid = 0, pol = dir, ans = no, np = nup164,
Clase de servicio = COSDTM
Nombre mascara prohibic. = BAJAESPE
mor = no, fut = SELENA, cwr = 0, pbd = 1, ttx = 0, pmg = 0, ssa = 1, ssr = 0
duf = 0, anc = 0, lin = 1, ufn = 0, ort = 1, atc = p0, inm = 0 sve = 0
usc = 0, nin = 0, ocp = 0, dbl = 4, cos = 0, imc = 0, tcl = 0 scp = none
icr = no , start = no , tst = no , osr = no,
mct = 0, urg = 0, msm = 0,
lbi = 0, csr = 0,ltp = 0, lpf = 0, cnu = no
oristr = 1, telistr = no
vad = no, nor = subs, oct = 1, cntx = no
Carrier PVN = habilitad
tipo = abonado simplex, Idiomas = dic1 - none, Operador = estandar
Serv. portadora admitido: modem
ind = 0 numero telefonico = 79260961, att = 1
Carrier Contratado: naz = INDEFINIDO - int = INDEFINIDO
Origen = SELENA
tin = 0, inv = 0, tas = 0, cid = 0, pol = dir, ans = no, np = nup164,
Clase de servicio = COSDTM
Nombre mascara prohibic. = dbc5
mor = no, fut = SELENA, cwr = 0, pbd = 1, ttx = 0, pmg = 0, ssa = 1, ssr = 0
duf = 0, anc = 0, lin = 1, ufn = 0, ort = 1, atc = p0, inm = 0 sve = 0
usc = 0, nin = 0, ocp = 0, dbl = 4, cos = 0, imc = 0, tcl = 0 scp = none
icr = no , start = no , tst = no , osr = no,
mct = 0, urg = 0, msm = 0,
lbi = 0, csr = 0,ltp = 0, lpf = 0, cnu = no
oristr = 1, telistr = no
vad = no, nor = subs, oct = 1, cntx = no
Carrier PVN = habilitad
tipo = abonado simplex, Idiomas = dic1 - none, Operador = estandar
Serv. portadora admitido: modem
ind = 0 numero telefonico = 79260962, att = 1
Carrier Contratado: naz = INDEFINIDO - int = INDEFINIDO

Last edited by junaid.nehvi; 08-02-2008 at 12:21 PM.. Reason: for writting what it is
# 4  
Old 08-02-2008
Base on your data sample this oneliner should do the job.
Code:
awk 'BEGIN{FS=",|= ";OFS="|"}/tipo/{a=$2OFS$4OFS$6}/ind/{print a,int($2)}'  file

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

convert single line output to multiple line

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

3. Shell Programming and Scripting

Output to single line

Hi, I am using below command and getting below output. echo "dis ql(*) CLUSTER"|runmqsc CT.QM.ASSA10T1| egrep 'QUEUE|CLUSTER'|egrep -v 'SYSTEM|XMITQ'| sed -e 's/QUEUE(/ /g' -e 's/TYPE(QLOCAL)/ /g' -e 's/CLUSTER(/ /g' -e 's/)/ /g' output CT.CL.ALLUHUB.FLST_TO_HUB_PROV.01... (20 Replies)
Discussion started by: darling
20 Replies

4. 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

5. 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

6. Shell Programming and Scripting

Output to be in single line

Hi All, Small script but :wall:, please help in this regard. for i in 1 2 3 do echo $i done result : 1 2 3 I want the above to be printed as below expected result: 1 2 3 Thanks in advance :) (3 Replies)
Discussion started by: girish_satyam
3 Replies

7. Shell Programming and Scripting

Line space problem facing

Hi, I got a list of file that all got the same standard format. Can anyone teach me how to put the space in all of them?! Input file: >nucleotide1 AAAAAAAAACCCGGG >nucleotide2 GGGGGGCCCCCTTTTA >nucleotide3 GGTACACCACACTCAC >nucleotide4 TTTGGAGAGAGACCCC desired output:... (4 Replies)
Discussion started by: patrick87
4 Replies

8. Shell Programming and Scripting

Output coming in different line instead of single line

Hi Guys, I have an oracle database, I am trying to query the database and route it to file. But the records instead of coming in a single line, are coming in three lines. Can you please help me.. in this.. sqlplus -s $SRMUserid/$SRMPassword@$SRMServer<< EOF >log.out; select * from... (5 Replies)
Discussion started by: mac4rfree
5 Replies

9. Shell Programming and Scripting

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... (8 Replies)
Discussion started by: mitch
8 Replies

10. Shell Programming and Scripting

Multi-line output to single line

Hello, How can I take the following output: outputa outputb outputc and turn it into single line ouput, with a single space between each field like below: outputa outputb outputc (7 Replies)
Discussion started by: LinuxRacr
7 Replies
Login or Register to Ask a Question