AWK unable to parse Post: 302186889

Sponsored Content

Top Forums Shell Programming and Scripting AWK unable to parse Post 302186889 by COD on Friday 18th of April 2008 10:59:41 AM

04-18-2008

Registered User

[B]Unable to invoke sqlplus from AWK[/B]

Code:

awk -v new="                  " '
substr($0, 17, 3) == "ABC"  && substr($0, 52, 8) == "00000000" {
                  tr=substr($0, 20, 10);
                    ap=substr($0, 30, 2);
                    ver=substr($0, 32, 2);
                    irver=substr($0, 34, 2);
                    recdate=substr($0, 36, 8);
                    logdate=substr($0, 44, 8);
#                    printf ("%s %s %s %s %s %s\n", utr, ap, ver, irver, recdate, logdate);
            cd $ORACLE_HOME
            retval=$(sqlplus -s edfrgv/erfcdf <<eof
            exec abc_ert($tr , $ap, $ver, $irver, $recdate, $logdate);
            eof)
            printf ("%s\n", $retval);
 
                        next;
                        }
                        1
                        ' ert.dat > fff.dat

awk unable to parse this script:
Error is

Quote:

syntax error The source line is 12.
The error context is
retval=$(sqlplus -s abc/abc >f
awk: The statement cannot be correctly parsed.
The source line is 12.
syntax error The source line is 13.

Please advise

Last edited by COD; 04-18-2008 at 04:39 PM.. Reason: incorrect info

COD

View Public Profile for COD

Find all posts by COD

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

parse string with awk

Hi Guys, I spend half a day getting this to work with no luck, perhaps you guys can help.. I have a string from a file looking like this: module::name=test::type=generic_data::exec=snmpget.......::desc=A Little Test::interval=300 what I would like to split it, so I get a value for each...

2. UNIX for Dummies Questions & Answers

awk to parse a directory name?

Hi, I have a directory file name: /auto/space/user/jen/CED/CED_01MZ/visit1/DCE_2eco/016/echo1 I would like to just get the following outputs into variables such that: variable1 = /auto/space/user/jen/CED/CED_01MZ/visit1/ and variable2 = DCE_2eco/016/echo1 I've tried it with...

3. Shell Programming and Scripting

Parse file using awk and work in awk output

hi guys, i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 this the file raw format: Number of...

4. Shell Programming and Scripting

AWK: Parse lvdisplay

Hi, I would like to parse the next output of an lvdisplay -v using awk: --- Logical volumes --- LV Name /dev/vg01/lvol3 VG Name /dev/vg01 LV Permission read/write LV Status available/syncd Mirror copies ...

5. Shell Programming and Scripting

parse xm entry with awk/sed

Hi folks, I have XML files with the following sections (section occurs once per file) in them: <AuthorList CompleteYN="Y"> <Author ValidYN="Y"> <LastName>Bernal</LastName> <ForeName>Federico</ForeName> ...

6. Shell Programming and Scripting

Parse a file with awk?

Hi guys (and gals). I need some help. I'm running an IVR purely on Asterisk where I capture the DTMFs. After pulsing each DTMF I have Asterisk write to a file with whatever was dialed (mostly used for record-keeping) and at the end of the survey I write all variables in a single line to a...

7. Shell Programming and Scripting

Parse input -AWK

Input File Defined configuration: cfg: CLL_DCC_Fabric_A BTS00P21; BAU_AP00P01QC; BAU_LGSCNJP02; BAU_TS00P20; BAU_DSMSM14; BAU_HT00P02; BAU_DSMSM13; BAU_HT00P01; cfg: CX0014_list BAU_TS00P20; BAU_NYP_PRODIAD1_CJ;...

8. Shell Programming and Scripting

Parse a file using awk

Hi Experts, I am trying to parse the following file; FILEA a|b|c|c|c|c a|b|d|d|d|d e|f|a|a|a|a e|f|b|b|b|boutput expected: a<TAB>b <TAB><TAB>c<TAB>c<TAB>c<TAB>c<TAB> <TAB><TAB>d<TAB>d<TAB>d<TAB>d<TAB> e<TAB>f <TAB><TAB>a<TAB>a<TAB>a<TAB>a<TAB> <TAB><TAB>b<TAB>b<TAB>b<TAB>b<TAB>*...

9. Shell Programming and Scripting

awk to parse df output

Output of the below code includes unmatched date.Please correct it df -k|awk '$4>50 {print $1, "\t"$4,"\t" $7}' It gives output less than 50% also.

10. Shell Programming and Scripting

Using awk to Parse File

Hi all, I have a file that contains a good hundred of these job definitions below: Job Name Last Start Last End ST Run Pri/Xit ________________________________________________________________ ____________________...

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

parse string with awk

Discussion started by: hyber

2. UNIX for Dummies Questions & Answers

awk to parse a directory name?

Discussion started by: nixjennings

3. Shell Programming and Scripting

Parse file using awk and work in awk output

Discussion started by: dagigg

4. Shell Programming and Scripting

AWK: Parse lvdisplay

Discussion started by: RuBiCK

5. Shell Programming and Scripting

parse xm entry with awk/sed

Discussion started by: euval

6. Shell Programming and Scripting

Parse a file with awk?

Discussion started by: tulf210

7. Shell Programming and Scripting

Parse input -AWK

Discussion started by: greycells

8. Shell Programming and Scripting

Parse a file using awk

Discussion started by: rajangupta2387

9. Shell Programming and Scripting

awk to parse df output

Discussion started by: vinil

10. Shell Programming and Scripting

Using awk to Parse File

Discussion started by: atticuss