Search Results

Hi All, i have written small tool with the help of Unix & Oracle. Now I want to keep the logic with me for sometime, however at the same time want to distribute the tool to large audience. Can anyone...

Hi All,
Below is my requirement. Whatever coming in between ' ', needs to delete.

Input File Contents:
==============
This is nice 'boy'
This 'is
bad
boy.' Got it

Expected Output...

Hi All,
I am having following file and I want to delete 1 row last column.

Current File Content:
================
procedure test421 put_line
procedure test321 test421
procedure test521...

Pls find the input.

create or replace procedure test421
is
begin
sass/*asasas
---sasasas/*dsdsds;
sasas*/
dbms_output.put_line('SAURABH');--trtertre;...

Below code is not working. output is following.

create or replace procedure test421
is
begin
dbms_output.put_line('SAURABH');--trtertre;
END;


However expected out put is.
create or...

Thanks for reply again. It's working fine, however for below scenario, it's not.

Current:
==============
create or replace procedure test421
is
begin
/*
---sasasas/*dsdsds
*/
Testing is...

Not working with below scenario.

create or replace procedure test421
is
begin
/*
---sasasas/*dsdsds
*/
/*sasasas*/
dbms_output.put_line('SAURABH');
END;

Still I am getting same error.

The final command is...

fold -s -w 300 test.txt | awk -v RS='[[:space:]()\n]' -v Text='insert into xyz' '
BEGIN {
Words_count = split(tolower(Text),...

Delete everything comes in between /* & */.

Current File:
====================
create or replace procedure test421
is
begin
/*
---sasasas/*dsdsds
*/
dbms_output.put_line('SAURABH');
END;...

Well, thanks for bearing with me aigles. Latest command is also not working ad I am getting "awk: Input line procedure test1 insert cannot be longer than 3,000 bytes.". errors. Anyway in future, if...

Tried with this, however getting below error. Attaching file test.txt for you refer your reference.

awk: The result procedure load_file of the gsub function
cannot be longer than 3,000...

I m getting memory coredump error as actual files having more than 15000 lines. Looks like gawk may work, so can you pls modify gawk command.

Thanks for your reply. Can you modify gawk command as well.



---------- Post updated at 09:07 AM ---------- Previous update was at 08:00 AM ----------

I am getting " Memory fault(coredump)"...

Hi All,
I have almost 1000+ files and I want to search specific pattern. Looking forwarded your input. Pls note that need to ignore words in between /* */
Search for: "insert into xyz" (Which...

Thanks for wonderful response. This is working fine for me, however I forget to mention one this, i.e. it could be "procedure" or "function". I need to consider both, however above code only taking...

Thanks for reply Cherry, however I do't want to execute via perl. I m looking for Unix command.

Hi All,
I have almost 1000+ files and I want to search specific pattern. Looking forwarded your input. Pls note that need to ignore words in between /* */
Search for: "insert into xyz" (Which...

Hi Franlin, Thanks again for response, however looks like you have placed hardcoded test, this name is not fixed. I can be anything, so I am looking for any word which is coming right after keyword...

Hi Franklin, thanks for reply, however this is not working for procedure test2. test2 is missing, the only issue because test2 available in new line. Can you pls reframe this as I am not that good in...

Hi All,
I have almost 1000+ files and I want to search specific pattern. Looking forwarded your input.

Search for: word1.word2 (Which procedure contain this word, I need procedure name in...