10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Shell : bash that comes with RHEL 6.7
I have SQL scripts like below. I want to convert all the text in these files to lower case except the strings enclosed within single quotes .
Any idea how I can achieve this ?
$ cat sample.txt
SELECT ... (6 Replies)
Discussion started by: John K
2. Shell Programming and Scripting
I am trying to find a way to change first letter in a word from lower case to upper case. It should be done for each first word in text or in paragraph, and also for each word after punctuation like
. ; : ! ?I found the following command
sed -i 's/\s*./\U&\E/g' $@ filenamebut... (7 Replies)
Discussion started by: georgi58
3. Shell Programming and Scripting
I want to change the out put of a decode file from lower to upper. i used tr command but facing issue.
if ]; then
cp .sqlpass.Z $$.temp.Z
sed -e s/sqlpass/$$.sqlpass/ $$.temp >... (5 Replies)
Discussion started by: nag_sathi
4. Shell Programming and Scripting
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
fgrep "2000YUYU" /export/home/oracle/TST/data.dat | tr '' ''... (12 Replies)
Discussion started by: tsbiju
5. Shell Programming and Scripting
Is there a command that can switch a character variable from UPPER case to lower case?
foreach AC ( ABC BCD PLL QIO)
set ac `COMMAND($AC)`
Thanks a lot! (3 Replies)
Discussion started by: rockytodd
6. Shell Programming and Scripting
i have a data array as followes.
i need all english letters to be change to lower case. So i am expecting to see
If i have to copy this data in... (8 Replies)
Discussion started by: usustarr
7. Shell Programming and Scripting
I what to add option to existing sed code to convert target file to lower case
sed -e "s/REUSE/SET/g" \
-e "s/NORESETLOGS/RESETLOGS/g" \
T102_ccf.sql > target.sql
Thanks (2 Replies)
Discussion started by: zam
8. Shell Programming and Scripting
I have a script which extracts values from a Database (A persons name) and puts it into a variable in my script IE: $NAME
However the Value in the DB is all in uppercase and contains the users first name and last name
> echo $NAME
What I need is only the... (7 Replies)
Discussion started by: grahambo2005
9. Shell Programming and Scripting
URGENTLY NEEDED A SCRIPT TO SELECT AND DELETE LOWER AND MIXED CASE RECORDS FROM A COLUMN IN A TABLE.
FOR EXAMPLE : Table name is EMPLOYEE and the column name is CITY
and the CITY column records will be: Newyork
... (1 Reply)
Discussion started by: abhilash mn
10. UNIX for Dummies Questions & Answers
How can convert a Lower case variable value to an upper case in the kron shell script. (3 Replies)
Discussion started by: dchalavadi