Sponsored Content
Top Forums Shell Programming and Scripting Need help on appending all the lines in a file after a pattern is found Post 302712525 by itkamaraj on Tuesday 9th of October 2012 09:12:21 AM
Old 10-09-2012
Code:
$ awk -F, -v OFS=, '/cube/{a=$3} /minutes/{$NF=$NF","a}1' a.txt
Wed,Database,ABC_cube,loaded
Wed,Logging,out,user,302002654,active,for,0,minutes,ABC_cube
Wed,Logging,out,user,109000151,active,for,8,minutes,ABC_cube
Wed,Logging,out,user,302002654,active,for,0,minutes,ABC_cube
Wed,Logging,out,user,302002654,active,for,60,minutes,ABC_cube
Wed,Database,XYZ_cube,loaded
Wed,Logging,out,user,302002654,active,for,0,minutes,XYZ_cube
Wed,Logging,out,user,109000151,active,for,8,minutes,XYZ_cube
Wed,Logging,out,user,302002654,active,for,0,minutes,XYZ_cube
Wed,Logging,out,user,302002654,active,for,60,minutes,XYZ_cube
Wed,Database,DBC_cube,loaded
Wed,Logging,out,user,302002654,active,for,0,minutes,DBC_cube
Wed,Logging,out,user,109000151,active,for,8,minutes,DBC_cube
Wed,Logging,out,user,302002654,active,for,0,minutes,DBC_cube
Wed,Logging,out,user,302002654,active,for,60,minutes,DBC_cube

please use the code tag
https://www.unix.com/how-post-unix-li...code-tags.html

Last edited by itkamaraj; 10-09-2012 at 10:13 AM.. Reason: missed the comma
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

need help appending lines/combining lines within a file...

Is there a way to combine two lines onto a single line...append the following line onto the previous line? I have the following file that contains some blank lines and some lines I would like to append to the previous line... current file: checking dsk c19t2d6 checking dsk c19t2d7 ... (2 Replies)
Discussion started by: mr_manny
2 Replies

2. Shell Programming and Scripting

Delete a block of text delimited by blank lines when pattern is found

I have a file which contains blocks of text - each block is a multi-lines text delimited by blank lines eg. <blank line> several lines of text ... pattern found on this line several more lines of text ... <blank line> How do you delete the block of text (including the blank lines) when... (17 Replies)
Discussion started by: gleu
17 Replies

3. Shell Programming and Scripting

appending lines to a file dynamically

Hi all, I have a file with some number of lines. I need to add certain number of lines from another file which may vary according to the user's input and to it. eg code: I/P file 1 apps/file/xyz apps/file/abc apps/file/def file 2 progs/file/xyz ... (2 Replies)
Discussion started by: Ananthdoss
2 Replies

4. Shell Programming and Scripting

Grouping or appending the lines in a file through Unix

Hi, I am looking for a way to Group the Lines in a file.. Basically My file structure is something like this A 1 100 abc def A 1 200 abc def A 1 300 abc def A 2 100 pqr def A 2 200 pqr def A 2 300 pqr def A 1 100 abc def A 1 200 xyz def A 1 300 xyz def I need it as... (1 Reply)
Discussion started by: mkandula1983
1 Replies

5. UNIX for Dummies Questions & Answers

Grouping or appending the lines in a file through Unix

Hi, I am looking for a way to Group the Lines in a file.. Basically My file structure is something like this A 1 100 abc def A 1 200 abc def A 1 300 abc def A 2 100 pqr def A 2 200 pqr def A 2 300 pqr def A 1 100 abc def A 1 200 xyz def A 1 300 xyz def I need it as... (6 Replies)
Discussion started by: mkandula1983
6 Replies

6. Shell Programming and Scripting

awk to print all lines after a pattern is found

Is there a way with aw to print all lines after a string is found There is a file like this ....... ........ 2012/19/11 :11.58 PM some data lne no date 2012/19/11 :11.59 PM some other data 2012/20/11 :12.00 AM some other data some line without dates some more lines without dates... (8 Replies)
Discussion started by: swayam123
8 Replies

7. Shell Programming and Scripting

Copy/print all lines between pattern is found in .log files

Hi, I have a folder with multiple (< 33) .log files. And I have to copy the lines between two patterns from all the .log files to a new file. (script file with a loop?) Thanks in advance. 1.log ... .. xx1> begin ... .. .. >>> Total: 2 Alarms .. .. (17 Replies)
Discussion started by: AK47
17 Replies

