Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Search and replace in file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Search and replace in file
# 8  
Old 10-05-2016
Thanks A lot guy's that's look great..
I hope i can be like you in codingSmilie..

---------- Post updated 10-05-16 at 10:19 AM ---------- Previous update was 10-04-16 at 10:13 PM ----------

hi, Thanks for quick reply,
but when i ran this script it is only showing node name but not the corresponding values.


Code:
root@jk:/home/testscript# awk 'NF==25{printf $1;for(i=2;i<26;i++){if($i == 0) printf " %02d",i-2};print ""}' remaining    
JKSJM01
JKMSC1
SRIMSC3
SRIMSC2
SRGMSC1
JKGJM01
HRSAM02
JKSSR01

and also this is not working in solaris ,where only bash script can be run. Please help!
# 9  
Old 10-05-2016
Are you sure NF == 25 in your input file? You better rely on the NF variable. Try
Code:
awk 'NR > 4 {printf "%s", $1; for (i=2; i<=NF; i++) if (!$i) printf " %02d", i-2; printf RS}' file
JKSJM01 11 23 24 25
JKMSC1 08 23 24 25
SRIMSC3 06 23 24 25
SRIMSC2 23 24 25
SRGMSC1 23 24 25
JKGJM01 23 24 25
HRSAM02 23 24 25

Last edited by RudiC; 10-05-2016 at 12:37 PM..
# 10  
Old 10-05-2016
Quote:
Originally Posted by sunnu2u86
Thanks A lot guy's that's look great..
I hope i can be like you in codingSmilie..

---------- Post updated 10-05-16 at 10:19 AM ---------- Previous update was 10-04-16 at 10:13 PM ----------

hi, Thanks for quick reply,
but when i ran this script it is only showing node name but not the corresponding values.


Code:
root@jk:/home/testscript# awk 'NF==25{printf $1;for(i=2;i<26;i++){if($i == 0) printf " %02d",i-2};print ""}' remaining    
JKSJM01
JKMSC1
SRIMSC3
SRIMSC2
SRGMSC1
JKGJM01
HRSAM02
JKSSR01

and also this is not working in solaris ,where only bash script can be run. Please help!
NF == 25 stands for Number of Fields = 25.
This is just a filter to avoid processing the header of the file as given in your initial sample ( and mine : node.tmp ) .

The code should run on any ksh , bash ,hpux, solaris and so on :this is very generic.
This behaviour occurs because the 00 are not recognized .
See my attached file (zerocount.sh ) : it's a script that creates the sample input file and processes it.
zerocount.sh (1.0 KB) 
Last edited by blastit.fr; 10-05-2016 at 05:17 PM.. Reason: typo
# 11  
Old 10-05-2016
yes NR == 25

Code:
root@11x:/home/testscript# awk '{print NF ,$1}' remaining 

25 JKSJM01
25 JKMSC1
25 SRIMSC3
25 SRIMSC2
25 SRGMSC1
25 JKGJM01
25 HRSAM02
25 JKSSR01
25 HRSAM01

Last edited by Don Cragun; 10-05-2016 at 06:21 PM.. Reason: Fix CODE tag.
# 12  
Old 10-05-2016
@sunnu2u86
As explained, this behaviour happens because of your input file .
It seemes you didn't even try my sample script .
# 13  
Old 10-05-2016
hi

yes it did work perfectly, actually the problem is with the script from which the output file is generated,i corrected the script that works great..

and sorry for the trouble i made.

Thanks Guys, you Rock..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Search and Replace in a new FILE.

Hi, more data.txt more srstring.sh input="data.txt" while IFS= read -r var do startdirectory=$loc search=$(echo $var | awk -F'=' '{print $1}') replace=$(echo $var | awk -F'=' '{print $2}') find "/tmp/config" -type f -exec grep -l "$search" {} + | while read file do if sed -e... (9 Replies)
Discussion started by: mohtashims
9 Replies

2. Shell Programming and Scripting

Nested search in a file and replace the inner search

Hi Team, I am new to unix, please help me in this. I have a file named properties. The content of the file is : ##Mobile props east.url=https://qa.east.corp.com/prop/end west.url=https://qa.west.corp.com/prop/end south.url=https://qa.south.corp.com/prop/end... (2 Replies)
Discussion started by: tolearn
2 Replies

3. Shell Programming and Scripting

Search for a string in a file and replace

I have file t1.log Contents of t1.log file Number of records processed: Number of records rejected: Error : xyz .......... abc .......... aaa _] start time : end time : Please let me know how i can remove the contents highlighted in red in the t1.log file. Thanks Sam (3 Replies)
Discussion started by: sam777
3 Replies

4. Emergency UNIX and Linux Support

Search and replace in text file

Hi, I have gigabytes of text files that I need to search for "&" and replace with "&amp". Is there a way to do this efficiently (like sed command)? Hope you could help. Thanks. (17 Replies)
Discussion started by: daytripper1021
17 Replies

5. Shell Programming and Scripting

Optimised way for search & replace a value on one line in a very huge file (File Size is 24 GB).

Hi Experts, I had to edit (a particular value) in header line of a very huge file so for that i wanted to search & replace a particular value on a file which was of 24 GB in Size. I managed to do it but it took long time to complete. Can anyone please tell me how can we do it in a optimised... (7 Replies)
Discussion started by: manishkomar007
7 Replies

6. Shell Programming and Scripting

Help on search and replace in a file

Hi all, The operating system is Solaris 10 I have example line here below I need to change the stat1 to stat2 using a shell script. search for space(" ") and replace with "\ " Stat1 --- /data/Sat Night Stay.txt Stat2 --- /data/Sat\ Night\ Stay.txt Thanks Firestar. (1 Reply)
Discussion started by: firestar
1 Replies

7. UNIX for Advanced & Expert Users

search and replace in a file

I have a file (say file1.txt) and I have to search for a line which has a text replace it and replace another string too in the same line. Eg: file1.txt -------- x='hai' y='world' z='unix' x='hai' y='world' x='hai' z='perl' y='world' z="world" k="junk" b="world" z='perl' x='hai'... (3 Replies)
Discussion started by: ammu
3 Replies

8. Shell Programming and Scripting

search and replace in a file

Hi I have to search & replace column in the file.For example ..below iam having File1. in which 3rd column ...if it is A it should be 'ACT' if P it should be 'PAD' and if it ils D it should be 'DEC' I have to pass column no ,value and to be converted value as variables in to the... (2 Replies)
Discussion started by: satyam_sat
2 Replies

9. Shell Programming and Scripting

Search and replace in file..

Hi All, As I'm working on a Unix script... and the requirement is like, I need to search a word and replace it with the another word... for that i'm using SED command.... can anybody give any other alternate for this...? Thanks Amit (2 Replies)
Discussion started by: Amits
2 Replies

10. UNIX for Dummies Questions & Answers

Search and replace in file

Hi guys, I have one file with duplicate string. I want to replace all the occurance of that string with some other string. How can I do that in vi editor? Malay Maru (3 Replies)
Discussion started by: malaymaru
3 Replies
Login or Register to Ask a Question