Shell Programming and Scripting

Hi Folks,

I am new to ksh, i have informatica parameter file that i need to update everyday with shell script. i need your help updating this file with new parameters.

sample data
[GLOBAL]

[s_m_STG_TABLE1]
$$TABLE1_DATE=04-27-2011

[s_m_STG_TABLE2]
$$TABLE2_DATE=04-23-2011

[s_m_STG_TABLE3]
$$TABLE3_DATE=03-19-2011

.......Highligned are the values i need to update everyday..with another parameter coming from sqlplus statement. This values are dynamic and random because i wont load every table everyday. I need to update Highlithed value with parameter.

Try:

Code:

perl -i -pe 's/(?<=TABLE._DATE=).*/your_parameter/' file

Make a backup of your file first

i dont perl utility to my profile..is there anyway.this can be done using sed and awk

Do you have GNU version of sed?

Code:

sed -i 's/\(TABLE._DATE=\).*/\1your_parameter/' file

It solved my problem...

[---------- Post updated 05-26-11 at 07:49 AM ---------- Previous update was 05-25-11 at 03:50 PM ----------

it worked with double quotes

Code:

sed -i "s/\(TABLE._DATE=\).*/\1$parameter/" file

Moderator's Comments:

Thanks for the feedback, but please use [code] and [/code] tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks.