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

Login or Register to Ask a Question and Join Our Community

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

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to grep the desired output and output to a file?

02-26-2013

Registered User

50, 0

Join Date: Nov 2012

Last Activity: 30 December 2014, 9:28 PM EST

Posts: 50

Thanks Given: 6

Thanked 0 Times in 0 Posts

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

jediwannabe

View Public Profile for jediwannabe

Find all posts by jediwannabe

02-26-2013

Registered User

1,040, 213

Join Date: Dec 2010

Last Activity: 20 September 2014, 2:08 AM EDT

Posts: 1,040

Thanks Given: 62

Thanked 213 Times in 203 Posts

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:

Jotne

View Public Profile for Jotne

Find all posts by Jotne

02-26-2013

Registered User

50, 0

Join Date: Nov 2012

Last Activity: 30 December 2014, 9:28 PM EST

Posts: 50

Thanks Given: 6

Thanked 0 Times in 0 Posts

hi Jotne, could you tell me that why it is $4?

thanks

Last edited by jediwannabe; 02-26-2013 at 03:46 AM.. Reason: found that some issues are not resolved

jediwannabe

View Public Profile for jediwannabe

Find all posts by jediwannabe

02-26-2013

Registered User

1,650, 478

Join Date: Mar 2012

Last Activity: 11 September 2019, 8:06 AM EDT

Posts: 1,650

Thanks Given: 58

Thanked 478 Times in 474 Posts

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

pamu

View Public Profile for pamu

Find all posts by pamu

02-26-2013

Registered User

1,040, 213

Join Date: Dec 2010

Last Activity: 20 September 2014, 2:08 AM EDT

Posts: 1,040

Thanks Given: 62

Thanked 213 Times in 203 Posts

I did use $4 since I did see needed data in that field.
Both should work fine.

Jotne

View Public Profile for Jotne

Find all posts by Jotne

02-26-2013

Registered User

50, 0

Join Date: Nov 2012

Last Activity: 30 December 2014, 9:28 PM EST

Posts: 50

Thanks Given: 6

Thanked 0 Times in 0 Posts

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 07:11 AM.. Reason: inserted extra single code tag

jediwannabe

View Public Profile for jediwannabe

Find all posts by jediwannabe

02-26-2013

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

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..

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

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...

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...

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...

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...

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...

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...

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...

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....

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...

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.

Login or Register to Ask a Question