the following range matching works great but i wish to add a blank line after each range result set... which i've tried and researched to no avail
MY INPUT DATA:
Quote:
typeset lfile_selection_count=${1}
typeset lcyclename_suffix=_cycle${lfile_selection_count} cat > ${Vsqlfile} <<BATCH_EOF -- THESE OPTION SETTINGS MAKE SURE THAT THE SQL IS PROCESSED -- CORRECTLY WITHIN THE CONTEXT OF THIS SCRIPT. SPECIFICALLY, -- THE SCRIPT WILL STOP AND ISSUE AN ERRROR MESSAGE ON THE FIRST -- SQL STATEMENT THAT RETURNS A NON-ZERO CONDITION CODE (-S ON). -- THE SCRIPT WILL NOT COMMIT ANY CHANGES UNTIL THE COMMIT -- STATEMENT IS EXECUTED AT THE END OF THE SCRIPT (I.E. -C AUTOCOMMIT -- IS OFF). tHE PROMPT IS TURNED OFF SO THAT IT IS NOT SHOWN -- IN THE OUTPUT. CONNECT TO ${Gdb2instance_ar} user ${Gdb2user} using XXXXXXXX; UPDATE COMMAND OPTIONS USING p OFF; UPDATE COMMAND OPTIONS USING s ON; LIST COMMAND OPTIONS; alter table ${Gmdsschema}.PLN_RV_SM activate not logged initially; INSERT into ${Gmdsschema}.PLN_RV_SM SELECT a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GE/GG') AND a11.TRNCTN_TYP_CD = 'TI' ; alter table ${Gmdsschema}.PLN_RV_SM activate not logged initially; INSERT into ${Gmdsschema}.PLN_RV_SM selecta11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GI') AND a11.TRNCTN_TYP_CD = 'TI' ;
CURRENT CODE I'M USING:
RESULTS I'M GETTING:
Quote:
SELECT a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GE/GG') AND a11.TRNCTN_TYP_CD = 'TI' ; select a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GI') AND a11.TRNCTN_TYP_CD = 'TI' ;
RESULT I looking to get: (see blank line after semicolumn)
Quote:
SELECT a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GE/GG') AND a11.TRNCTN_TYP_CD = 'TI' ;
select a11.CLNDR_MTH_ID, a11.CMPNY_GRP_CD, a12.CRPRT_ST_CD, a11.FNCTN_CD, a11.PLCY_RV_CTGRY_CD, 'RQ', a11.PLN_CRNT_YR_CN FROM ${Gmdsschema}.PLN_RV_SM a11 join ${Gmdsschema}.CRPRT_ST a12 on (a11.CRPRT_ST_CD = a12.CRPRT_ST_CD) WHERE a11.cmpny_grp_cd in ('GI') AND a11.TRNCTN_TYP_CD = 'TI' ;
Awsome!...... in my quest to understand the hows and whys of SED, ( so as not to just be a coding monkey ) could you explaing the part in red
sed -n '/select/I,/;/{/;/G;p}
i beleive the p is to output the results and /;/G to add a blank line..
but I don't understand the purpose/usage of the construct { .... } and the ; between G & p
Can you help me understand so i can use this in the future?
The braces limit the scope of the following code to the previously matched records (the records that satisfy the range pattern).
So, the G command (append the hold space to the pattern space, in this case the hold space is empty so you get only the newline character)
will apply on for the records that match the pattern /;/ (the last line of your paragraph).
The only printed book I know is sed & awk by Dale Dougherty and Arnold Robbins.
[quote=radoulov;302324253]The braces limit the scope of the following code to the previously matched records (the records that satisfy the range pattern).
So, the G command (append the hold space to the pattern space, in this case the hold space is empty so you get only the newline character)
will apply on for the records that match the pattern /;/ (the last line of your paragraph).
quote]
i understand that the /;/ as part of /;/Gmeans that newline will go after the semicolum... BUT...
i'm refering to the following semicolum , between the G and p
Also..... if {coding} limits the scope to the previous command.... is that the same as using the -e to apply code to just previously execute expression?
Thanks again for your patience with my questions.
-----Post Update-----
Quote:
Originally Posted by radoulov
You could try something like this:
Some versions of sed support the I (for case Insensitive) flag:
Thanks, the first worked, but the /I,/ didn't work...
but i had to add back after the select [ ]*$ because: (which works for 1 & 2 below but not 3)
1. i don't want to catch occurences of where select is part of word, (e.g. selection)
2. i want to catch when select is the only word on the line.
3. i want to catch when select is not the only word on the line, and is followed by a space
***** see that i've modified the test data to show you *****
Input: START
OS:: UNIX
Release: xxx
Version: xxx
END
START
OS:: LINUX
Release: xxx
Version: xxx
END
START
OS:: Windows
Release: xxx
Version: xxx
ENDHere i am trying to get all the information between START and END, only if i could match OS Type.
I can get all the data between the... (3 Replies)
Hi Guys,
I am stuck in between and seeking help here.
Requirement: A script that will run every morning which will connect to Mysql database and run the query to inform us about the holidays (it will also check if there were any holidays during last 2 business days). So the three queries are... (11 Replies)
Hi
Im trying to do the following in sed. I want to delete any blank line at the start of a file until it matches a pattern and then stops. for example:
Input
output:
I have got it to work within a range of two patterns with the following:
sed '/1/,/pattern/{/^]*$/d}'
The... (2 Replies)
I use the following as part of a script to correct for a faulty hostname file.
# get the domain name
read -r thehostname < /etc/hostname
dom="$(echo $thehostname | cut -d'.' -f2)"
numchar=${#dom}
if
then
echo "It appears as though the hostname is not correctly set."
echo "Hostname has... (5 Replies)
Hello...
I have a file which contain certain number of records.
I want to generate another file from this file which will contain 1st line as a blank line & after every 5 lines one blank line will be inserted. How to achieve this through shell scripting?
Thanks... (5 Replies)
Hi,
I need to match lines after a pattern, upto the first blank line.
Searched in web and some forums but coulnt find the answer.
where <restart_step> =
10 -- Execute query
20 -- Write the contents to the Oracle table
30 -- Writing Contents to OUTPUT... (7 Replies)
Hello friends,
I have a C source code containing sql statements. I use the following sed command to print all the sql blocks in the source code....
sed -n "/exec sql/,/;/p" Sample.cpp
The above sed command will print the sql blocks based on the pattern "exec sql" & ";"... (2 Replies)
I followed the egrep example given in the thread "parse text or complex grep ?". It is exactly what I need...except... how do I insert a blank line after the second line? My exact command is:
egrep 'patt1|patt2' filename
the result is:
patt1
patt2
patt1
patt2
and so on. I would... (2 Replies)