8. Shell Programming and Scripting

If first pattern is found, look for second pattern. If second pattern not found, delete line

I had a spot of trouble coming up with a title, hopefully you'll understand once you read my problem... :) I have the output of an ldapsearch that looks like this: dn: cn=sam,ou=company,o=com uidNumber: 7174 gidNumber: 49563 homeDirectory: /home/sam loginshell: /bin/bash uid: sam... (2 Replies)
Discussion started by: samgoober
2 Replies

9. Shell Programming and Scripting

Appending lines in a file

Hello, I have a file like: str1,"HEX"H,(39),info str2,"HEX"H,(854548),info str3,"HEX"H,'BGTOUR',info str4,"HEX"H,(534322),info str1,"HEX"H,,info str3,"HEX"H,'Landing',info str4,"HEX"H,'BG',info str1,"HEX"H,,info str3,"HEX"H,'Ay',info str1,"HEX"H,(27),info str2,"HEX"H,(854548),info... (2 Replies)
Discussion started by: apenkov
2 Replies

10. UNIX for Beginners Questions & Answers

Sed/awk join lines once pattern found

Hi all OS - RHEL6.4 I have input file -f1.txt I need to search line which starts with \Start and read next line till it gets blank line and join them all. I need to trim any trailing spaces for each line.So output.txt should be.. \Start\now\fine stepwatch this space for toolsends... (7 Replies)
Discussion started by: krsnadasa
7 Replies
SYSTEMD.TIME(7) 						   systemd.time 						   SYSTEMD.TIME(7)

