${parameter^} # Convert the first character in ${parameter} to uppercase
${parameter^^} # Convert all characters in ${parameter} to uppercase
${parameter,} # Convert the first character in ${parameter} to lowercase
${parameter,,} # Convert all characters in ${parameter} to lowercase
if not use tr
This User Gave Thanks to vidyadhar85 For This Post:
Hi All
I am trying to replace some character using Sed , but i also need to use case commands
like this :
x=`who am i`
opt=`echo ${x} | cut -f1 -d' '`
case $opt in
unix) 'UNX'
My script asks the user to enter the source server and it gets the results
it has to reaplace the above... (5 Replies)
Dear All
Could you please advice how do we convert a unix file to dos
I know one command,ux2dos, which somehow does not work to give desired output
Inputs on this is appreciated
Thanks,
Suresh (3 Replies)
Hi,
Iam trying to convert date and time to milliseconds which iam using in a script on Sun Solaris.
I have searched the posts on the forum but i could not get any solution.
The format iam using in script is:
date -u "Thu Dec 24 00:01:00 EST 2009"
But i get a bad command error.
... (6 Replies)
hi all,
i need to measure time difference between the time a process started, to the time it ended. i am assuming the following are the steps:
1. output 'date' command at start time
2. output 'date' command at end time
3. subtract the two
question is, how do i subtract the two time... (4 Replies)
Hello Unix Gurus :
It would be really appreciative if can find a solution for this .
I have records in a file .
I need to Capitalize the records based on condition .
For Example i tried the following Command
COMMAND -->
fgrep "2000YUYU" /export/home/oracle/TST/data.dat | tr '' ''... (12 Replies)
Hi Friends,
I am not able to conver character set from UTF-8 to IBM-284 throwing an error "cannot open convertor" . Could you please help me how to get out of this error.
Below command is working fine
iconv -f ISO8859-15 -t UTF-8 fromfile.txt > tofile.txt
But the below command is... (2 Replies)
Hi all,
I have a requirement to convert a file from one format to another.
Parent file:
to
i.e.,
1.) all the lines which begin with "Sample:", should be converted in such a way that entire text after ":" gets converted into all-lower case.
2.) all the lines which begin with... (7 Replies)
Hi All ,
I have a mainframe file which contains the data in EBCDIC unreadable format.I have downloaded this raw unreadable file from mainframe system to windows in text format then I pushed to Unix system.Now I want to convert this file to ASCII readable format file in unix.Can anyone advise me... (2 Replies)
I already know about the docx2txt program, and it's extremely helpful. ssconvert is also really helpful, but unlike docx2txt, it works both ways. How does one convert a .txt file to .docx via CLI, or is it even possible??
This:
docx2txt example.docx
results in making a .txt file out of... (2 Replies)
Discussion started by: Huitzilopochtli
2 Replies
LEARN ABOUT REDHAT
drop_database
DROP DATABASE(7) SQL Commands DROP DATABASE(7)NAME
DROP DATABASE - remove a database
SYNOPSIS
DROP DATABASE name
INPUTS
name The name of an existing database to remove.
OUTPUTS
DROP DATABASE
This message is returned if the command is successful.
DROP DATABASE: cannot be executed on the currently open database
You cannot be connected to the database you are about to remove. Instead, connect to template1 or any other database and run this
command again.
DROP DATABASE: may not be called in a transaction block
You must finish the transaction in progress before you can call this command.
DESCRIPTION
DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data. It can only be executed
by the database owner (usually the user that created it).
DROP DATABASE cannot be undone. Use it with care!
NOTES
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the shell script dropdb
[dropdb(1)], which is a wrapper around this command, instead.
Refer to CREATE DATABASE [create_database(7)] for information on how to create a database.
COMPATIBILITY
SQL92
DROP DATABASE statement is a PostgreSQL language extension; there is no such command in SQL92.
SQL - Language Statements 2002-11-22 DROP DATABASE(7)