Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Replace from Refrence file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Replace from Refrence file
# 1  
Old 02-10-2012
Replace from Refrence file
Need help with this ..

Input file
Code:
 
234,6006016061302E006BE89E7FD64DE111,6006016061302E00B824FDA6D32CE111,Complete

Refrence File
Code:
 
6006016061302E006BE89E7FD64DE111:vvv_222:433:RP_JRNL_LUN_3005
6006016061302E00B824FDA6D32CE111:vvv_444:344:laputa_LUN_95_L

If $2 or $3 from input file match to column 1 in refrence file replace them with everything after $1 from refrence file , if not keep the orignal entries

Output needed
Code:
 
234,vvv_222:433:RP_JRNL_LUN_3005,vvv_444:344:laputa_LUN_95_L,Complete

Thanks
# 2  
Old 02-10-2012
Try:
Code:
awk -F, -vOFS="," 'NR==FNR{sub(":",",");a[$1]=$2;next}{$2=a[$2]?a[$2]:$2;$3=a[$3]?a[$3]:$3}1' ref input

This User Gave Thanks to bartus11 For This Post:
greycells
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Avoid overwriting backup file when multiple entries need to replace in one file input from another

Hello, I have been working on script in which search and replace the multiple pattern. 1. update_params.sh read the multiple pattern from input file ParamMapping.txt(old_entry|New_entry) and passing this values one by one to change_text.sh 2. change_text.sh read... (0 Replies)
Discussion started by: ketanraut
0 Replies

2. Shell Programming and Scripting

Perl script to read string from file#1 and find/replace in file#2

Hello Forum. I have a file called abc.sed with the following commands; s/1/one/g s/2/two/g ... I also have a second file called abc.dat and would like to substitute all occurrences of "1 with one", "2 with two", etc and create a new file called abc_new.dat sed -f abc.sed abc.dat >... (10 Replies)
Discussion started by: pchang
10 Replies

3. Shell Programming and Scripting

Replace from refrence file

Input file FS01,/root_vdm_9/UKSR06_FS01,test1 FS04,/root_vdm_11/UKSR04_FS04,test2 FS01,/root_vdm_7/UKSR02_FS01,test4 FS01,/root_vdm_12/UKSR03_FS01/dhdhdhdh,test5 FS01,/root_vdm_11/UKSR04_FS01/gggg,test6 Reference File /root_vdm_9/UKSR06_FS01,UKSR06_FS01... (2 Replies)
Discussion started by: greycells
2 Replies

4. Shell Programming and Scripting

Refrence File replace (awk)

I know lot of very similar questions have been asked multiple time before ... this is a bit different Want to replace columns/subcolums from the reference file , if not present in the refrence file leave it as it is the complete column does not need to match the refernce file , values within... (2 Replies)
Discussion started by: greycells
2 Replies

5. Shell Programming and Scripting

Search and replace from file in awk using a 16 bit text file

Hello, Some time ago a helpful awk file was provided on the forum which I give below: NR==FNR{A=$0;next}{for(j in A){split(A,P,"=");for(i=1;i<=NF;i++){if($i==P){$i=P}}}}1 While it works beautifully on English and Latin characters i.e. within the ASCII range of 127, the moment a character beyond... (6 Replies)
Discussion started by: gimley
6 Replies

6. 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

7. Shell Programming and Scripting

script to grep a pattern from file compare contents with another file and replace

Hi All, Need help on this I have 2 files one file file1 which has several entries as : define service{ hostgroup_name !host1,!host5,!host6,.* service_description check_nrpe } define service{ hostgroup_name !host2,!host4,!host6,.* service_description check_opt } another... (2 Replies)
Discussion started by: namitai
2 Replies

8. Shell Programming and Scripting

Read file and for each line replace two variables, add strings and save output in another file

Hi All, I have a file, let's call it "info.tmp" that contains data like this .. ABC123456 PCX333445 BCD789833 I need to read "info.tmp" and for each line add strings in a way that the final output is put /logs/ua/dummy.trigger 'AAA00001.FTP.XXX.BLA03A01.xxxxxx(+1)' where XXX... (5 Replies)
Discussion started by: Andy_ARG
5 Replies

9. Shell Programming and Scripting

How to use refrence values inside sed command

I am using script S_db=`grep SRC_DB= ${login_txt} | cut -d= -f2` T_db=`grep TGT_DB= ${login_txt} | cut -d= -f2` today=`date +%Y%m%d` sed 's/USER_WORK/RAR_WORK_D1/g' < ${my_path}/files/${T_target}_${today}_DDL.txt > ${my_path}/files/temp9 But when I am trying to remove hardcode values... (1 Reply)
Discussion started by: scorp_rahul23
1 Replies

10. Shell Programming and Scripting

Refrence Shell variable in Perl code.

:confused: I have 2 files a & b Contents of a are:- -------------------------- This is a Good Boy This is a Good Boy This is a Very Good Boy This is a Good Boy This is a Good Boy --------------------------- The contents of b are ------------------- This is Testing Beta... (5 Replies)
Discussion started by: send2sridhar
5 Replies
Login or Register to Ask a Question