How to grep the desired output and output to a file?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to grep the desired output and output to a file?
# 1  
Old 02-26-2013
How to grep the desired output and output to a file?

currently I have process from a raw file to this stage
Code:
ALTER TABLE "EXCEL_ADMIN"."TC_TXN_VOID" ADD CONSTRAINT "PK_TC_TXN_VOID" PRIMARY KEY ("TC_TXN_IID")
ALTER TABLE "EXCEL_ADMIN"."TC_TXN_AMT" ADD CONSTRAINT "PK_TC_TXN_AMT" PRIMARY KEY ("TC_TXN_AMT_IID")
ALTER TABLE "EXCEL_ADMIN"."TC_TXN_ATTRIBUTE" ADD CONSTRAINT "PK_TC_TXN_ATTRIBUTE" PRIMARY KEY ("TC_TXN_ATTRIBUTE_IID")

my desired output is

Code:
@ ../../migschema/admin/pk_tc_txn_void.sql
@ ../../migschema/admin/pk_tc_txn_amt.sql
@ ../../migschema/admin/pk_tc_txn_attribute.sql

thanks
# 2  
Old 02-26-2013
Code:
awk -F\" '{print "@ ../../migschema/admin/pk_"tolower($4)".sql"}' infile
@ ../../migschema/admin/pk_tc_txn_void.sql
@ ../../migschema/admin/pk_tc_txn_amt.sql
@ ../../migschema/admin/pk_tc_txn_attribute.sql

This User Gave Thanks to Jotne For This Post:
# 3  
Old 02-26-2013
hi Jotne, could you tell me that why it is $4?

thanks

Last edited by jediwannabe; 02-26-2013 at 02:46 AM.. Reason: found that some issues are not resolved
# 4  
Old 02-26-2013
Quote:
Originally Posted by jediwannabe
hi Jotne, could you tell me that why it is $4?

thanks
better way use $6

Code:
$ awk -F\" '{print "@ ../../migschema/admin/"tolower($6)".sql"}' file
@ ../../migschema/admin/pk_tc_txn_void.sql
@ ../../migschema/admin/pk_tc_txn_amt.sql
@ ../../migschema/admin/pk_tc_txn_attribute.sql

# 5  
Old 02-26-2013
I did use $4 since I did see needed data in that field.
Both should work fine.
# 6  
Old 02-26-2013
input file, sqlfile_admin_package_bodies.log is now as follow
Code:
CREATE package body ACCOUNT_API is
CREATE package body BATCH_SUBSCRIPTION is

Code:
awk -F\" '{print "@ ../../migschema/admin/"tolower($3)".bdy"}' sqlfile_admin_package_bodies.log

output is now

Code:
@ ../../migschema/admin/.bdy
@ ../../migschema/admin/.bdy

is there any reason why $3 is wrong in this case?

thanks

Last edited by Scrutinizer; 02-26-2013 at 06:11 AM.. Reason: inserted extra single code tag
# 7  
Old 02-26-2013
Your input file specification seems to have changed. It does not contain double quotes, so using that field separator (-F\") will not render the desired results..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Grep -P does not capture the desired output

Hi, I'm trying to filter the following output to only display information about an alarm where the Status: corresponds to Set. -------------------------------------------------------- Description: hw_optics: RX POWER LANE-0 LOW ALARM Location: Optics0/0/0/21... (6 Replies)
Discussion started by: sand1234
6 Replies

2. Shell Programming and Scripting

Output not coming as desired.

Hi guys. I have a file containing some hosts and their IPs. host host1 192.168.2.10 host host2 192.168.2.11 host host3 192.168.2.12 I am writing a script where I want to print these values in 1 line. My script looks like RUNTIME_NODE=`cat hosts.properties | grep host` for i in... (7 Replies)
Discussion started by: Junaid Subhani
7 Replies

3. Shell Programming and Scripting

Help!! needed to get the desired output

Am in need of your help to get the desired output. nameSECURITY.SERVICES.CONFIG:GETVALUEisPrefetchedNsAccessLast2013-09-13 10:50:13 MESTsAccessTotal1sRunningcHitLastnamePUBLIC.SERVER:INVOKEisPrefetchedNsAccessLast2013-09-17 15:02:05... (5 Replies)
Discussion started by: rocky2013
5 Replies

4. Shell Programming and Scripting

handling CSV file to get desired output

Hi All , i have a CSV file , pattern is given below :- Group # name # host # account # stop # # start # # check -------------------------------------------------------------------------- file format and data exmaple :- RBP2,RB0112,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn... (0 Replies)
Discussion started by: deepakiniimt
0 Replies

5. Shell Programming and Scripting

need to get the desired output

Below is the my cide which is working fine but I am not getting the output indesired format.there is some problem in alignment.Can someone help me to correct this? if ]; then summary=$( echo -e "Please review the log file of auto coloclean utility.\n"; echo -e... (2 Replies)
Discussion started by: anuragpgtgerman
2 Replies

6. Shell Programming and Scripting

Need your help to get the output of the list in desired format

Hello Guys, I am working on a script and using the below code to fetch the list of all repositories CHDIR='/mnt/scm/subversion/' repolist() { cd ${CHDIR} Repo=`ls|cut -d " " -f1` echo $Repo } Output of the above code is BSB CIB COB DCI DIB DSB ESB-P ESB-TOOLS FareVerify GCACHE GWY... (15 Replies)
Discussion started by: rohit22hamirpur
15 Replies

7. Shell Programming and Scripting

SED - output not desired

echo '0x3f 0xfa ae 0xeA' | sed '/0x/ y/abcdef/ABCDEF/' output: 0x3F 0xFA AE 0xEA echo '0x3f 0xfa ae 0xeA' | sed -r '/0x{2}/ y/abcdefg/ABCDEFG/' output: 0x3F 0xFA AE 0xEA my expected output: 0x3F 0xFA ae 0xEA What I want to achieve is change all hexadecimals to UPPER case(only those... (6 Replies)
Discussion started by: kevintse
6 Replies

8. Shell Programming and Scripting

how to get desired output after redirection

hi i am running script which contains the commmnds and i am redirecting the script output to a file. like ./script 1> result.txt 2>&1 the above redirection is not working for commands when run in background in a script. but the problem here result.txt containg output which is repeated.... (3 Replies)
Discussion started by: raji
3 Replies

9. Shell Programming and Scripting

script not giving the desired output

Hi, I have a script in which an entry like this ..... FILENAME_B="PIC_${DATE}0732*.JPG" The script connects to an ATM and pull a pic file from it.The format for the file is like PIC_2008061400000001.JPG in the ATM. Means 1st 8 digit is the date(YYYYMMDD) field 2nd 8 digit means hrs... (2 Replies)
Discussion started by: Renjesh
2 Replies

10. Shell Programming and Scripting

Help me in getting the desired output

I wanted to put "|" this sign at starting and at end of every field but its not working with first field like Currently the out put is : abc | abc | abc | xyz | xyz | xyz | But I want the out put in this form: | abc | abc | abc | | xyz | xyz | xyz | plz help me. (2 Replies)
Discussion started by: akash
2 Replies
Login or Register to Ask a Question