06-08-2007
the DBA got back to me saying that fo rthem it showed special chracters instead of quotes in the comment line........actually i created this doc in notepad an dthen FTP on unix server
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file which looks like this, I have stripped most of the columns:
2006,UCA,"02452","NM","1","M","84",123,aa
2006,UCA,"02452","NM","1","L","84",123,bb
2006,UCA,"02452","NM","1","L","84",432,cc
2006,UCA,"02452","NM","1","L","33",213,dd
2006,UCA,"02452","NM","1","L","33",124,ee... (3 Replies)
Discussion started by: sumeet
3 Replies
2. Shell Programming and Scripting
Hi
I have a text file which has two sets of lines repeating for "n" number of times.Some data is printed between the two lines.I want to retrieve all the data thats there in between those two set of lines.I have the string value of those two set of lines.
To be much more clearer
... (4 Replies)
Discussion started by: chennaitomcruis
4 Replies
3. Shell Programming and Scripting
Hi,
I ahve a file where the format is as given below:
qqq dfsf gdfjkg gjdosjg jkflsjd 21
fdksdlf fsdnkfl lkdfsgjld 45
laefsdl fsdlfksl fsdklflk gfsdl 56
I need to replace the last number by space or delete the last number in each line. (by using... (6 Replies)
Discussion started by: jisha
6 Replies
4. Shell Programming and Scripting
i want to use multple sql count statements and store these count values in unix variable but in one connection only i.e. in only 1 time database should be hit ,which is the main requirement. (1 Reply)
Discussion started by: sw@pnil
1 Replies
5. Shell Programming and Scripting
Hi.
please help me to write the following query in a shell script.
the Query is :select no,salary from emp_info where name='$var_name'
the following is my code.
#! /bin/sh
var_name=$1
sqlplus -s user/pwd@DB << EOF
select no,salary from emp_info where name="'$var_name'";... (4 Replies)
Discussion started by: little_wonder
4 Replies
6. Programming
Hi Guys,
Can someone please help me on adding/inserting a variable to an sql scipt? Basically I want to assign today's date. As shown below..
set head off;
set linesize 300;
set pagesize 200;
spool /opt/oracle/temp/output.txt
select value,count(*) as totalcount from pmowner.pinpebasev... (11 Replies)
Discussion started by: pinpe
11 Replies
7. Programming
Dear Mates,
I am trying to write a macro to replace with its arguments with singles quotes around each argument.
#define DECR(a,b,c,d,e) decr('a','b','c','d','e')
if the usage is
DECR(k,e,y,s,\0)
I want it to be replaced with the following
decr('k','e','y','s','\0')
However it... (2 Replies)
Discussion started by: tamil.pamaran
2 Replies
8. Shell Programming and Scripting
Hi, consider a file which has data such as
"random text",912345,"54","finish"
"random text",9991236745,"9954","finish"
I want to replace the numbers that don't have double quotes around them with ones that do; so the output should be
"random text","912345","54","finish"
"random... (4 Replies)
Discussion started by: Storms
4 Replies
9. Shell Programming and Scripting
RHEL 6.2/Bash shell
root user will be executing the below script. It switches to oracle user logs in using sqlplus and tries to
run the below UPDATE statement. All the commands after su -c are enclosed in a single quote delimited by semicolon.
The execution has failed because the quotes... (3 Replies)
Discussion started by: omega3
3 Replies
10. Shell Programming and Scripting
I have file with are delimited by pipe(|) symbol, I wanted those to be removed except the ones which are enclosed in double quotes.
If your quote file is:
|Life is |Beautiful"|"Indeed life |is beautiful too|"|"But unix is fun| is not"|"
It should return:
Life is Beautiful"|"Indeed life is... (1 Reply)
Discussion started by: Sathyapts
1 Replies
LEARN ABOUT OPENDARWIN
mapscrn
MAPSCRN(8) International Support MAPSCRN(8)
NAME
mapscrn - load screen output mapping table
SYNOPSIS
mapscrn [-V] [-v] [-o map.orig] mapfile
DESCRIPTION
The mapscrn command is obsolete - its function is now built-in into setfont. However, for backwards compatibility it is still available as
a separate command.
The mapscrn command loads a user defined output character mapping table into the console driver. The console driver may be later put into
use user-defined mapping table mode by outputting a special escape sequence to the console device. This sequence is <esc>(K for the G0
character set and <esc>)K for the G1 character set. When the -o option is given, the old map is saved in map.orig.
USE
There are two kinds of mapping tables: direct-to-font tables, that give a font position for each user byte value, and user-to-unicode
tables that give a unicode value for each user byte. The corresponding glyph is now found using the unicode index of the font. The command
mapscrn trivial
sets up a one-to-one direct-to-font table where user bytes directly address the font. This is useful for fonts that are in the same order
as the character set one uses. A command like
mapscrn 8859-2
sets up a user-to-unicode table that assumes that the user uses ISO 8859-2.
INPUT FORMAT
The mapscrn command can read the map in either of two formats:
1. 256 or 512 bytes binary data
2. two-column text file
Format (1) is a direct image of the translation table. The 256-bytes tables are direct-to-font, the 512-bytes tables are user-to-unicode
tables. Format (2) is used to fill the table as follows: cell with offset mentioned in the first column is filled with the value mentioned
in the second column. When values larger than 255 occur, or values are written using the U+xxxx notation, the table is assumed to be a
user-to-unicode table, otherwise it is a direct-to-font table.
Values in the file may be specified in one of several formats:
1. Decimal: String of decimal digits not starting with '0'
2. Octal: String of octal digits beginning with '0'.
3. Hexadecimal: String of hexadecimal digits preceded by "0x".
4. Unicode: String of four hexadecimal digits preceded by "U+".
5. Character: Single character enclosed in single quotes. (And the binary value is used.) Note that blank, comma, tab character and '#'
cannot be specified with this format.
6. UTF-8 Character: Single (possibly multi-byte) UTF-8 character, enclosed in single quotes.
Note that control characters (with codes < 32) cannot be re-mapped with mapscrn because they have special meaning for the driver.
OTHER OPTIONS
-V Prints version number and exits.
-v Be verbose.
FILES
/usr/share/consoletrans is the default directory for screen mappings.
SEE ALSO
setfont(8)
AUTHOR
Copyright (C) 1993 Eugene G. Crosser
<crosser@pccross.msk.su>
This software and documentation may be distributed freely.
Local 20 March 1993 MAPSCRN(8)