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:
...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:
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
Thanks for the help. That script does write to line 1 so is a big help, however it bumps everything else down. I'm looking to append it to the existing line 1. Can I ask what your added code:
and
is doing?
Also, how would I put that script into a bash script, where the source/target file is referred to as $1? That's where I currently have all my sed statements, but it seemed to choke at the awk part, though it worked from the command line.
Thanks, very much
Last edited by Franklin52; 03-23-2011 at 11:11 AM..
Reason: Please use code tags
Do you mean this: ---------- Post updated at 07:53 PM ---------- Previous update was at 07:50 PM ----------
Quote:
Originally Posted by singerfc
hi yinyuemi,
Thanks for the help. That script does write to line 1 so is a big help, however it bumps everything else down. I'm looking to append it to the existing line 1. Can I ask what your added code:
That's it! It was printing to stout, so I added '> outputfile.txt' at the end, and I got a new file with the text appended correctly. Is there something I can do to append the results to the input file? I tried '>' to the input filename, but I lost most of the content.
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)
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)
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)
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)
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)
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)
: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)