fixing with sed

capri_drm · #1 (**permalink**) 05-23-2008

I am trying to replace the value of $f3 but its not working . I don't know what I am missing here .

Code:

 cat dim_copy.20080516.sql | grep -i "create view" | grep -v OPSDM002 |  while read f1 f2 f3 f4 f5 f6 f7 f8 f9   
       do
              echo " $f3 " 
             sed -e s/"${f3}"/OPSDM002."${f3}"/ dim_copy.20080516.sql > dim_copy.20080516.sql1
         done

Can someone suggest me how to fix it .

Thanks in advance

Franklin52 · #2 (**permalink**) 05-23-2008

Post some lines of the sql file and the desired output.

Regards

capri_drm · #3 (**permalink**) 05-27-2008

The SQL file is

CREATE VIEW MOUSE_UHC AS SELECT DT_SYS_ID ,DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR
FROM OPSDM002.DIM_COPY;
CREATE VIEW OPSDM002.TABLE_UHC AS SELECT DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR,LOAD_DT,WEEK_NBR_YR,SEQ_NBR
FROM OPSDM002.DIM_COPY;
CREATE VIEW RAT_UHC AS SELECT DT_SYS_ID ,DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR

The desired output is

CREATE VIEW OPSDM002.MOUSE_UHC AS SELECT DT_SYS_ID ,DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR
FROM OPSDM002.DIM_COPY;
CREATE VIEW OPSDM002.TABLE_UHC AS SELECT DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR,LOAD_DT,WEEK_NBR_YR,SEQ_NBR
FROM OPSDM002.DIM_COPY;
CREATE VIEW OPSDM002.RAT_UHC AS SELECT DT_SYS_ID ,DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR

Thanks

ripat · #4 (**permalink**) 05-27-2008

If I understand correctly what you try to do:

Code:

sed -r '/OPSDM002/! s/CREATE VIEW ([^ ]+)/CREATE VIEW OPSDM002.\1/' your_file

capri_drm · #5 (**permalink**) 05-27-2008

Ripat ,
When I run your command i get the following error

#sed -r '/OPSDM002/! s/CREATE VIEW ([^ ]+)/CREATE VIEW OPSDM002.\1/' dim_copy.20080516.sql
sed: illegal option -- r
Usage: sed [-n] Script [File ...]
sed [-n] [-e Script] ... [-f Script_file] ... [File ...]

Thanks

ripat · #6 (**permalink**) 05-27-2008

In that case, here we go with the backslash dance:

Code:

sed '/OPSDM002/! s/CREATE VIEW \([^ ]\+\)/CREATE VIEW OPSDM002.\1/'

gus2000 · #7 (**permalink**) 05-27-2008

Bah! Use 'awk':

Code:

awk '/^CREATE VIEW/ && !/OPSDM02/{$3="OPSDM02."$3};{print}' infile > outfile

It gets a bit more compliated if the string "CREATE VIEW" really needs to be case-insensitive. You'd need to make the regex [Ll][Ii][Kk][Ee] [Tt][Hh][Ii][Ss]. If the string is either ALL upper or ALL lower, then you can get away with using "/^CREATE VIEW/ || /^create view/".

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Problem fixing e1000gx ni to 100fdx / Solaris 10 / T5220	moofoo	SUN Solaris	6	01-14-2008 04:34 AM
fixing the error message when grep doesn't finds the pattern.	silver123	UNIX for Dummies Questions & Answers	1	03-03-2006 05:59 AM
Fixing line length in a file	dbessell	UNIX for Advanced & Expert Users	2	08-04-2003 07:40 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: