Search Results

Hi Team,
i am executing 3 scripts in background from 1 script and i want to send a message once the script gets completed.these scripts usually takes 1 hr to complete.

My sample script is below,...

Hi I want to set up a cron for every 15 minutes between some hours.
Can you tell whether the below command will work.
Getting confuse because my time goes from night to next day morning.
i want to...

Hi Don,

Can we do that in While loop.if i have a file which contain some pattern and i will check that pattern in file and if matches i want to get that content to output file.

Exp:Pattern.txt...

@Rudi:This is not working.i want to pass one record of Table.txt and search for that pattern and get the whole set from Input.txt and store into output.txt.

So in 1st instance i want to pass XYZ...

Hi Rudi,The code is working but i need to pass the pattern which is in Table.txt in loop.So in the Table.txt file may conatin multiple patterns.so i need to process those one by one and write into...

Hi,

I have to extract the whole set if a pattern matches.i have a file called input.txt

input.txt
------------
CREATE TABLE ABC
(
A,
B,
C
);
CREATE TABLE XYZ
(
X,
Y,
Z,
P,
Q
);

@Ravindra:The code for the 2nd scenario where i need to extract all the code between the parenthesis is not working

i need to extract data between two parenthesis
My input:
CREATE TABLE ABC
(
A,
B,
C,
D
);

I want to extract those data in between the two parenthesis.
My output:

A,
B,
C,
D

It is...

Thanks Ravinder for quick reply.Thats work.

One more thing if i want to extract something based on paranthesis....can you help.

Input:
exp1:
CREATE TABLE
(
A,
B,
C
)

o/p exp1:

A,...

Input:
/*in below example comma needs to remove after C*/
CREATE TABLE
(
A,
B,
C, ----comma needs to be removed
)AS SELECT
A,
B,
C, ----comma needs to be removed
FROM TABLE

/*in...

Hi Ravinder,

The column "C" is not always constant.So thats why i said based on the pattern before the one character which is comma(,) need to be removed.MAy be sometime more columns come..

Hi I have a file where i want to remove a char before a specific pattern.
exp:
CREATE TABLE
(
A,
B,
C, ----comma needs to be removed
)AS SELECT
A,
B,
C, ----comma needs to...

Hi,

How can i ignore case between 2 files in unix using COMM command.
2 input files are:
-bash-4.1$ more x2.txt
HELLO
hi
HI
raj

-bash-4.1$ more x3.txt
hello
hi
raj

COMM command:...

Hi Ravinder/Rudy,

Could you please explain what exactly this AWK is doing

Thanks RudiC and ravinder....its working

I Want to merge multiple lines based on the 1st field and keep into single record.

SRC File:

AAA_POC_DB.TAB1
AAA_POC_DB.TAB2
AAA_POC_DB.TAB3
AAA_POC_DB.TAB4
BBB_POC_DB.TAB1
BBB_POC_DB.TAB2...

Thanks disedorgue.....it's really useful......got my answer

@disedorgue:We can read line from file using For loop.
however your code is not working.The 2ns value coming wrong as its pulling data from /home/dbadmin path.

TAB_DAY|(((date_part('year',...

Hi,

i have a source file and have 3 columns and separated by "|" .i want to split this 3 columns in different variable.When i am executing this values indivisually giving correct result but when...