Sponsored Content
Full Discussion: Need help joining lines
Top Forums Shell Programming and Scripting Need help joining lines Post 302386367 by rene21976 on Tuesday 12th of January 2010 09:36:15 AM
Old 01-12-2010
Quote:
Originally Posted by ahmad.diab
You can use gawk or /usr/xpg4/bin/awk instead of nawk.Smilie
Thanks,

Maybe you can help me with this one aswel. I finally generated a file which lookes like this:
Code:
01/11/2010 9:34:00.15 4.14
01/11/2010 9:39:00.14 7.66
01/11/2010 9:44:00.40 6.77
01/11/2010 9:49:00.20 7.80
01/11/2010 9:54:00.14 7.52
01/11/2010 9:59:02.16 8.95
01/11/2010 10:04:00.16 5.51
01/11/2010 10:09:00.26 7.31

The second column is the time. I need to adjust this so only hh:mm:ss is displayed. As you can see the last 3 chars are not always on the same place. I'm trying to eddit is with sed but I get stuck on the wildcards to use.

TIA

Last edited by Scott; 01-12-2010 at 11:48 AM.. Reason: Added code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Joining multiple lines

I have data of the following form. It starts its first line with a '{' and ends the last line with a '}'. What I need to do is to join every line starting with the '{' and ending with the '} into one line in the output file. If it was just this one block, I could do a 13 joins in vi, however it... (4 Replies)
Discussion started by: beilstwh
4 Replies

2. Shell Programming and Scripting

Joining 2 lines in a file together

Hi guys, I've got a log file which has entries that look like this: ------------------------------------------------------------------------------- 06/08/04 07:57:57 AMQ9002: Channel program started. EXPLANATION: Channel program 'INSCCPQ1.HSMTSPQ1' started. ACTION: None. ... (3 Replies)
Discussion started by: m223464
3 Replies

3. Shell Programming and Scripting

Joining 3 lines at a time

Hi, I have a file which has the contents as below : 07:38:36 EST date 20041117 07:39:06 EST 07:00:29 EDT date 20050504 07:25:16 EDT 07:00:40 EDT date 20050505 07:23:12 EDT I need to delete the new line character from all lines except 3rd,6th,9th etc. lines so that i get the output... (14 Replies)
Discussion started by: Sabari Nath S
14 Replies

4. Shell Programming and Scripting

Joining lines from two files - please help

Hello, I have 2 files say File 1 has ABC DEF GHI File 2 has 123 456 789 I need output as ABC 123 DEF 456 GHI 789 I tried awk and sed but not able to get it in the right way. :confused: Please help. Thanks (25 Replies)
Discussion started by: chandra004
25 Replies

5. Shell Programming and Scripting

joining two lines

Hi , I want to join two lines in a file, where the second line contain query string. if it doesn't contain that string i don't want to join e.g. Input file is as following: name fame game none none none name fame game cat eat mice I need output file as name fame game none none... (2 Replies)
Discussion started by: ashrafonics
2 Replies

6. Shell Programming and Scripting

pattern matching lines using the date, and then joining the lines

Hi Guys, Was trying to attempt the below using awk and sed, have no luck so far, so any help would be appreciated. Current Text File: The first line has got an "\n", and the second line has got spaces/tabs then the word and "\n" TIME SERVER/CLIENT TEXT... (6 Replies)
Discussion started by: eo29
6 Replies

7. Shell Programming and Scripting

awk joining lines

Hello, I'm trying to write a piece of code in awk, which should be able recognize by some regexps two lines and then join them together (maybe write them without \n would be enough, I don't know).. the thing is that every line in the file i'm working with starts with some number, for example: ... (4 Replies)
Discussion started by: midin
4 Replies

8. Shell Programming and Scripting

Joining lines in a file - help!

I'm looking for a way to join lines in a file; e.,g consider the following R|This is line 1 R|This is line 2 R|This is line 3 R|This is line 4 R|This is line 5 what i want to end up with is R|This is line 1 R|This is line 2 R|This is line 3 R|This is line 4 R|This is line 5 so... (15 Replies)
Discussion started by: Storms
15 Replies

9. Shell Programming and Scripting

Joining lines in different way

Hi all, I'm excited to the part of unix.com forum, and noob to it. I have an query, where I have an file and it contains data like this use thread when posting do no I was expecting the result as use thread thread when when posting posting do do no use thread when thread when... (6 Replies)
Discussion started by: Jose Nirmal
6 Replies

10. Shell Programming and Scripting

Joining broken lines and removing empty lines

Hi - I have req to join broken lines and remove empty lines but should NOT be in one line. It has to be as is line by line. The challenge here is there is no end of line/start of line char. thanks in advance Source:- 2003-04-34024|04-10-2003|Claims|Claim|01-13-2003|Air Bag:Driver;... (7 Replies)
Discussion started by: Jackceasar123
7 Replies
Sys::Filesystem::Netbsd(3pm)				User Contributed Perl Documentation			      Sys::Filesystem::Netbsd(3pm)

NAME
Sys::Filesystem::Netbsd - Return NetBSD filesystem information to Sys::Filesystem SYNOPSIS
See Sys::Filesystem. INHERITANCE
Sys::Filesystem::Netbsd ISA Sys::Filesystem::Unix ISA UNIVERSAL METHODS
version () Return the version of the (sub)module. ATTRIBUTES
The following is a list of filesystem properties which may be queried as methods through the parent Sys::Filesystem object. fs_spec Describes the block special device or remote filesystem to be mounted. fs_file Describes the mount point for the filesystem. For swap partitions, this field should be specified as none. If the name of the mount point contains spaces these can be escaped as 40. fs_vfstype Dscribes the type of the filesystem. fs_mntops Describes the mount options associated with the filesystem. fs_freq Used for these filesystems by the dump(8) command to determine which filesystems need to be dumped. fs_passno Used by the fsck(8) program to determine the order in which filesystem checks are done at reboot time. VERSION
$Id: Netbsd.pm 128 2010-05-12 13:16:44Z trevor $ AUTHOR
Jens Rehsack <rehsack@cpan.org> - <http://www.rehsack.de/> COPYRIGHT
Copyright 2009,2010 Jens Rehsack. This software is licensed under The Apache Software License, Version 2.0. <http://www.apache.org/licenses/LICENSE-2.0> perl v5.10.1 2010-05-18 Sys::Filesystem::Netbsd(3pm)
All times are GMT -4. The time now is 09:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy