Visit Our UNIX and Linux User Community


sed substitution


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sed substitution
# 1  
Old 07-21-2011
sed substitution

Hello,
I have two files. File1 is normal txt file and File2 contains list of line numbers.

e.g. File2:
Code:
3
6
9
.....

I need to replace a character in File1 in lines (taken from File2). For that I am using a "for" loop:
Code:
for i in $(cat File2)
do
  sed "$i s/Y/N/" File1
done

but my files contain million numbers and for loop is taking a long time. can I use a faster approach?

Thanks......

Last edited by Scott; 07-21-2011 at 03:57 PM.. Reason: Please use code tags, and a subject title that better reflects your problem
# 2  
Old 07-21-2011
You can try another way of reading "File2":
Code:
while read i; do
  sed "$i s/Y/N/" File1
done < File2

# 3  
Old 07-21-2011
I already tried but its slower than what I need....

I am trying to create a data file, which will look sonething like:
sed "3;6;9........ s/Y/N/" File1 (by running a for/while loop)
and then will execute this file..... hopefully this wud be faster....
# 4  
Old 07-21-2011
Code:
awk 'NR == FNR {
  nr[$1]; next
  }
NR in nr {
  sub(/Y/, "N")
  }1' file2 file1


Previous Thread | Next Thread
Test Your Knowledge in Computers #165
Difficulty: Easy
Tanenbaum originally developed MINIX for compatibility with Apple Computers.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed substitution

Hi everyone, I need very simple sed command to change a parameter in a text file. I have a line in this text which is like set xx 0.5 A program reads this file and does some algebraic calculations. So to make a parameter scan I need to change the value of xx. I thought I can do... (7 Replies)
Discussion started by: hayreter
7 Replies

2. UNIX for Dummies Questions & Answers

sed substitution

How can you use sed with a line of code that reads: 67899:Bill:Williams:Maple Dr.:45908600 Let us say we want to replace Maple Dr. with Oak St. (1 Reply)
Discussion started by: yonkers062986
1 Replies

3. Shell Programming and Scripting

Substitution with sed

I have a file with some numbers having single quotes around them which I want to remove. i.e. '923930' -> 23930 If it can be done without using sed thats fine. I have tried with sed but can't think how to replace this pattern on only the numbers (13 Replies)
Discussion started by: user_invalid
13 Replies

4. UNIX for Dummies Questions & Answers

Help with sed substitution

I'm a noob to unix, and I have a line of data like the following: title=Boston|tcolor=green|desc=Large city in New England|url=www.boston.com Is there a way to change a field value with sed substitution? (i.e. change tcolor=green to tcolor=blue) I figured out: sed... (19 Replies)
Discussion started by: stabby
19 Replies

5. Shell Programming and Scripting

sed substitution

Hi I am trying to do a text insertion in a text file at a particular line number in a shell script. However its not working. sed '122i\ > for j in \`echo $MyList\` ; do perl -pi -e\'s#01\/01\/2009#01\/01\/2011#\' $j ; done' $HOME/MyScript.ksh The Actual line to be inserted at line 122... (5 Replies)
Discussion started by: som.nitk
5 Replies

6. Shell Programming and Scripting

SED Substitution

Hi guys, Can u please help me to replace (-) with (/) in a file containing no of records using "sed " command in unix. thanks in advance. subhendu (5 Replies)
Discussion started by: subhendu81
5 Replies

7. Shell Programming and Scripting

SED Substitution

Hi , I am stuck up in the below scenario:- I need to read a file name (eg A.txt) name frm another file (eg B.txt) and then I need to search for a particular expression in A.txt and substitute it with another expression. How can I use SED inside SHELL Scripting and command prompt as well to... (1 Reply)
Discussion started by: shubhranshu
1 Replies

8. Shell Programming and Scripting

Substitution using SED

Hi , I am stuck up in the below scenario:- I need to read a file name (eg A.txt) name frm another file (eg B.txt) and then I need to search for a particular expression in A.txt and substitute it with another expression. How can I use SED inside SHELL Scripting and command prompt as... (2 Replies)
Discussion started by: shubhranshu
2 Replies

9. UNIX for Dummies Questions & Answers

sed substitution

Hi, I have a set of files containing strings like I.TEST1_TEST2 or B.ESSA_ESSB for example. Does somebody know how to substitute these strings whith the same name and an extension "_V1" (ie. I.TEST1_TEST2_V1) using sed command or else ? (3 Replies)
Discussion started by: jo_aze
3 Replies

10. UNIX for Dummies Questions & Answers

Substitution using sed

I know we can substitute a string using sed but how? For example: sed 's/(old variable)/(new variable)/ details.dat Am I suppose to put $old variable or whatever? Because I tried many times, it didnt work by putting $old variable. Am I suppose to enclose it with "" or ''? Please help (3 Replies)
Discussion started by: Ohji
3 Replies

Featured Tech Videos