|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
AWK print all in one line
Post 302304818 by sdohn on Tuesday 7th of April 2009 10:43:49 AM
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=CONFIRMED
evnull 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=CONFIRMEDevnull 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
-------- 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=CONFIRMED
evnull 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=CONFIRMED
evnull 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
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
awk '{print ; print '""'}' in.txt >inf.txt (2 Replies)
Discussion started by: cola
2 Replies
5. Shell Programming and Scripting
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
6. UNIX for Dummies Questions & Answers
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
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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
LEARN ABOUT SUSE
end
END(7) SQL Commands END(7) NAME
END - commit the current transaction SYNOPSIS
END [ WORK | TRANSACTION ] DESCRIPTION
END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT [commit(7)]. PARAMETERS
WORK TRANSACTION Optional key words. They have no effect. NOTES
Use ROLLBACK [rollback(7)] to abort a transaction. Issuing END when not inside a transaction does no harm, but it will provoke a warning message. EXAMPLES
To commit the current transaction and make all changes permanent: END; COMPATIBILITY
END is a PostgreSQL extension that provides functionality equivalent to COMMIT [commit(7)], which is specified in the SQL standard. SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)] SQL - Language Statements 2010-05-14 END(7)