Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Insert line dynamically in a file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Insert line dynamically in a file
# 1  
Old 10-15-2013
Insert line dynamically in a file
Hi,

I have a file which have several lines that ordered alphabetically. Each line is a tab-separated

Something like:

Code:
ABC_XX 12
BCC_XX 24
CDD_CC 12
::::::::::::
::::::::::::
PDD_EE 12
RXX_DD 24
::::::::::::
::::::::::::

Now i need to add the following lines
PXX_FF 36
PYY_GG 36
PZZ_HH 36

after the line that has the last occurrence of P as a start


So, in this case the file would look like
Code:
ABC_XX 12
BCC_XX 24
CDD_CC 12
::::::::::::
::::::::::::
PDD_EE 12
PXX_FF 36
PYY_GG 36
PZZ_HH 36
RXX_DD 24
::::::::::::
::::::::::::

Please NOTE that each key-value above is tab-separated
# 2  
Old 10-16-2013
Try this

Code:
$ sort -t$'\t' infile - > outfile <<EOF
> PXX_FF    36
> PYY_GG    36
> PZZ_HH    36
> EOF

$ cat outfile
ABC_XX   12
BCC_XX   24
CDD_CC   12
::::::::::::
::::::::::::
PDD_EE   12
PXX_FF   36
PYY_GG   36
PZZ_HH   36
RXX_DD   24
::::::::::::
::::::::::::

This User Gave Thanks to Chubler_XL For This Post:
rbatte1
# 3  
Old 10-16-2013
Thank you much!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Insert a line of text on nth line of a file

Hi All, I am using UNix Sun OS sun4u sparc SUNW,SPARC-Enterprise My intention is to insert a line of text after 13th line of every file inside a particular directory. While trying to do it for a single file , i am using sed sed '3 i this is the 4th line' filename sed: command garbled: 3... (5 Replies)
Discussion started by: gotamp
5 Replies

2. Shell Programming and Scripting

How to read a text file line by line and insert into a database table?

I have a test file that I want to read and insert only certain lines into the the table based on a filter. 1. Rread the log file 12 Hours back Getdate() -12 Hours 2. Extract the following information on for lines that say "DUMP is complete" A. Date B. Database Name C.... (2 Replies)
Discussion started by: JolietJake
2 Replies

3. Shell Programming and Scripting

Insert a line in a file by deleting that line from another file

Hi all, I have a huge file(size more that 5GB). I want to do some manupulation with the records and write to another file. As the size of the file is huge and there is a space constraint in that directory, I want to delete that record from first file after writing it in to second file.... (3 Replies)
Discussion started by: gani_85
3 Replies

4. Shell Programming and Scripting

Insert a new line before every 5th line in a file

Hi, I need to insert a new line containing the string "QUERY" above every 5 lines. The below piece of code inserts a new line after every 5th line awk '{print $0} !(NR%5) {print "QUERY"}' sed 'n;n;n;n;G;' --> I do not know how to give "QUERY" string here But I need to insert it before... (4 Replies)
Discussion started by: royalibrahim
4 Replies

5. Programming

insert line into a file

how to insert a line of text that is next to the current line(file pointer pointing to) in the file ?? :wall: ex: suppose a file named 'Sample' has the following content in it. this is to give clear idea about the problem if file pointer is pointing to the first line then i want to... (3 Replies)
Discussion started by: kavitha rao
3 Replies

6. Shell Programming and Scripting

displaying nth line of a file dynamically

Hi, I have a file split.txt with the following contents one two three four five Suppose if i want to display contents of line 3, I know this could be achieved using the command sed -n '3p' split.txt But I need the line number to be decided dynamically like a=3 sed -n '$ap'... (2 Replies)
Discussion started by: deanamrita
2 Replies

7. UNIX for Advanced & Expert Users

help with insert line into file

hi..i wanted to know is there any way to take input from the user and copy that a particular line number in a particular file for eg . i wanted to create acl in squid at line number 2400 in squid.conf file so the user gives an input like acl inetblock src 192.168.0.0/255.255.0.0 so is there... (4 Replies)
Discussion started by: tarunicon
4 Replies

8. Shell Programming and Scripting

Insert line into file

Hi, My File 'temp.txt' contents are like this. <Managers> Mng={{FIL|FAVEI.mng|111}|15.000000|17.000000|17.000000| Mng={{FIL|FAPSV.mng|222}|3.000000|0.000000|0.000000|0.000000| Mng={{FIL|FAVIF.mng|333}|8.000000|8.000000|8.000000|8.000000|... (3 Replies)
Discussion started by: vinay123
3 Replies

9. Shell Programming and Scripting

insert a line in a file

Hello guys, Need to know how to insert a line at top of the file, without using temp files. Can we do it on the fly? Regards, Rishi (7 Replies)
Discussion started by: RishiPahuja
7 Replies

10. UNIX for Advanced & Expert Users

Insert a line as the first line into a very huge file

Hello, I need to insert a line (like a header) as the first line of a very huge file (about 3 ml rows). I am able to do it with sed, but redirecting the output and creating a new file takes quite some time. I was wondering if there was a more efficient way of doing it? Any help would be... (3 Replies)
Discussion started by: shriek
3 Replies
Login or Register to Ask a Question