10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I currently have flat file with 32 columns. The field delimiter is cntl-A ( \x01). The file has been extracted from an oracle table using a datastage job. However, in the 6th field, the data contains additional control -A characters which came as a part of the table data.
I need... (12 Replies)
Discussion started by: harsha1238
12 Replies
2. Red Hat
Hi Guys,
We receive some huge files on to Linux server. Source system use FTP mechanism to transfer these files on our server. Occasionally one record is getting corrupted while transfer, some control characters are injecting into the file. How to fix this issue ? please advice ?
Sample... (2 Replies)
Discussion started by: srikanth38
2 Replies
3. Shell Programming and Scripting
Hello,
How can I view control and special characters of a text file?. For example, space, tabs, new line chars etc.
Can I use hexdump for it?
Thanks (3 Replies)
Discussion started by: reddyr
3 Replies
4. Shell Programming and Scripting
Hi All,
In my output file i am getting control m character and also the line feeds at different places and with different combinations, the content of the file is supposed to be in a single line but if there is a line feed in between then from there onwards it's going into new line.
I tried... (7 Replies)
Discussion started by: Bipin Kumar
7 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I need to remove control m character from a file.
Steps which i am doing in shell script are:
1) We are comparing the header of the file to the database table header
Here the file header has control-m characters. How do i remove it.
Please help. Below are the steps i am using,... (12 Replies)
Discussion started by: abhi_123
12 Replies
6. Shell Programming and Scripting
I have developed a small script to remove the Control M characters that get embedded when we move any file from Windows to Unix. For some reason, its not working in all scenarios. Some times I still see the ^M not being removed. Is there anything missing in the script:
cd ${inputDir}... (7 Replies)
Discussion started by: vskr72
7 Replies
7. Shell Programming and Scripting
Hi,
I want to removing ^M characters from a file and combine the line with the next line.
ex:
issue i have:
ABC^M^M
DEF
solution i need:
ABCDEF
I found that you by using the following command you can remove new line characters.
tr -d '\r' < infile.csv > outfile.csv
still... (10 Replies)
Discussion started by: mwrg
10 Replies
8. Shell Programming and Scripting
Hi,
I have a .xml file in unix. We are passing this file through a xml parser.
But we are getting some control characters from input file and XML parser is failing for the control character in file.Now I am getting following error,
Error at byte 243206625 of file filename_$.xml:
Error... (1 Reply)
Discussion started by: fantushmayu
1 Replies
9. Shell Programming and Scripting
Can anyone seem to know how to find out whether a UNIX text file has 'hidden' control characters?
Can I view them using 'vi' by some command line options?
If there are control characters in a text file which are invisible/hidden.. then how do I get rid of them?
Your intelletual answers are... (6 Replies)
Discussion started by: kewl_guy
6 Replies
10. UNIX for Dummies Questions & Answers
I have a file, which when you look at it, appears as if it has spaces....
But sometimes, it is has tab or Nulls or some other character which we are not able to see.....
How to find what character exactly it is in the file, where ever we are seeing a space... (Iam in solaris)... (1 Reply)
Discussion started by: thanuman
1 Replies
DROPLANG(1) PostgreSQL Client Applications DROPLANG(1)
NAME
droplang - remove a PostgreSQL procedural language
SYNOPSIS
droplang [ connection-options... ] langname [ dbname ]
droplang [ connection-options... ] --list | -l dbname
DESCRIPTION
droplang is a utility for removing an existing programming language from a PostgreSQL database. droplang can drop any procedural language,
even those not supplied by the PostgreSQL distribution.
Although backend programming languages can be removed directly using several SQL commands, it is recommended to use droplang because it
performs a number of checks and is much easier to use. See DROP LANGUAGE [drop_language(7)] for more.
OPTIONS
droplang accepts the following command line arguments:
langname
Specifies the name of the backend programming language to be removed.
[-d] dbname
[--dbname] dbname
Specifies from which database the language should be removed. The default is to use the database with the same name as the current
system user.
-e
--echo Displays SQL commands as they are executed.
-l
--list Shows a list of already installed languages in the target database (which must be specified).
droplang also accepts the following command line arguments for connection parameters:
-h host
--host host
Specifies the host name of the machine on which the server is running. If host begins with a slash, it is used as the directory for
the Unix domain socket.
-p port
--port port
Specifies the Internet TCP/IP port or local Unix domain socket file extension on which the server is listening for connections.
-U username
--username username
User name to connect as
-W
--password
Force password prompt.
ENVIRONMENT
PGDATABASE
PGHOST
PGPORT
PGUSER Default connection parameters.
DIAGNOSTICS
Most error messages are self-explanatory. If not, run droplang with the --echo option and see under the respective SQL command for details.
Check also under psql(1) for more possibilities.
NOTES
Use createlang(1) to add a language.
EXAMPLES
To remove pltcl:
$ droplang pltcl dbname
SEE ALSO
createlang(1), DROP LANGUAGE [drop_language(7)]
Application 2002-11-22 DROPLANG(1)