Search Results

To copy file
cp source dest
To get the current directory detail
pwd

Try this

egrep '[^]0-9a-zA-Z:;<>=\?@\[\\\^\_`]' <filename>

This will give you the current shell
echo $0
This will give you the login SHELL
echo $SHELL

cat -vet <filename>
This will display all the control characters. ^ and $ represents the start and end of Line.

This?

$ cat smp.ksh
#!/bin/ksh
num=00000100
print $num
typeset -i num
print $num

$ ./smp.ksh
00000100
100
$

This?

ls -lt | egrep '*CLIENTINVOICE[0-9]*.archived'

In the first command, I am taking the files with name "abc_*.txt". Since i have used -t in the ls command, the file which is created recently will always come first. Then awk will pass the filenames...

Just include that in a shell script

#!/bin/ksh
in_total=`cat in_file | awk -F: '{in_total += $1 * 86400 + $2 * 3600 + $3 * 60 + $4} END {printf "%d\n",in_total} '`
out_total=`cat out_file | awk...

To retain the latest file created with name abc*.txt and to remove the remaining,

ls -lt abc_*.txt | awk '{if(NR!=1) print $9}' | xargs -i rm {}

Another approach. This is based on the...

I seem to have misunderstood the requirement. Hope below is the required soln.

$ sed '$ s/^\(.*\)$/\1qrst/' xyz.txt
abcdef
ghijklm
nopqrst

Using sed

$ cat xyz.txt
abcdef
ghijklm
nop
$ sed '$ a\qrst' xyz.txt
abcdef
ghijklm
nop
qrst
$ sed '$ a\qrst' xyz.txt > abc.txt
$ mv abc.txt xyz.txt
$ cat xyz.txt
abcdef
ghijklm
nop...

Please try this

$ cat smp.csh
#!/bin/ksh
for i in `cat smp`
do
num=`echo $i | sed 's/^.*[a-zA-Z]0*\([0-9]*\)$/\1/'`
chr=`echo $i | sed 's/^\(.*[a-zA-Z]0*\)[0-9]*$/\1/'`
(( num1 = num + 1 ))...

Using awk


$ awk -F"," '{gsub(/ .00/,"0.00",$0);gsub(/ \./,"0.",$0);print $0}' tmp.txt
RECORD ID,CLIENT,CUSTOMER NAME,2883,12:05,8, 16.39, 191.34
RECORD ID,CLIENT,CUSTOMER...

Try this

sed -e 's/ \.00/0.00/g' -e 's/ \(\.[0-9]*\)/0\1/g' -e 's/,\(\.[0-9]*\)/0\1/g' tmp.txt

Hope this helps

$ awk -F"," '{gsub(/ .00/,"0.00",$7);gsub(/ .00/,"0.00",$8);print $1","$2","$3","$4","$5","$6","$7","$8}' tmp.txt
RECORD ID,CLIENT,CUSTOMER NAME,2883,12:05,8, 16.39, 191.34...

Using a script

$ cat smp.csh
#!/bin/ksh
for i in `cat smp`
do
num=`echo $i | sed 's/^\([a-zA-Z]*0*\)\([0-9]*\)$/\2/'`
chr=`echo $i | sed 's/^\([a-zA-Z]*0*\)\([0-9]*\)$/\1/'`
(( num1 = num +...

I found this book (http://www.amazon.ca/Introduction-UNIX-Forouzan/dp/0534951597) very useful for beginners.

Will this help?

$ cat tmp
%is xxx = 123
$ sed 's/^\(%is xxx = \)[0-9]*\( *.*\)$/\11234\2/g' tmp
%is xxx = 1234

Try this command


sed '/\/home\/test\/filelist.txt/ d' srcfile

$ cat sample
1234 9876 6789 5677 3452
9087 4562 1367 2678 7891
$ sed 's/\( \)\{1,\}/,/g' sample
1234,9876,6789,5677,3452,
9087,4562,1367,2678,7891
$

or

$ sed 's/ \+/,/g'...

The colon should not cause any problems. Oracle will do internal type conversion if the "code" column is number.

It's weird !!. I ran your script with the table and column names replaced with valid table and column names in my database. It works perfectly for me.

Are these columns code and ctrl_perd valid in your database? Did you execute these queries in SQL Plus?

Did you try this

cp file1.txt newDirectory/file1_`date +"%Y%m%d_%H%M"`.txt

text deleted..


Sorry.. Understood the requirement wrongly