06-04-2008
Last word substitution
Ok this is last question of the day from my side .
I have this file and I want to replace the last letter " , " with " ) " .
The input file is
#cat zip.20080604.sql
CONNECT TO TST103 ;
SET SESSION_USER OPSDM001 ;
SET CURRENT SCHEMA OPSDM001 ;
CREATE VIEW OPSDM001.vw_zip SELECT (
ZIP_CD ,
ZIP_TYP_SRC_CD ,
ZIP_TYP_CD ,
ZIP_ROW_END_DT ,
ZIP_ROW_EFF_DT ,
ZIP_LST_2_CD ,
ZIP_FST_3_CD ,
UPDT_DT WITH
ST_NUM_CD ,
ST_ABBR_CD ,
PST_CNTY_NM ,
PST_CNTY_CD ,
LOAD_DT WITH
HCFA_CNTY_NM ,
HCFA_CNTY_CD ,
CTY_NM ,
Desired output is
#cat zip.20080604.sql
CONNECT TO TST103 ;
SET SESSION_USER OPSDM001 ;
SET CURRENT SCHEMA OPSDM001 ;
CREATE VIEW OPSDM001.vw_zip SELECT (
ZIP_CD ,
ZIP_TYP_SRC_CD ,
ZIP_TYP_CD ,
ZIP_ROW_END_DT ,
ZIP_ROW_EFF_DT ,
ZIP_LST_2_CD ,
ZIP_FST_3_CD ,
UPDT_DT WITH
ST_NUM_CD ,
ST_ABBR_CD ,
PST_CNTY_NM ,
PST_CNTY_CD ,
LOAD_DT WITH
HCFA_CNTY_NM ,
HCFA_CNTY_CD ,
CTY_NM )
Thanks ,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have data that looks something like this:
term1/term2/2005-12-01 13:20:30/term4
I need to make it look like this:
term1/term2/20051201132030/term4
I am using a csh script. I have tried to do it by first converting the date/time to the format in which I want it, and then replacing it... (1 Reply)
Discussion started by: oprestol
1 Replies
2. Shell Programming and Scripting
Greetings.
I am struggling with a shell script to make my life simpler, with a number of practical ways in which it could be used. I want to take a standard text file, and pull the 'n'th word from each line such as the first word from a text file.
I'm struggling to see how each line can be... (5 Replies)
Discussion started by: tricky
5 Replies
3. Shell Programming and Scripting
$ cat ggg
/E*Fare/testteam/public/pf3/nggfstatic/4k-pf3_3.case
REGION1:
/E*Fare/dist/src/nggfstaticbase/EFare/Server
CODEBASE1:
/dev_tools/LINUXMTP-4/EFS070718E/EFare/Server
DATABASE1: nggfstatic
SCRIPT: /efare1/admin/ezlcn/scripts/pf3_3_scriptlist.input
PROLOGINITSIZE not yet set
You... (4 Replies)
Discussion started by: Sangal-Arun
4 Replies
4. Linux
Hi I am trying to substitute 2 words on the same line with _S02 as suffix. Like this .
IN "TSOPS09" INDEX IN "TSOPIX09" ;
to
IN "TSOPS09_S02" INDEX IN "TSOPIX09_S02" ;
i used the following code to make the change , it works fine for first substitution not the second one .
... (6 Replies)
Discussion started by: capri_drm
6 Replies
5. Linux
Hi ,
I have bunch of sql file which contain UHCDEV01 in them . I want to replace all the UHCDEV01 with UHCETL01 in all the files. I have written this code which shows correct output on sh -x but doesn't change the output file .
#cat change_dbname.shl
#!/bin/ksh... (1 Reply)
Discussion started by: capri_drm
1 Replies
6. Shell Programming and Scripting
I am trying to substitute something with sed and what I want is to substitute a whole
word and not part of a word. ie
sed 's/class/room/g' filename
will substitute both class and classes into room and roomes which is not what i want
Grep for instance can use the -w option or <>
grep -w... (7 Replies)
Discussion started by: gikay01
7 Replies
7. Shell Programming and Scripting
Hi all,
I am trying to write a script substituting one word in a particular file with another word (sed) but I'm having trouble creating the backup file. The following are my instructions:
The Unix program sed is useful for making simple substitutions throughout an entire file. But one of... (0 Replies)
Discussion started by: Hoppy56
0 Replies
8. UNIX for Dummies Questions & Answers
I have a file that has the words I want to find in other files (but lets say I just want to find my words in a single file). Those words are IDs, so if my word is ZZZ4, outputs like aaZZZ4, ZZZ4bb, aaZZZ4bb, ZZ4, ZZZ, ZyZ4, ZZZ4.8 (or anything like that) WON'T BE USEFUL.
I need the whole word... (6 Replies)
Discussion started by: chicchan
6 Replies
9. UNIX for Dummies Questions & Answers
Hi!!
I am trying to write a program which allows me to count how many times I used the same word in a text:
{$0 = tolower ($0)
gsub (/_]/, "", $0)
for (i = 1; i <= NF; i++)
freq++
}
END {
for (word in freq)
printf "%s\t%d\n", word, freq
It seems work but... (3 Replies)
Discussion started by: ettore8888
3 Replies
10. UNIX for Beginners Questions & Answers
I have a multicolumn text file with header in the first row like this
The headers are stored in an array called . which contains I want to search for each elements of this array from that multicolumn text file. And I am using this awk approach
for ii in ${hdr}
do
gawk -vcol="$ii" -F... (1 Reply)
Discussion started by: Atta
1 Replies
LEARN ABOUT REDHAT
set_session_authorization
SET SESSION
AUTHORIZATION(7) SQL Commands SET SESSION AUTHORIZATION(7)
NAME
SET SESSION AUTHORIZATION - set the session user identifier and the current user identifier of the current session
SYNOPSIS
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION
DESCRIPTION
This command sets the session user identifier and the current user identifier of the current SQL-session context to be username. The user
name may be written as either an identifier or a string literal. The session user identifier is valid for the duration of a connection;
for example, it is possible to temporarily become an unprivileged user and later switch back to become a superuser.
The session user identifier is initially set to be the (possibly authenticated) user name provided by the client. The current user identi-
fier is normally equal to the session user identifier, but may change temporarily in the context of ``setuid'' functions and similar mecha-
nisms. The current user identifier is relevant for permission checking.
The session user identifier may be changed only if the initial session user (the authenticated user) had the superuser privilege. Other-
wise, the command is accepted only if it specifies the authenticated user name.
The SESSION and LOCAL modifiers act the same as for the regular SET [set(7)] command.
The DEFAULT and RESET forms reset the session and current user identifiers to be the originally authenticated user name. These forms are
always accepted.
EXAMPLES
SELECT SESSION_USER, CURRENT_USER;
current_user | session_user
--------------+--------------
peter | peter
SET SESSION AUTHORIZATION 'paul';
SELECT SESSION_USER, CURRENT_USER;
current_user | session_user
--------------+--------------
paul | paul
COMPATIBILITY
SQL99
SQL99 allows some other expressions to appear in place of the literal username which are not important in practice. PostgreSQL allows iden-
tifier syntax ("username"), which SQL does not. SQL does not allow this command during a transaction; PostgreSQL does not make this
restriction because there is no reason to. The privileges necessary to execute this command are left implementation-defined by the stan-
dard.
SQL - Language Statements 2001-04-21 SET SESSION AUTHORIZATION(7)