NAME
systemd.time - Time and date specifications DESCRIPTION
In systemd, timestamps, time spans, and calendar events are displayed and may be specified in closely related syntaxes. DISPLAYING TIME SPANS
Time spans refer to time durations. On display, systemd will present time spans as a space-separated series of time values each suffixed by a time unit. 2h 30min All specified time values are meant to be added up. The above hence refers to 150 minutes. PARSING TIME SPANS
When parsing, systemd will accept the same time span syntax. Separating spaces may be omitted. The following time units are understood: o usec, us o msec, ms o seconds, second, sec, s o minutes, minute, min, m o hours, hour, hr, h o days, day, d o weeks, week, w o months, month o years, year, y If no time unit is specified, generally seconds are assumed, but some exceptions exist and are marked as such. In a few cases "ns", "nsec" is accepted too, where the granularity of the time span allows for this. Examples for valid time span specifications: 2 h 2hours 48hr 1y 12month 55s500ms 300ms20s 5day DISPLAYING TIMESTAMPS
Timestamps refer to specific, unique points in time. On display, systemd will format these in the local timezone as follows: Fri 2012-11-23 23:02:15 CET The weekday is printed according to the locale choice of the user. PARSING TIMESTAMPS
When parsing systemd will accept a similar timestamp syntax, but excluding any timezone specification (this limitation might be removed eventually). The weekday specification is optional, but when the weekday is specified it must either be in the abbreviated ("Wed") or non-abbreviated ("Wednesday") English language form (case does not matter), and is not subject to the locale choice of the user. Either the date, or the time part may be omitted, in which case the current date or 00:00:00, resp., is assumed. The seconds component of the time may also be omitted, in which case ":00" is assumed. Year numbers may be specified in full or may be abbreviated (omitting the century). A timestamp is considered invalid if a weekday is specified and the date does not actually match the specified day of the week. When parsing, systemd will also accept a few special placeholders instead of timestamps: "now" may be used to refer to the current time (or of the invocation of the command that is currently executed). "today", "yesterday", "tomorrow" refer to 00:00:00 of the current day, the day before or the next day, respectively. When parsing, systemd will also accept relative time specifications. A time span (see above) that is prefixed with "+" is evaluated to the current time plus the specified time span. Correspondingly, a time span that is prefixed with "-" is evaluated to the current time minus the specified time span. Instead of prefixing the time span with "-", it may also be suffixed with a space and the word "ago". Examples for valid timestamps and their normalized form (assuming the current time was 2012-11-23 18:15:22): Fri 2012-11-23 11:12:13 -> Fri 2012-11-23 11:12:13 2012-11-23 11:12:13 -> Fri 2012-11-23 11:12:13 2012-11-23 -> Fri 2012-11-23 00:00:00 12-11-23 -> Fri 2012-11-23 00:00:00 11:12:13 -> Fri 2012-11-23 11:12:13 11:12 -> Fri 2012-11-23 11:12:00 now -> Fri 2012-11-23 18:15:22 today -> Fri 2012-11-23 00:00:00 yesterday -> Fri 2012-11-22 00:00:00 tomorrow -> Fri 2012-11-24 00:00:00 +3h30min -> Fri 2012-11-23 21:45:22 -5s -> Fri 2012-11-23 18:15:17 11min ago -> Fri 2012-11-23 18:04:22 Note that timestamps printed by systemd will not be parsed correctly by systemd, as the timezone specification is not accepted, and printing timestamps is subject to locale settings for the weekday while parsing only accepts English weekday names. In some cases, systemd will display a relative timestamp (relative to the current time, or the time of invocation of the command) instead or in addition to an absolute timestamp as described above. A relative timestamp is formatted as follows: 2 months 5 days ago Note that any relative timestamp will also parse correctly where a timestamp is expected. (see above) CALENDAR EVENTS
Calendar events may be used to refer to one or more points in time in a single expression. They form a superset of the absolute timestamps explained above: Thu,Fri 2012-*-1,5 11:12:13 The above refers to 11:12:13 of the first or fifth day of any month of the year 2012, given that it is a Thursday or Friday. The weekday specification is optional. If specified, it should consist of one or more English language weekday names, either in the abbreviated (Wed) or non-abbreviated (Wednesday) form (case does not matter), separated by commas. Specifying two weekdays separated by "-" refers to a range of continuous weekdays. "," and "-" may be combined freely. In the date and time specifications, any component may be specified as "*" in which case any value will match. Alternatively, each component can be specified as a list of values separated by commas. Values may also be suffixed with "/" and a repetition value, which indicates that the value and all values plus multiples of the repetition value are matched. Either time or date specification may be omitted, in which case the current day and 00:00:00 is implied, respectively. If the second component is not specified, ":00" is assumed. Timezone names may not be specified. The special expressions "hourly", "daily", "monthly" and "weekly" may be used as calendar events which refer to "*-*-* *:00:00", "*-*-* 00:00:00", "*-*-01 00:00:00" and "Mon *-*-* 00:00:00", respectively. Examples for valid timestamps and their normalized form: Sat,Thu,Mon-Wed,Sat-Sun -> Mon-Thu,Sat,Sun *-*-* 00:00:00 Mon,Sun 12-*-* 2,1:23 -> Mon,Sun 2012-*-* 01,02:23:00 Wed *-1 -> Wed *-*-01 00:00:00 Wed-Wed,Wed *-1 -> Wed *-*-01 00:00:00 Wed, 17:48 -> Wed *-*-* 17:48:00 Wed-Sat,Tue 12-10-15 1:2:3 -> Tue-Sat 2012-10-15 01:02:03 *-*-7 0:0:0 -> *-*-07 00:00:00 10-15 -> *-10-15 00:00:00 monday *-12-* 17:00 -> Mon *-12-* 17:00:00 Mon,Fri *-*-3,1,2 *:30:45 -> Mon,Fri *-*-01,02,03 *:30:45 12,14,13,12:20,10,30 -> *-*-* 12,13,14:10,20,30:00 mon,fri *-1/2-1,3 *:30:45 -> Mon,Fri *-01/2-01,03 *:30:45 03-05 08:05:40 -> *-03-05 08:05:40 08:05:40 -> *-*-* 08:05:40 05:40 -> *-*-* 05:40:00 Sat,Sun 12-05 08:05:40 -> Sat,Sun *-12-05 08:05:40 Sat,Sun 08:05:40 -> Sat,Sun *-*-* 08:05:40 2003-03-05 05:40 -> 2003-03-05 05:40:00 2003-03-05 -> 2003-03-05 00:00:00 03-05 -> *-03-05 00:00:00 hourly -> *-*-* *:00:00 daily -> *-*-* 00:00:00 monthly -> *-*-01 00:00:00 weekly -> Mon *-*-* 00:00:00 *:2/3 -> *-*-* *:02/3:00 Calendar events are used by timer units, see systemd.timer(5) for details. SEE ALSO
systemd(1), journalctl(1), systemd.timer(5), systemd.unit(5), systemd.directives(7) systemd 208 SYSTEMD.TIME(7)
All times are GMT -4. The time now is 05:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy