Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Inserting Delimiters
Top Forums Shell Programming and Scripting Inserting Delimiters Post 302896871 by Akshay Hegde on Wednesday 9th of April 2014 02:52:23 PM
Old 04-09-2014
Quote:
Originally Posted by rakesh_411
Thanks Akshay for the code , Apologies for not mentioning the delimeter but you had it right pipe delimiter is the one which I thought as well .
Also I think I got confused with my input and output .

Code:
Mar 18 13:16:10 machinename string
Mar 18 13:17:08 machinename string 1 string2 string 3
Mar 18 13:18:16 machinename string 1 string2 string 3 string 4

Desired output
Code:
 
 
Mar 18 |  13:16:10 | machinename | string
Mar 18 | 13:17:08 | machinename |  string 1  string2  string 3
Mar 18 13:18:16 machinename |  string 1  string2  string 3  string 4

The strings need not be delimiter with | . Apologies for confusion .
Third line pipe is missing, if you are expecting following o/p use this code

Code:
$ cat f
Mar 18 13:16:10 machinename string
Mar 18 13:17:08 machinename string 1 string2 string 3
Mar 18 13:18:16 machinename string 1 string2 string 3 string 4

$ awk '{s=x;for(i=1;i<=NF;i++){ s = s ? s (i ==2 || i > 5 ? " " : " | ") $i : $i } $0 = s}1' f
Mar 18 | 13:16:10 | machinename | string
Mar 18 | 13:17:08 | machinename | string 1 string2 string 3
Mar 18 | 13:18:16 | machinename | string 1 string2 string 3 string 4

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delimiters missing

Hi I have a pipe-delimited file where I eventually need to replace a string stored on the 3th field on a specific record. This is how the file looks like: A|Mike|Lvl 1|... B|... A|Maria|Lvl 1|... C|... B|... A|Jimmy|Lvl 2|... C|... A|Carry|Lvl 0|... C|... B|... A|John|Lvl 8|...... (2 Replies)
Discussion started by: Indalecio
2 Replies

2. Solaris

To extract everything between two delimiters

My input file looks like " @$SCRIPT/atp_asrmt_adj.sql $SCRIPT/dba2000.scr -s / @$SCRIPT/cim1005w.pls $SCRIPT/dba2000.scr -s / @$SCRIPT/cim1006w.pls start $SCRIPT/cim1020d.sql;^M spool $DATA/cim1021m.sql @$DATA/cim1021m.sql ! rm $DATA/cim1021m.sql spool $DATA/cim1021m.sql... (1 Reply)
Discussion started by: dowsed4u8
1 Replies

3. Shell Programming and Scripting

Problems with delimiters

Hello, I have data in a file something like this - UNB+UNOA:1+006415160:1+AR0000012360:ZZ+080701:0552+2++DELFOR++++T'UNH+2+DELFOR:D:97A:UN Here, the delimiters used are + , : and ' . I have a set of such files in which these delimiters vary from one file to another. I am developing a... (4 Replies)
Discussion started by: The Observer
4 Replies

4. Shell Programming and Scripting

Two delimiters with AWK

Hello, this thread is more about scripting style than a specific issue. I've to grep from a output some lines and from them obtain a specific entry delimited by < and >. This is my way : 1) grep -i user list | awk '{FS="<";print $NF}' | sed -e 's/>//g' 2) grep -i user list | cut -d","... (10 Replies)
Discussion started by: gogol_bordello
10 Replies

5. Shell Programming and Scripting

Split using two delimiters

I'm trying to do a split using two delimiters. The first delimiter is ": " (or we could call it :\s). The second is "\n". How can or these delimiters so I can toss the values into an array without issue? I tried @array = split /:\s|\n/, $myvar; This doesn't seem to be working. Any an... (3 Replies)
Discussion started by: mrwatkin
3 Replies

6. Shell Programming and Scripting

Delimiters in awk

Line from input file a : b : c " d " e " f : g : h " i " j " k " l output k b a Its taking 7th word when " is the delimiter, 2nd and 1st word when : is the delimiter and returning all in one line.... I am on solaris Thanks..... (1 Reply)
Discussion started by: shekhar2010us
1 Replies

7. Shell Programming and Scripting

sort with different delimiters

I have a file with the following lines in it: Inbound1:remote - - 01/Nov/2011:08:29:51 -0500 "GET / HTTP/1.1" 404 2098 HTTP Inbound1:remote - - 02/Dec/2011:08:31:42 -0500 "GET / HTTP/1.1" 404 2098 HTTP Inbound3:remote - - 01/Oct/2011:08:29:52 -0500 "GET / HTTP/1.1" 404 2098 HTTP Inbound4:remote... (5 Replies)
Discussion started by: oldman2
5 Replies

8. Shell Programming and Scripting

Inserting additional comma delimiters in a csv file, after and before certian fields.

Hello I have a csv file which I need to insert addtional commas into. The csv is of the format field1,field2,field3,field4,...etc...,field13,field14 I need to add extra commas in each record so that the final output looks like ... (1 Reply)
Discussion started by: kamal_p_99
1 Replies

9. UNIX for Dummies Questions & Answers

delimiters used in UNIX

Can you point me to information on the different delimited in UNIX like colon, spaces and tabs? (1 Reply)
Discussion started by: momhef4
1 Replies

10. Shell Programming and Scripting

Delimiters with awk?

I have a file which is separated by delimiter "|", but the prob is one of my column do contain delimiter as description so how can i differentiate it? PS : the delmiter does have backslash coming before it, if occurring in column Annual|Beleagured|Desc|Denver... (2 Replies)
Discussion started by: nikhil jain
2 Replies

LEARN ABOUT DEBIAN

net::google::code::issue::attachment

Net::Google::Code::Issue::Attachment(3pm)		User Contributed Perl Documentation		 Net::Google::Code::Issue::Attachment(3pm)

NAME

       Net::Google::Code::Issue::Attachment - Issue's Attachment

DESCRIPTION

       This class represents a single attachment for an issue or an issue's comment.

INTERFACE

       parse( HTML::Element or [ HTML::Element, HTML::Element ] or html segment string )
	   there're 2 trs that represent an attachment like the following:

	    <tr><td rowspan="2" width="24"><a href="http://chromium.googlecode.com/issues/attachment?aid=-1323983749556004507&amp;name=proxy_settings.png" target="new"><img width="16" height="16" src="/hosting/images/generic.gif" border="0" ></a></td>
	    <td><b>proxy_settings.png</b></td></tr>
	    <tr><td>14.3 KB

	    <a href="http://chromium.googlecode.com/issues/attachment?aid=-1323983749556004507&amp;name=proxy_settings.png">Download</a></td></tr>

       parse_attachments( HTML::Element or html segment string )
	   given the <div class="attachments">...</div> or its equivalent HTML::Element object, return a list of Net::Google::Code::Attachment
	   objects.

       name
       content
       size
       url
       id
       content
       content_type

AUTHOR

       sunnavy	"<sunnavy@bestpractical.com>"

LICENCE AND COPYRIGHT

       Copyright 2008-2010 Best Practical Solutions.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.10.1							    2010-04-07				 Net::Google::Code::Issue::Attachment(3pm)
All times are GMT -4. The time now is 05:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy