Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Replacing some part of file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Replacing some part of file
# 8  
Old 01-18-2010
Quote:
Originally Posted by atlantis
Hi Franklin,

I think I did not explain it clearly in my previous post. Now for example consider the file2 content as

RMR*CO*206Z130004706B**199.93
NTE*OTH*ACCT#J-445-294-1748 366N
DTM*003*091201

and the file1 content as

GS*RA*071000013*102562451P*091130*0520*334052023*X*003050
ST*820*334052023
BPR*C*509.77*C*ACH*CTX*01*071000013*DA*5529085*9000002008**01*071000013*DA*5529085*091130
NTE*ZZZ*QWEST80217E
REF*PY*A97983
REF*TN*081000602100305*TRACE NUMBER FROM THE ACH PAYMENT
DTM*020*091127
N1*PR*CIS INFO. VEND.*ZZ*PAYER FROM ACH
ENT*1*AG*94*CASS
N1*BT*AT&T MOBILITY
RMR*IV*206Z130004706B**214.93
NTE*OTH*ACCT#J-520-294-1749 877M
DTM*003*091101
RMR*IV*503Z130027168B**294.84
NTE*OTH*ACCT#J-644-294-1659 877M
DTM*003*091018
RMR*IV*456Z130027123C**294.84
SE*000014*334052023
GE*1*334052023

Here some content are highlighted in red. We can find the same lines in file2. I want the highlighted 3 lines in file1 to be replaced with content from file2 like

GS*RA*071000013*102562451P*091130*0520*334052023*X*003050
ST*820*334052023
BPR*C*509.77*C*ACH*CTX*01*071000013*DA*5529085*9000002008**01*071000013*DA*5529085*091130
NTE*ZZZ*QWEST80217E
REF*PY*A97983
REF*TN*081000602100305*TRACE NUMBER FROM THE ACH PAYMENT
DTM*020*091127
N1*PR*CIS INFO. VEND.*ZZ*PAYER FROM ACH
ENT*1*AG*94*CASS
N1*BT*AT&T MOBILITY
RMR*CO*206Z130004706B**199.93
NTE*OTH*ACCT#J-445-294-1748 366N
DTM*003*091201
RMR*IV*503Z130027168B**294.84
NTE*OTH*ACCT#J-644-294-1659 877M
DTM*003*091018
RMR*IV*456Z130027123C**294.84
SE*000014*334052023
GE*1*334052023

Sorry for the confusion from my side. Please advice.

Thanks!
my code is solving this issue try it with gawk or awk instead of nawk
# 9  
Old 01-18-2010
Do you have only 1 section (3 lines) in file2?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replacing part of a delimited string

Hello, I have some tab delimited text data that I am processing. The second column looks like, NAME;pyrimidine-2,4-diol;cpd;2;line;37 I need to clean this up to just the name, pyrimidine-2,4-diol All lines have the same format, NAME;text;cpd;int;line;int followed by tab I have tried... (6 Replies)
Discussion started by: LMHmedchem
6 Replies

2. UNIX for Dummies Questions & Answers

Replacing part of filename

Hi guys! I have quite a lot of files like all_10001_ct1212307460308.alf* and I want to get rid of the first number for all at once like: all_ct1212307460308.alf* How can I do this in the shell? (12 Replies)
Discussion started by: TimmyTiz
12 Replies

3. Shell Programming and Scripting

Renaming Filenames by replacing a part

Hi, I have little experience on Shell scripts, I searched the forum but couldn't make out what I want. I want to rename a set of files to a new file name a_b_20100101 c_d_20100101 ....................... ...................... I want to rename the files to a_b_20140101... (5 Replies)
Discussion started by: JaisonJ
5 Replies

4. Shell Programming and Scripting

Replacing part of the sentence using echo and sed

Hi, Iam using ksh and trying to execute the following syntax to replace one word of the sentence with a new word. But somehow sed is not able to replace the old value with new value. Please let me know where Iam going wrong. Sample Code : --> export line="VORTEX,abcdef" export... (3 Replies)
Discussion started by: ajithab
3 Replies

5. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2 (1 Reply)
Discussion started by: aa2601
1 Replies

6. Shell Programming and Scripting

Replacing part of XML code inside comment tags

Hello! I'd like to modify custom values in a XML config file between comment tags using bash script. <feature> <keyboardshortcut>C-m</keyboardshortcut> <option1>disabled</option2> <option2>enabled</option2> </feature> <!-- bash script features START --> <feature> ... (2 Replies)
Discussion started by: prism1
2 Replies

7. Shell Programming and Scripting

Replacing part of a pattern in sed

Hi I have a piece of xml that has a pattern like this <int>159</int><int>30</int> I want to find this pattern but only substitute the second part of the pattern to {rid1}. Is that possible in sed ? Thanks. ---------- Post updated at 12:10 PM ---------- Previous update was at 12:01 PM... (11 Replies)
Discussion started by: vnn
11 Replies

8. UNIX for Dummies Questions & Answers

Replacing part of a text file with user input.

Ok, I am brand new to UNIX and I am trying to learn a cross between basic script and database use. I had got some ideas off the net on simple ideas for learning UNIX. I am working on creating a simple phone book program that allows myself to enter our employees from work into a phone book text... (0 Replies)
Discussion started by: georgefurbee
0 Replies

9. Shell Programming and Scripting

Replacing the part of file name?

Hi All One of my script generate following files. These files has static TIMESTAMP 20080227. AccAdd_20080227_1000.dat AccBal_20080227_1000.dat Acc_20080227_1000.dat AccGrpMem_20080227_1000.dat AccToCust_20080227_1000.dat What i need to do is, once the file has been generated, it... (7 Replies)
Discussion started by: Amit.Sagpariya
7 Replies

10. Shell Programming and Scripting

Need help regarding replacing a part of string

Hi all suppose i have a string "abacus sabre", i need to replace occurences 'ab' with 'cd' and i need to store this result into same string and i need to return this result from script to the calling function, where as the string is passed from calling function. i tried like this ... (1 Reply)
Discussion started by: veerapureddy
1 Replies
Login or Register to Ask a Question