|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
filtering and copying contains of a file using awk/sed
Post 302284068 by jville on Wednesday 4th of February 2009 04:45:04 PM
02-04-2009
filtering and copying contains of a file using awk/sed
Hello folks,
I have 2 files one( file1) contains the ddl for a view and file 2 contains the view defination/alias columns.
I want to merge the 2 into a third file using awk/sed as follows:
cheers !
FILE1
-----
PROMPT FIRST_VIEW
CREATE OR REPLACE FORCE VIEW FIRST_VIEW
AS
SELECT col1, col2, col3 from anytable1
where col1='X');
PROMPT SECOND_VIEW
CREATE OR REPLACE FORCE VIEW SECOND_VIEW
AS
SELECT test1, test2 from table2
where test2='TEST');
--------------------------------------------------------------
FILE2
-----
Create View TESTSCHEMA.FIRST_VIEW(
COL1,
col2,
col3)
Create View TESTSCHEMA.THIRD_VIEW(
dir1,
dir2,
dir3)
Create View TESTSCHEMA.SECOND_VIEW(
test1,
test2)
=================================================
Output file
output file:
-----------
PROMPT FIRST_VIEW
CREATE OR REPLACE FORCE VIEW FIRST_VIEW
(
COL1,
col2,
col3)
AS
SELECT col1, col2, col3 from anytable1
where col1='X');
PROMPT SECOND_VIEW
CREATE OR REPLACE FORCE VIEW SECOND_VIEW
(
test1,
test2)
AS
SELECT test1, test2 from table2
where test2='TEST');
I have 2 files one( file1) contains the ddl for a view and file 2 contains the view defination/alias columns.
I want to merge the 2 into a third file using awk/sed as follows:
cheers !
FILE1
-----
PROMPT FIRST_VIEW
CREATE OR REPLACE FORCE VIEW FIRST_VIEW
AS
SELECT col1, col2, col3 from anytable1
where col1='X');
PROMPT SECOND_VIEW
CREATE OR REPLACE FORCE VIEW SECOND_VIEW
AS
SELECT test1, test2 from table2
where test2='TEST');
--------------------------------------------------------------
FILE2
-----
Create View TESTSCHEMA.FIRST_VIEW(
COL1,
col2,
col3)
Create View TESTSCHEMA.THIRD_VIEW(
dir1,
dir2,
dir3)
Create View TESTSCHEMA.SECOND_VIEW(
test1,
test2)
=================================================
Output file
output file:
-----------
PROMPT FIRST_VIEW
CREATE OR REPLACE FORCE VIEW FIRST_VIEW
(
COL1,
col2,
col3)
AS
SELECT col1, col2, col3 from anytable1
where col1='X');
PROMPT SECOND_VIEW
CREATE OR REPLACE FORCE VIEW SECOND_VIEW
(
test1,
test2)
AS
SELECT test1, test2 from table2
where test2='TEST');
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Goo afternoon Sir'sould like to ask your help reagrding in this scenario using sed and awk.
********************************************************
Host:CDRMSAPPS1
Operating System:Linux 2.6.9-42.ELsmp
Machine Type:UNIX
Host Type:Client
Version:5.1... (2 Replies)
Discussion started by: invinzin21
2 Replies
2. Shell Programming and Scripting
The problem I have is that I have 23,000 records I need to sort through to pull out LEN: XXXX XX XX XX XX and NCOS: XXX entries from so I can insert them into a database. But some of my records include TYPE: ISDN, THE DN IS UNASSIGNED, or INVALID entries in between some records and I would like... (2 Replies)
Discussion started by: roachmmflhyr
2 Replies
3. Shell Programming and Scripting
Hi,
I am currently using the sed and awk commands to filter a file that has multiple sets of data in different columns. An example of part of the file i am filtering is as follows;
Sat Oct 2 07:42:45 2010 01:33:46 R1_CAR_12.34
Sun Oct 3 13:09:53 2010 00:02:34 R2_BUS_56.78
Sun... (4 Replies)
Discussion started by: crunchie
4 Replies
4. Shell Programming and Scripting
We have 2 file XML files - FILE1.XML and FILE2.xml - we need copy the contents of FILE1.XML and replace in FILE2.xml pattern "<assignedAttributeList></assignedAttributeList>"
FILE1.XML
1. <itemList>
2. <item type="Manufactured">
3. <resourceCode>431048</resourceCode>
4. ... (0 Replies)
Discussion started by: balrajg
0 Replies
5. Shell Programming and Scripting
Hi All,
I need to copy a specific line from a file to another file.
lets suppose the line number 13 of a file
when I am writing the line number explicitly.. its working fine
sed -n '13p' afile > anotherfile
but, when inside a script, i am getting the line number value inside a variable... (4 Replies)
Discussion started by: gotamp
4 Replies
6. Shell Programming and Scripting
Hi,
TASK 1:
I have been using this code to print the information of files kept at "/castor/cern.ch/user/s/sudha/forPooja" in some text file name FILE.txt.
rfdir /castor/cern.ch/user/s/sudha/forPooja | grep data | awk '{print "rfio:///castor/cern.ch/user/s/sudha/forPooja/"$9}' > FILE.txt
... (6 Replies)
Discussion started by: nrjrasaxena
6 Replies
7. Shell Programming and Scripting
Hello Folks,
I am working on filtering a file having some special characters.
Let's say for an example a file contains person name and phone number based on positions. First 5 characters name and next 10 characters phone number. My task is to , if there is any special character in phone number... (6 Replies)
Discussion started by: dinesh1985
6 Replies
8. Shell Programming and Scripting
Experts Good day,
I want to filter multiple lines of same error of same day , to only 1 error of each day, the first line from the log.
Here is the file:
May 26 11:29:19 cmihpx02 vmunix: NFS write failed for server cmiauxe1: error 5 (RPC: Timed out)
May 26 11:29:19 cmihpx02 vmunix: NFS... (4 Replies)
Discussion started by: rveri
4 Replies
9. Shell Programming and Scripting
Hello,
Does anyone know an easy way to filter this type of file? I want to get everything that has score (column 2) 100.00 and get rid of duplicates (for example gi|332198263|gb|EGK18963.1| below), so I guess uniq can be used for this?
gi|3379182634|gb|EGK18561.1| 100.00... (6 Replies)
Discussion started by: narachaid
6 Replies
10. Shell Programming and Scripting
Hello Members,
I have a file, having below contents:
<KEYVALUE>$4,0,1,4,966505098999-->RemoteSPC: 13 SSN: 146</KEYVALUE>
<KEYVALUE>$4,123,1,4,966505050198-->RemoteSPC: 1002 SSN: 222,Sec:RemoteSPC: 1004 SSN: 222</KEYVALUE>
<KEYVALUE>$4,123,1,4,966505050598-->RemoteSPC: 1002 SSN:... (9 Replies)
Discussion started by: umarsatti
9 Replies
LEARN ABOUT XFREE86
largefile
largefile(5) Standards, Environments, and Macros largefile(5) NAME
largefile - large file status of utilities DESCRIPTION
A large file is a regular file whose size is greater than or equal to 2 Gbyte ( 2**31 bytes). A small file is a regular file whose size is less than 2 Gbyte. Large file aware utilities A utility is called large file aware if it can process large files in the same manner as it does small files. A utility that is large file aware is able to handle large files as input and generate as output large files that are being processed. The exception is where additional files are used as system configuration files or support files that can augment the processing. For example, the file utility supports the -m option for an alternative "magic" file and the -f option for a support file that can contain a list of file names. It is unspecified whether a utility that is large file aware will accept configuration or support files that are large files. If a large file aware utility does not accept configuration or support files that are large files, it will cause no data loss or corruption upon encountering such files and will return an appropriate error. The following /usr/bin utilities are large file aware: adb awk bdiff cat chgrp chmod chown cksum cmp compress cp csh csplit cut dd dircmp du egrep fgrep file find ftp getconf grep gzip head join jsh ksh ln ls mdb mkdir mkfifo more mv nawk page paste pathchck pg rcp remsh rksh rm rmdir rsh sed sh sort split sum tail tar tee test touch tr uncompress uudecode uuencode wc zcat The following /usr/xpg4/bin utilities are large file aware: awk cp chgrp chown du egrep fgrep file grep ln ls more mv rm sed sh sort tail tr The following /usr/xpg6/bin utilities are large file aware: getconf ls tr The following /usr/sbin utilities are large file aware: install mkfile mknod mvdir swap See the USAGE section of the swap(1M) manual page for limitations of swap on block devices greater than 2 Gbyte on a 32-bit operating sys- tem. The following /usr/ucb utilities are large file aware: chown from ln ls sed sum touch The /usr/bin/cpio and /usr/bin/pax utilities are large file aware, but cannot archive a file whose size exceeds 8 Gbyte - 1 byte. The /usr/bin/truss utilities has been modified to read a dump file and display information relevant to large files, such as offsets. cachefs file systems The following /usr/bin utilities are large file aware for cachefs file systems: cachefspack cachefsstat The following /usr/sbin utilities are large file aware for cachefs file systems: cachefslog cachefswssize cfsadmin fsck mount umount nfs file systems The following utilities are large file aware for nfs file systems: /usr/lib/autofs/automountd /usr/sbin/mount /usr/lib/nfs/rquotad ufs file systems The following /usr/bin utility is large file aware for ufs file systems: df The following /usr/lib/nfs utility is large file aware for ufs file systems: rquotad The following /usr/xpg4/bin utility is large file aware for ufs file systems: df The following /usr/sbin utilities are large file aware for ufs file systems: clri dcopy edquota ff fsck fsdb fsirand fstyp labelit lockfs mkfs mount ncheck newfs quot quota quotacheck quotaoff quotaon repquota tunefs ufsdump ufsrestore umount Large file safe utilities A utility is called large file safe if it causes no data loss or corruption when it encounters a large file. A utility that is large file safe is unable to process properly a large file, but returns an appropriate error. The following /usr/bin utilities are large file safe: audioconvert audioplay audiorecord comm diff diff3 diffmk ed lp mail mailcompat mailstats mailx pack pcat red rmail sdiff unpack vi view The following /usr/xpg4/bin utilities are large file safe: ed vi view The following /usr/xpg6/bin utility is large file safe: ed The following /usr/sbin utilities are large file safe: lpfilter lpforms The following /usr/ucb utilities are large file safe: Mail lpr The following /usr/lib utility is large file safe: sendmail SEE ALSO
lf64(5), lfcompile(5), lfcompile64(5) SunOS 5.10 7 Nov 2003 largefile(5)