Search Results

Am I doing something wrong , it's not removing the last occurance of "UNION ALL" . lets think about only removing the last occurance of "UNION ALL"

Code is:

#! /usr/bin/ksh
. ~/.profile
...

Thanks .. anythig using sed or awk commands or any native unix commands.

I have text file as follows and would like to remove the last occurance of "UNION ALL" string and replace @@ with single quote (').

Input text in file is

with temp as (
( select -----------...

Thanks .. I could able to do it.. So much of good information .. keep sharing..

I was looking for the similar kind of example without any attachments. How do I go with this on AIX.

I removed the related ATTACH code and also tried with
uuencode --base64
(and )
uuencode...

Thanks it worked like a champ ..

I was having some header line in the file so I wanted to skip them..

Anyway.. I removed the header and then your instruction worked like champ..

Can we merge find | cat | awk command in...

Hi ,

I am trying to write something to find the size of particular type of files in a directory & it's subdirectory and sum the size .. These types of file are found at directory level or its...

Thanks to all ... it worked like a champ.

Shyam

Thanks ... tried set -f & set +f , but it didn't work ..

I was trying to replace a string ( for eg - @@asterisk@@ to * ) in variable using


cat $INFILE | while read LINE
do
stmt1=`echo $LINE | sed 's/@@asterisk@@/\*/g'`
stmt=$stmt' '$stmt1...

Thanks for the solution .. i am close but few more thingsg..

it is putting comma for every space in the result " see INSERT,INTO,schema.table,VALUES,(" and " 0,);commit ;"

Code
-------...

Hi ,

I have below file with 13 columns. I need 2-13 columns seperated by comma and I want to append each row with a string "INSERT INTO xxx" in the begining as 1st column and then a variable...

I did this in a simple way using the SPLIT command..

third=`echo "scale=0; $tfile_len1 / 3" | bc`
split -l $third $TEMPDIR/file_wo_tail.out $TEMPDIR/run

This created 3 files as runaa, runab...

If I hardcode the values for $one_third & $two_third variable .. I am getting what I want ..

So how can I have the variable in AWK cmd..

Hi,

I got a file which may have 100 - 500 rows with header and trailer... based on the total number of real rows ( excluding header and trailer) I want to break the file in 3 or 4 files ..
...

Thanks ... I realise that I missed...$

I am missing something here, I have a file which contains only one line and that is either a number or character string. I am trying to read the file and assign that value to a variable and here it...

What about if you need to extract the lines based on 5th charater in first word.

I did it ..

Here is the code
-----------------------------------------------------------------
#!/bin/ksh
#========================================================
count_args() # Returns...

Having some trouble with usage of for loop and displaying words. Basically I had 3 words( some times more )
in the variable. I want to get one at a time to process.

I am new to unix scripting so...