The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
search for a string ,replace the whole line with new line search for a string ,replace the whole line with new line
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
how can search a String in one text file and replace the whole line in another file kkraja UNIX for Dummies Questions & Answers 6 08-06-2008 08:23 AM
Perl: Search for string on line then search and replace text Crypto Shell Programming and Scripting 4 01-04-2008 10:24 AM
search and replace the whole line Jartan Shell Programming and Scripting 17 09-25-2007 02:58 PM
sed search and replace in next line charissaf67 Shell Programming and Scripting 3 07-20-2007 03:55 PM
how to insert line break + string in vi (search & replace ) umen Shell Programming and Scripting 1 06-08-2006 12:42 PM

 
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1 (permalink)  
Old 08-06-2008
kkraja kkraja is offline
Registered User
  
 

Join Date: Aug 2008
Posts: 10
search for a string ,replace the whole line with new line
hai
i am very new to unix.

i am having two files like this.

first.properties

Code:
cache.ZA.TL_CCY=SELECT trim(CCY_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,CCY_CODE,COUNTRY_CODE,CITY_CODE,COUNTRY_CODE_TT,AVAILABLE_TT,AVAILABLE_BT,AVAILABLE_RTGS,AVAILABLE_ACH,AVAILABLE_PAY,AVAILABLE_LBC,AVAILABLE_IBC,AVAILABLE_OC,AVAILABLE_CC,DEC_PLACE,NEED_ROUNDING,ACTION_FLAG FROM TL_CCY
cache.ZA.TL_CLR_ZONE=SELECT trim(CLR_ZONE_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, CLR_ZONE_CODE,COUNTRY_CODE,CITY_CODE,CORR_BANK_CODE,IS_DUMMY,CCY_CODE FROM TL_CLR_ZONE
cache.ZA.TL_CUST=SELECT trim(CUST_ID)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,CUST_ID,COUNTRY_CODE,CITY_CODE,DELETED,FX_TOLERANCE_LIMIT FROM TL_CUST
cache.ZA.TL_CUST_DR_AC=SELECT trim(CUST_ID)||trim(COUNTRY_CODE)||trim(CITY_CODE)||trim(AC_NO) AS PK_COLUMN, CUST_ID,COUNTRY_CODE,CITY_CODE,AC_NO,CCY_CODE,DELETED,ASSIGN_CORP_CHQ_NO,PBOC_BANK_CODE,ALLOW_DUP_CORP_CHQ_NO FROM TL_CUST_DR_AC
cache.ZA.TL_DRAWEE_BANK=SELECT trim(CCY_CODE)||trim(BANK_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,  CCY_CODE,BANK_CODE,COUNTRY_CODE,CITY_CODE FROM TL_DRAWEE_BANK
cache.ZA.TL_DRAWEE_BANK_CHANNEL=SELECT trim(CCY_CODE)||trim(BANK_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, CCY_CODE,BANK_CODE,COUNTRY_CODE,CITY_CODE,DEFAULT_BANK FROM TL_DRAWEE_BANK_CHANNEL
cache.ZA.TL_FLAT_CHARGE=SELECT trim(PYMT_TYPE)||trim(PROC_MODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,PYMT_TYPE,PROC_MODE,COUNTRY_CODE,CITY_CODE,TIER_CHARGE,SERVICE_FEE FROM TL_FLAT_CHARGE
cache.ZA.TL_PICKUP_LOC=SELECT trim(PICKUP_LOC_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, PICKUP_LOC_CODE,COUNTRY_CODE,CITY_CODE FROM TL_PICKUP_LOC
cache.ZA.TL_PYMT_CENTRE= SELECT trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, COUNTRY_CODE,CITY_CODE,SELECT_WHT,SELECT_VAT,SELECT_DISCOUNT,SELECT_SERVICE,SELECT_BRANCH,SELECT_CLZ,CHK_INV_CHAR FROM TL_PYMT_CENTRE
cache.ZA.TL_SERVICE= SELECT trim(SERVICE_TYPE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, SERVICE_TYPE,COUNTRY_CODE,CITY_CODE,PAYROLL_SERVICE FROM TL_SERVICE
cache.ZA.TL_SYS_PARM=SELECT trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, COUNTRY_CODE,CITY_CODE,PROC_BANK_CODE,BASE_CCY,LOCAL_CCY,SYS_CODE,TIME_ZONE_DIFF,FX_CNTL,FX_CNTL_LIMIT,FX_RATE_LIMIT,FAX_NO,MIDAS_BATCH_NO,TRAN_CODE,LOCAL_PYMT_CITY_CODE,DR_RES_MODE,CR_RES_MODE,FISC_NOSTRO_AC_NO,FISC_LIMIT,STRAIGHT_THROUGH_LIMIT,DR_MODE,CR_MODE,PRT_AFTER_DR,MAP_PYMT_TYPE,CHK_LOCAL_CCY_AMT,LLG_RTGS_LIMIT,LLG_CLR_ZONE_CODE FROM TL_SYS_PARM
cache.ZA.TL_CCY_CUTOFF_TIME=SELECT trim(PYMT_TYPE)||trim(PROC_MODE)||trim(CCY_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, PYMT_TYPE,PROC_MODE,CCY_CODE,COUNTRY_CODE,CITY_CODE,MON_CUTOFF_TIME,TUE_CUTOFF_TIME,WED_CUTOFF_TIME,THU_CUTOFF_TIME,FRI_CUTOFF_TIME,SAT_CUTOFF_TIME,SUN_CUTOFF_TIME FROM TL_CCY_CUTOFF_TIME



Change.txt

Code:
cache.ZA.TL_CLR_ZONE=SELECT trim(CCY_CODE) AS PK_COLUMN,CCY_CODE,NEED_ROUNDING FROM TL_CCY
 
cache.ZA.TL_SYS_PARM=SELECT trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,FISC_NOSTRO_AC_NO,FISC_LIMIT,STRAIGHT_THROUGH_LIMIT,DR_MODE,CR_MODE,PRT_AFTER_DR,MAP_PYMT_TYPE,CHK_LOCAL_CCY_AMT,LLG_RTGS_LIMIT,LLG_CLR_ZONE_CODE FROM TL_SYS_PARM




i want the output to be
First.properties

Code:
cache.ZA.TL_CCY=SELECT trim(CCY_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,CCY_CODE,COUNTRY_CODE,CITY_CODE,COUNTRY_CODE_TT,AVAILABLE_TT,AVAILABLE_BT,AVAILABLE_RTGS,AVAILABLE_ACH,AVAILABLE_PAY,AVAILABLE_LBC,AVAILABLE_IBC,AVAILABLE_OC,AVAILABLE_CC,DEC_PLACE,NEED_ROUNDING,ACTION_FLAG FROM TL_CCY

cache.ZA.TL_CLR_ZONE=SELECT trim(CCY_CODE) AS PK_COLUMN,CCY_CODE,NEED_ROUNDING FROM TL_CCY
 
cache.ZA.TL_CUST=SELECT trim(CUST_ID)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,CUST_ID,COUNTRY_CODE,CITY_CODE,DELETED,FX_TOLERANCE_LIMIT FROM TL_CUST
cache.ZA.TL_CUST_DR_AC=SELECT trim(CUST_ID)||trim(COUNTRY_CODE)||trim(CITY_CODE)||trim(AC_NO) AS PK_COLUMN, CUST_ID,COUNTRY_CODE,CITY_CODE,AC_NO,CCY_CODE,DELETED,ASSIGN_CORP_CHQ_NO,PBOC_BANK_CODE,ALLOW_DUP_CORP_CHQ_NO FROM TL_CUST_DR_AC
cache.ZA.TL_DRAWEE_BANK=SELECT trim(CCY_CODE)||trim(BANK_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,  CCY_CODE,BANK_CODE,COUNTRY_CODE,CITY_CODE FROM TL_DRAWEE_BANK
cache.ZA.TL_DRAWEE_BANK_CHANNEL=SELECT trim(CCY_CODE)||trim(BANK_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, CCY_CODE,BANK_CODE,COUNTRY_CODE,CITY_CODE,DEFAULT_BANK FROM TL_DRAWEE_BANK_CHANNEL
cache.ZA.TL_FLAT_CHARGE=SELECT trim(PYMT_TYPE)||trim(PROC_MODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,PYMT_TYPE,PROC_MODE,COUNTRY_CODE,CITY_CODE,TIER_CHARGE,SERVICE_FEE FROM TL_FLAT_CHARGE
cache.ZA.TL_PICKUP_LOC=SELECT trim(PICKUP_LOC_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, PICKUP_LOC_CODE,COUNTRY_CODE,CITY_CODE FROM TL_PICKUP_LOC
cache.ZA.TL_PYMT_CENTRE= SELECT trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, COUNTRY_CODE,CITY_CODE,SELECT_WHT,SELECT_VAT,SELECT_DISCOUNT,SELECT_SERVICE,SELECT_BRANCH,SELECT_CLZ,CHK_INV_CHAR FROM TL_PYMT_CENTRE
cache.ZA.TL_SERVICE= SELECT trim(SERVICE_TYPE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, SERVICE_TYPE,COUNTRY_CODE,CITY_CODE,PAYROLL_SERVICE FROM TL_SERVICE

cache.ZA.TL_SYS_PARM=SELECT trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN,FISC_NOSTRO_AC_NO,FISC_LIMIT,STRAIGHT_THROUGH_LIMIT,DR_MODE,CR_MODE,PRT_AFTER_DR,MAP_PYMT_TYPE,CHK_LOCAL_CCY_AMT,LLG_RTGS_LIMIT,LLG_CLR_ZONE_CODE FROM TL_SYS_PARM
cache.ZA.TL_CCY_CUTOFF_TIME=SELECT trim(PYMT_TYPE)||trim(PROC_MODE)||trim(CCY_CODE)||trim(COUNTRY_CODE)||trim(CITY_CODE) AS PK_COLUMN, PYMT_TYPE,PROC_MODE,CCY_CODE,COUNTRY_CODE,CITY_CODE,MON_CUTOFF_TIME,TUE_CUTOFF_TIME,WED_CUTOFF_TIME,THU_CUTOFF_TIME,FRI_CUTOFF_TIME,SAT_CUTOFF_TIME,SUN_CUTOFF_TIME FROM TL_CCY_CUTOFF_TIME

we have to search for the keys which found inside our change.txt in first.properties and replace the value of the key in first.properties with the corresponding value inside our change.txt


please help mein this scenario. it is an very urgent requirement.please help me .

thanks a lot in advance
Raja
Last edited by radoulov; 08-06-2008 at 07:24 AM.. Reason: please use code tags
 

Bookmarks

Tags
awk, awk trim, trim, trim awk

« awk help | escaping / (forward slash) »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Threaded Mode Threaded Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 10:35 PM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0