Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

AWK print all in one line

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting AWK print all in one line
# 1  
Old 04-07-2009
AWK print all in one line
Hello, I want to parse a vcal file with awk, and later import the specific output file into excel. I want everything on one line.

-------- file testcal.ics -------------
BEGIN:VCALENDAR
PRODID:-//WebCalendar-v1.0.5
VERSION:2.0
METHOD:PUBLISH
BEGIN:VEVENT
UID:20090407T123456Z-9766476-2805@192.168.17.150
SUMMARY:"Troubleshoot LRV Database Performance "
DESCRIPTION:Find out why some SQL Sciptjobs from a specific User are very
imperformant
CLASS:PUBLIC
ATTENDEE;ROLE=OWNER;STATUS=CONFIRMEDSmilieevnull User <devnull@devnull.zero>
DTSTART:20090323T090000Z
DTSTAMP:20090407T123456Z
DTEND:20090323T110000Z
END:VEVENT
BEGIN:VEVENT
UID:20090407T123456Z-6411416-2805@192.168.17.150
SUMMARY:Workout Sugestions for the Streams Tivoli Monitoring
DESCRIPTION:Read several Oracle Streams Monitoring Documentations. Workout
what to Monitor in the Oracle Streams ZEETOOL Environment
CLASS:PUBLIC
ATTENDEE;ROLE=OWNER;STATUS=CONFIRMEDSmilieevnull User <devnull@devnull.zero>
DTSTART:20090323T110000Z
DTSTAMP:20090407T123456Z
DTEND:20090323T170000Z
END:VEVENT
-------------SNIP-----------------------

awk '/^SUMMARY/{mysummary=$0}
/^DESCRIPTION/{mydescription=$0}
/^DTSTART/{mydtstart=$0}
/^DTEND/{mydtend=$0}
{print(mysummary mydescription mydtstart mydtend)}' testcal.ics

How to correctly assign, and print those variables on one line.

brgds sdohn
# 2  
Old 04-07-2009
Code:
awk '/^SUMMARY/{ printf( "%s", $0 );}
etc...
{ printf( "\n" ); }

# 3  
Old 04-07-2009
Quote:
Originally Posted by quirkasaurus
Code:
 
Thank you user quirkasaurus.
I've tried your code, but it gives me everything on several lines.
 
awk '/^SUMMARY/{ printf( "%s", $0 );}
etc...
{ printf( "\n" ); }

SUMMARYSmilieefine Operational Database Parameters
DESCRIPTION:Necessary configuration for Oracle Streams Database P1VPMDEX


DTSTART:20090326T150000Z
DTEND:20090326T170000Z

SUMMARY:Prepare U1 Level 3 Change Tasks
DESCRIPTION:Workout how to implement the streams_purge_archive_logs Script


DTSTART:20090327T090000Z
DTEND:20090327T110000Z


What I want is to put every block comma seperated on one line like this:

SUMMARYSmilieefine Operational Database Parameters,DESCRIPTION:Necessary configuration for Oracle Streams Database P1VPMDEX,DTSTART:20090326T150000Z,DTEND:20090326T170000Z
# 4  
Old 04-07-2009
oh...... maybe this??

Code:
awk '
/^SUMMARY/{ printf( "%s,", $0 );  }
etc...
'

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to print the line that matches and the next if line is wrapped

I have a file and when I match the word "initiators" in the first column I need to be able to print the rest of the columns in that row. This is fine for the most part but on occasion the "initiators" line gets wrapped to the next line. Here is a sample of the file. caw-enabled ... (3 Replies)
Discussion started by: kieranfoley
3 Replies

2. Shell Programming and Scripting

awk print everything in new line

Hi, I have the following file and I would like to print everything to new line and the field seperator should be the dash (-). /usr/java/jdk1.6.0_30/bin/java -Dprogram.name=run.sh -server -XX:PermSize=512m -XX:MaxPermSize=512m -XX:NewSize=1g -XX:MaxNewSize=1g -Xmx3g -Xms3g... (3 Replies)
Discussion started by: kmaq7621
3 Replies

3. Shell Programming and Scripting

awk script -print line when $2 > $2 of previous line

Hi all, From a while loop I am reading a sorted file where I want to print only the lines that have $1 match and $2 only when the difference from $2 from the previous line is > 30. Input would be like ... AN237 010 193019 0502 1 CSU Amoxycillin AN237 080 ... (2 Replies)
Discussion started by: gafoleyo73
2 Replies

4. Shell Programming and Scripting

awk to print in a line

hi all, i have text file with sample text 01 02 .. abc .. def .. xyz .. x12 03 04 .. z123 .. x234 (6 Replies)
Discussion started by: posner
6 Replies

5. UNIX for Dummies Questions & Answers

awk...print first line...

hello all, I am trying to use the AWK cmd on unix and trying to figre out how i can only print the first line and now rest of the line...so for example... $ lsnrctl version|grep Version| awk '{print $5}'| awk -F. '{print $1}'|uniq 11 NT Adapter for but i only want 11 to print out there... (3 Replies)
Discussion started by: abdul.irfan2
3 Replies

6. Shell Programming and Scripting

awk to print on the same line

Hi all, I've a script that uses awk to parse the output of wget during a database update. The code I use is: wget -c ftp://ftpsite/file 2>&1 | awk '/0%/ {print}'But this spits out each progress line on a new line: 37250K .......... .......... .......... .......... .......... 80% 10.9M 1s ... (2 Replies)
Discussion started by: euval
2 Replies

7. Shell Programming and Scripting

awk, Why does it print the same line twice?

awk '{print ; print '""'}' in.txt >inf.txt (2 Replies)
Discussion started by: cola
2 Replies

8. Shell Programming and Scripting

awk print the next line on the current line

Ok I have a file with hundreds of lines, four columns, space delimited, TESTB.TXT for example TESTB.TXT --- AA ZZ 12 34 BB YY 56 78 CC XX 91 23 DD VV 45 67 --- I want a new file that has 7 columns, the first four are identical, and the next 3 are the last three of the next line...so... (5 Replies)
Discussion started by: ajp7701
5 Replies

9. Shell Programming and Scripting

print any required line by its line no using awk and its NR variable

how to print any required line by its line no using awk and its NR variable for eg: ------------ 121343 adfdafd 21213sds dafadfe432 adf.adf%adf --------------- requied o/p if give num=3 it print: 21213sds -------------------------------------- (2 Replies)
Discussion started by: RahulJoshi
2 Replies

10. UNIX for Dummies Questions & Answers

awk print line

Hi All, I know that i can print the lines from awk just using the print method, but i need to print stuff before it i.e: BEGIN { i=0 } { i++ print i ")" print } END { } Here the output is: (7 Replies)
Discussion started by: Chiefos
7 Replies
Login or Register to Ask a Question