Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk/Sed - appending within file
Top Forums Shell Programming and Scripting Awk/Sed - appending within file Post 302506733 by singerfc on Monday 21st of March 2011 08:11:51 PM
Old 03-21-2011
Awk/Sed - appending within file
hello all,

First time post here. I have searched a bit but could not find an exact answer. I have about a week's experience of Sed and Awk, and am having fun, but am a little stuck.

I am reformatting an xml file into json format. I have got this far:
Code:
{"clients":[
"articles":[
"File_URL":"http://url.com/a/123",
"pub_date":"2011-03-11",
"publication":"Irish Times",
"publication_type":"D",
"headline":"Something happening somewhere",
"page":"9",
"circulation":"0105742.0000",
"area":"83330.00",
"author":"John Doe",
"last_edited":"2011-03-11 05:33:25",
"client":"Company Ltd",
"client":"MegaCorp plc",
"client":"Dept of Departments",

...and so on. What I want is to append the client names up to line 1, then close it off with '],' to follow the correct json structure. I have the following awk script:
Code:
BEGIN {
    clientlist = ""
    FS=":"
}
/\"client\"/ { clientlist = clientlist $2 }
END { print clientlist }

which prints exactly what I need to standard output, but I don't know how to append it to line 1 within the file. I also don't know whether I would be better off using sed for this part of the process (I have a bash script with a number of sed statements that process the file up to this point).

I am enjoying learning sed and awk very much but unfortunately time is not on my side.

Any help much appreciated.
Last edited by Franklin52; 03-23-2011 at 11:11 AM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SED Question -- on appending to a file

:confused: I have a script that Cats a flat database file which contains 12 columns into sed. I want to add a 13th column which includes " ,2005-08-29 " * The date needs to be the current date. This 13th column would be appended to the end of each line. Does anyone have a clue... (5 Replies)
Discussion started by: Redg
5 Replies

2. Shell Programming and Scripting

Appending string to xml file using "sed"

Hi folks, Following a section in opmn.xml file: </process-type> <process-type id="OC4J_RiGHTv_IRD1" module-id="OC4J"> <environment> <variable id="LD_LIBRARY_PATH" value="/home/ias/v10.1.2/lib" append="true"/> <variable id="SHLIB_PATH"... (2 Replies)
Discussion started by: nir_s
2 Replies

3. Shell Programming and Scripting

appending to sed output of one file into the middle of file

hi, i have a file file1 file2 ----------- ----------------- aa bbb ccc 111 1111 1111 ddd eee fff 222 3333 4444 ggg hhh... (5 Replies)
Discussion started by: go4desperado
5 Replies

4. Shell Programming and Scripting

appending and sed

Hello, I want to add string #REAL at the end of all lines that contain real numbers. How to do this using sed ? (1 Reply)
Discussion started by: scotty_123
1 Replies

5. UNIX for Dummies Questions & Answers

SED or AWK: Appending a line Identifier that changes with paragraph?

Have another question that has been eluding me all day. I have data file I'm trying to reformat so that each line is appended with an ID code, but the ID code needs to update as it searches through the file. I.e. ----Begin Original Datafile----- Condition = XXX Header Line 1 Header... (1 Reply)
Discussion started by: selkirk
1 Replies

6. Shell Programming and Scripting

appending a file using sed in ksh

i am trying to append a 5 line SGML file(file1) with a 500,000 line SGML file (file2). file1 is a template, so i wish to preserve. i only want to add lines 5 to the end of file2. i have: cp file1 temp1 sed -n '5,$p' file2 >> temp1 when i check the tail of temp1, i consistantly find the... (3 Replies)
Discussion started by: smac
3 Replies

7. Shell Programming and Scripting

awk;sed appending line to previous line....

I know this has been asked before but I just can't parse the syntax as explained. I have a set of files that has user information spread out over two lines that I wish to merge into one: User1NameLast User1NameFirst User1Address E-Mail:User1email User2NameLast User2NameFirst User2Address... (11 Replies)
Discussion started by: walkerwheeler
11 Replies

8. Shell Programming and Scripting

Appending string (charachters inside the line) to a fixed width file using awk or sed

Source File: abcdefghijklmnop01qrstuvwxyz abcdefghijklmnop02qrstuvwxyz abcdefghijklmnop03qrstuvwxyz abcdefghijklmnop04qrstuvwxyz abcdefghijklmnop05qrstuvwxyz Whatever characters are in 17-18 on each line of the file, it should be concatenated to the same line at the character number... (6 Replies)
Discussion started by: tamahomekarasu
6 Replies

9. UNIX for Dummies Questions & Answers

Appending columns at the end of output using awk/sed

Hi , I have the below ouput, =====gopi===== assasassaa adsadsadsdsada asdsadsadasdsa sadasdsadsd =====kannan=== asdasdasd sadasddsaasd adasdd =====hbk=== asasasssa .... .. I want the output like as below, not able paste here correctly. (2 Replies)
Discussion started by: eeegopikannan
2 Replies

10. Shell Programming and Scripting

Reading and appending a row from file1 to file2 using awk or sed

Hi, I wanted to add each row of file2.txt to entire length of file1.txt given the sample data below and save it as new file. Any idea how to efficiently do it. Thank you for any help. input file file1.txt file2.txt 140 30 200006 141 32 140 32 200006 142 33 140 35 200006 142... (5 Replies)
Discussion started by: ida1215
5 Replies

LEARN ABOUT CENTOS

datetime::locale::tn_za

DateTime::Locale::tn_ZA(3)				User Contributed Perl Documentation				DateTime::Locale::tn_ZA(3)

NAME

       DateTime::Locale::tn_ZA

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'tn_ZA' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Tswana South Africa.

DATA

       This locale inherits from the DateTime::Locale::tn locale.

       It contains the following data.

   Days
       Wide (format)

	 Mosopulogo
	 Labobedi
	 Laboraro
	 Labone
	 Labotlhano
	 Matlhatso
	 Tshipi

       Abbreviated (format)

	 Mos
	 Bed
	 Rar
	 Ne
	 Tla
	 Mat
	 Tsh

       Narrow (format)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

       Wide (stand-alone)

	 Mosopulogo
	 Labobedi
	 Laboraro
	 Labone
	 Labotlhano
	 Matlhatso
	 Tshipi

       Abbreviated (stand-alone)

	 Mos
	 Bed
	 Rar
	 Ne
	 Tla
	 Mat
	 Tsh

       Narrow (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

   Months
       Wide (format)

	 Ferikgong
	 Tlhakole
	 Mopitlo
	 Moranang
	 Motsheganang
	 Seetebosigo
	 Phukwi
	 Phatwe
	 Lwetse
	 Diphalane
	 Ngwanatsele
	 Sedimonthole

       Abbreviated (format)

	 Fer
	 Tlh
	 Mop
	 Mor
	 Mot
	 See
	 Phu
	 Pha
	 Lwe
	 Dip
	 Ngw
	 Sed

       Narrow (format)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

       Wide (stand-alone)

	 Ferikgong
	 Tlhakole
	 Mopitlo
	 Moranang
	 Motsheganang
	 Seetebosigo
	 Phukwi
	 Phatwe
	 Lwetse
	 Diphalane
	 Ngwanatsele
	 Sedimonthole

       Abbreviated (stand-alone)

	 Fer
	 Tlh
	 Mop
	 Mor
	 Mot
	 See
	 Phu
	 Pha
	 Lwe
	 Dip
	 Ngw
	 Sed

       Narrow (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

   Quarters
       Wide (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BC
	 AD

       Abbreviated

	 BC
	 AD

       Narrow

	 BC
	 AD

   Date Formats
       Full

	  2008-02-05T18:30:30 = Labobedi, 2008 Tlhakole 05
	  1995-12-22T09:05:02 = Labotlhano, 1995 Sedimonthole 22
	 -0010-09-15T04:44:23 = Matlhatso, -10 Lwetse 15

       Long

	  2008-02-05T18:30:30 = 2008 Tlhakole 5
	  1995-12-22T09:05:02 = 1995 Sedimonthole 22
	 -0010-09-15T04:44:23 = -10 Lwetse 15

       Medium

	  2008-02-05T18:30:30 = 2008 Tlh 5
	  1995-12-22T09:05:02 = 1995 Sed 22
	 -0010-09-15T04:44:23 = -10 Lwe 15

       Short

	  2008-02-05T18:30:30 = 08/02/05
	  1995-12-22T09:05:02 = 95/12/22
	 -0010-09-15T04:44:23 = -10/09/15

       Default

	  2008-02-05T18:30:30 = 2008 Tlh 5
	  1995-12-22T09:05:02 = 1995 Sed 22
	 -0010-09-15T04:44:23 = -10 Lwe 15

   Time Formats
       Full

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       Short

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       Default

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = Labobedi, 2008 Tlhakole 05 18:30:30 UTC
	  1995-12-22T09:05:02 = Labotlhano, 1995 Sedimonthole 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = Matlhatso, -10 Lwetse 15 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 2008 Tlhakole 5 18:30:30 UTC
	  1995-12-22T09:05:02 = 1995 Sedimonthole 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = -10 Lwetse 15 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 2008 Tlh 5 18:30:30
	  1995-12-22T09:05:02 = 1995 Sed 22 09:05:02
	 -0010-09-15T04:44:23 = -10 Lwe 15 04:44:23

       Short

	  2008-02-05T18:30:30 = 08/02/05 18:30
	  1995-12-22T09:05:02 = 95/12/22 09:05
	 -0010-09-15T04:44:23 = -10/09/15 04:44

       Default

	  2008-02-05T18:30:30 = 2008 Tlh 5 18:30:30
	  1995-12-22T09:05:02 = 1995 Sed 22 09:05:02
	 -0010-09-15T04:44:23 = -10 Lwe 15 04:44:23

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 Bed
	  1995-12-22T09:05:02 = 22 Tla
	 -0010-09-15T04:44:23 = 15 Mat

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 PM
	  1995-12-22T09:05:02 = 9:05 AM
	 -0010-09-15T04:44:23 = 4:44 AM

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 PM
	  1995-12-22T09:05:02 = 9:05:02 AM
	 -0010-09-15T04:44:23 = 4:44:23 AM

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = Bed, 2-5
	  1995-12-22T09:05:02 = Tla, 12-22
	 -0010-09-15T04:44:23 = Mat, 9-15

       MMM (LLL)

	  2008-02-05T18:30:30 = Tlh
	  1995-12-22T09:05:02 = Sed
	 -0010-09-15T04:44:23 = Lwe

       MMMd (MMM d)

	  2008-02-05T18:30:30 = Tlh 5
	  1995-12-22T09:05:02 = Sed 22
	 -0010-09-15T04:44:23 = Lwe 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = Bed Tlh 5
	  1995-12-22T09:05:02 = Tla Sed 22
	 -0010-09-15T04:44:23 = Mat Lwe 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = Tlhakole 5
	  1995-12-22T09:05:02 = Sedimonthole 22
	 -0010-09-15T04:44:23 = Lwetse 15

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = Bed Tlhakole 5
	  1995-12-22T09:05:02 = Tla Sedimonthole 22
	 -0010-09-15T04:44:23 = Mat Lwetse 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = Bed, 2008-2-5
	  1995-12-22T09:05:02 = Tla, 1995-12-22
	 -0010-09-15T04:44:23 = Mat, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 Tlh
	  1995-12-22T09:05:02 = 1995 Sed
	 -0010-09-15T04:44:23 = -10 Lwe

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = Bed, 2008 Tlh 5
	  1995-12-22T09:05:02 = Tla, 1995 Sed 22
	 -0010-09-15T04:44:23 = Mat, -10 Lwe 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 Tlhakole
	  1995-12-22T09:05:02 = 1995 Sedimonthole
	 -0010-09-15T04:44:23 = -10 Lwetse

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

   Miscellaneous
       Prefers 24 hour time?

       Yes

       Local first day of the week

       Mosopulogo

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.16.3							    2014-06-10						DateTime::Locale::tn_ZA(3)
All times are GMT -4. The time now is 03:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy