Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Editing the first line of file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Editing the first line of file
# 1  
Old 09-08-2011
Error Editing the first line of file
I have a sample file as below :-

Code:
RECORD_COUNT|2660|28606946.86|20110701122349694|
adkad|wwsgesg|mkmk|FFFF|FAFAF|FFAF|FAFFFFA|5894858|

I have to replace the second coulmn in the first row which is the count of no of lines in the file from a new variable .

Also I have to delete the 3rd column in the first row which is the total amount of records in the file from a new variable .

Please help

Moderator's Comments:
Mod Comment Please use [code] and [/code] tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks.
Last edited by zaxxon; 09-08-2011 at 02:53 AM.. Reason: code tags, see PM
# 2  
Old 09-08-2011
Code:
awk -F"|" -v column2=123 -v column3=123 'NR==1{$2=column2;$3=column3}1' OFS="|" inputfile

If in solaris, use nawk.

--ahamed
# 3  
Old 09-08-2011
If i understand right:
Code:
a=123; sed '1{
s/|[0-9]*/|'"$a"'/ 
s/[^|]*|//3
}' INPUTFILE
RECORD_COUNT|123|20110701122349694|
adkad|wwsgesg|mkmk|FFFF|FAFAF|FFAF|FAFFFFA|5894858|

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Editing in vi - adding words to a line

i have lines in a file similar to this: results=$(echo Total: ${res} | command | command) now I need to add text before the word "results", but i dont know how to do it. here's what i tried: %s~results=.*echo Total:.* ${7}~PROCESS \; results=.*echo Total:.* ${7}~g the problem is,... (1 Reply)
Discussion started by: SkySmart
1 Replies

2. Shell Programming and Scripting

Editing the next line of the pattern

Hi All, I am trying to edit the next line when there is a success for a pattern. For example: <nvname>abc</nvname> <nvvalue>1</nvvalue> <nvname>def</nvname> <nvvalue>2</nvvalue> once there is a hit for the string "abc" the value of the nvvalue should be replaced with the value we... (5 Replies)
Discussion started by: pulgupta
5 Replies

3. Shell Programming and Scripting

editing single line in html file in perl script

Hi Folks, It is regarding the perl scripting. I have an html file(many files) which contains the below line in the body tag. <body> <P><STRONG><FONT face="comic sans ms,cursive,sans-serif"><EM>Hello</EM></FONT></STRONG></P> </body> Now I want to read that html file through perl... (3 Replies)
Discussion started by: giridhar276
3 Replies

4. Shell Programming and Scripting

editing line in text file adding number to value in file

I have a text file that has data like: Data "12345#22" Fred ID 12345 Age 45 Wilma Dino Data "123#22" Tarzan ID 123 Age 33 Jane I need to figure out a way of adding 1,000,000 to the specific lines (always same format) in the file, so it becomes: Data "1012345#22" Fred ID... (16 Replies)
Discussion started by: say170
16 Replies

5. UNIX for Dummies Questions & Answers

Help with editing 2nd line after match

Hi All I would like to break down each next line that matches SK1.chr* in this case NNNNNN.... into 100 characters each after SK1.chr*... (3 Replies)
Discussion started by: pawannoel
3 Replies

6. UNIX for Dummies Questions & Answers

Line editing

I have some trouble editing a line. My aim is to edit the first line of a file.It will look the code and if there are dummy characters at the begininng of line before < it will erase. It is a php code.For instance: for instance if the first line is like %^<?php>sadsa</php>, it will change it to... (6 Replies)
Discussion started by: king87
6 Replies

7. Shell Programming and Scripting

awk line editing

Hello I am trying to make an awk script that always replaces the same characters in a file, with white space in between. Can anyone write a script that prompts for the 3 numbers and then replaces them in the file? eg. enter a b c: 'it then puts a b c in the file. The file format is always ... (12 Replies)
Discussion started by: gav2251
12 Replies

8. Shell Programming and Scripting

Single line file editing command?

Hello everyone. I have been reading a lot about the various different text editors at my disposal through Unix, but I just can't seem to close the deal for what I am trying to do. Is there a way to issue a single line command to edit a file where pattern=x, and do it non-destructively AND in-place?... (1 Reply)
Discussion started by: gator76
1 Replies

9. Shell Programming and Scripting

SED - editing file names (End of line problem?)

For lists in sed, to say what to replace, is this correct: I am hoping that this would recognise that either a "." is present, or that the substitution happens at the end of the line. For files with extensions , my script works perfectly. My problem is, files without extentions, i.e. . ... (1 Reply)
Discussion started by: busillis
1 Replies

10. Shell Programming and Scripting

Editing last line of a file

Hi All, Could you please help me out with this problem? I need to edit the last line of my file. Ex: The last line in my file will be say 000056000045 8 I need to subtract some number from the number 45 and replace the new number in its place. ... (1 Reply)
Discussion started by: Anitha Chandran
1 Replies
Login or Register to Ask a Question