Search Results

this worked but its giving wrong results.
can we find the files created on specific dates

Hello this is not giving any result as the previous one

Hello All,

I have a directory containing of many .dat file, but with different naming conventions.

I want to delete files which are created before and on 10th September 2013.

I tried this...

thanks,
the escape character worked :)

The final output i need is

the variable is represented as $var

Hello I am trying to echo some string in file


echo " the variable is represented as $var"


When I execute the above code i just get

echo " the variable is represented as
How can I get ...

Hello Chubler_XL,

Thank you so much for the awesome reply.
It works exactly how I wanted.

Is there anyway we could add this into the snippet

After the apply keyword, there can be some other...

Hello All,

I have a file like this




APPLY
( 'INSERT INTO brdcst_media_cntnt (
cntnt_id
,brdcst_media_cntnt_cd
,cntnt_prvdr_cd
,data_src_type_cd
,cntnt_titl_nm
,cntnt_desc
...

Thanks for a detailed explanation MR.Bean

---------- Post updated at 03:57 PM ---------- Previous update was at 03:03 PM ----------

Hello,
For the second part of file.

I need the extract of...

Hello MR.Bean

That was exactly what I was looking for.

Can you please take some time and explain me how this works.

Thanks in Advance

Hello All,

I am extracting a part of file. the file looks as follows


USING CHARACTER SET UTF8 DEFINE JOB

(

DEFINE SCHEMA Flat_File_Schema
(
cntnt_id VARCHAR(10)
);

DEFINE...

Hello All,

The original file format is like this

USING CHARACTER SET UTF8 DEFINE JOB

(

DEFINE SCHEMA Flat_File_Schema
(
cntnt_id VARCHAR(10)
div_id VARCHAR(10)
);

DEFINE...

Hello All,

I have a file like this

Define schema flat_file_schema
(
a varchar(20)
,b varchar(30)
,c varchar(40)
);
(Insert into table (
a
,b
,c
) values
(
1
,2
,3
);

Hello,

My loop is like this



TPT_PATH='/home/ctl/tpt'
CP_PATH='/home/ctl/copy'

for line in filelist.txt ;
do
if [ -f $TPT_PATH/$line ]
then
echo...

Hello All

I have a file like this

abc.tpt.ctl
bdc.tpt.ctl
cdw.tpt.ctl

I have looped every line using the for Loop, now I want to take each line and cut the .tpt.ctl part of it and store it...

Thanks guys.

The solution worked perfectly:)
You guys rock:b:

No Solutions are working

Krishmaths - the solution provided by you is giving no output

Jotne - the solution provided by you is giving error
awk: /\)/exit} f; /\(/ && /INSERT/ {f=1}
awk: ^...

Hello krishmaths,

Thanks for your solution, but it does not give any output.

I observed my file and it came to this conclusion

INSERT into table (
x
,x
,x
,x
)VALUES
This is the...

somewhat close to what I need

awk '/INSERT/{getline;print}' filename

this gives

a

only the first line after the regexp satisfied

hello,

I might have bracket '(' before the one intended to use.
I want to find insert keyword and then use the bracket '(' after this keyword to extract what ever is in brackets.

Hello All,


I need to extract part of a file into a new file

My file is
Define schema xxxxxx

Insert into table
(
a
,b
,c
,d
)
values
(
1,
2,
3,

Thanks,

Worked like a charm.

Hello All,


I have file named filelist.txt

a.bteq.ctl
b.bteq.ctl
c.bteq.ctl

I want to replace the word bteq to tpt in this file.

I used this sed command
cat filelist.txt | sed...

Thanks.

Both the solutions works great.

Hello All,

I have csv file like this

1,"suzi","305
Barehills","Vancover",34256
2,"molly","456
beverleyhills","Minisotta",234876

I want to put a customized record terminator on every...