Search Results

Thanks!!! It works perfectly!!!!

Hello,

I have a log file that has several sections "BEGIN JOB, End of job" like in the following example:


19/06/12 - 16:00:57 (27787398-449294): [I] BEGIN JOB j1(27787398-449294) JOB1
...

I have an AWK command that goes like this:

awk '/from BOITE_AUX_LETTRES/,/end-procedure|END-PROCEDURE|end-select|END-SELECT/ {print FILENAME,FNR,$0}' *prp

I get my results as follows:
...

It worked just fine!!! Thanks a lot!

I have 2 files with exactly the same information (with header and separated by ";") and what I would like to do is print (for both files!) the columns that are different and also print the "key"...

I adapted it a little bit and it worked! :b:

Sorry, it didn't work. :( I thought it had to do with the fact that we're searching for "FROM" and "WHERE" clauses in uppercase so I added a

tr [:lower:] [:upper:]

before the AWK instruction,...

Thks! I will try it!

Somthing like:

TABLE1, TABLE2, ...

or

TABLE1
TABLE2

just the names of the tables appearing in the FROM clause.
Thks.

---------- Post updated at 03:16 PM ---------- Previous update...

Just the name of the tables separated by , or any other delimiter or one table name per line in the output. No preference. Just want to know the tables involved without having to look deeply in the...

....
Pro*C sentences
....
/*SQL 1*/
EXEC SQL SELECT t1.field1, t1.field2
INTO :w_field
FROM TABLE1 t1, TABLE1 t2
WHERE t1.field1 = t2.field1
AND t1.ID = :wl_id;
....
Pro*C sentences
.......

Hello,

I have a Pro*C program which contains SQL sentences, such as:


....
Pro*C sentences
....
/*SQL 1*/
EXEC SQL SELECT t1.field1, t1.field2
INTO :w_field
FROM TABLE1 t1, TABLE1 t2...

Hello !

I have a simple AWK script that prints sections of files containing SELECT or select up to ";".
It goes like this:
awk '/select|SELECT/,/;/' filename

Now I would like to add a blank...

Thank you very much!
I understand the idea.

I changed it to

a[$1]<=2

and I got 2 ocurrences instead of 1.

Thanks bartus11!
Just to understand better what I'm doing, what does the part

a[$1]=1

mean?

Hello,

I have a file which looks like:

%_SPE_RDP_NUM_ECH(7)*************%
%_SPE_RDP_NUM_ECH(70)************%
%_SPE_RDP_NUM_ECH(71)************%
%_SPE_RDP_NUM_ECH(72)************%...

Thks a lot!!!!!

I get the following error:

Unrecognized command: /\"/,$/d

I want to delete in all lines of a file, from a given position (in fact, the position where I find the character ") until the end of line.
How can I do this?
Thks in advance.

Yes, it worked!
I was trying to achieve it in one regex all together.
But it worked just fine.

Thanks a lot!

Hello everybody,

I'd like to know how is it I should write a regex in unix to match a string not followed by another string (anywhere in the line).

To be more specific, I want to find lines...

Thank you very much for your help!!! I could make it work just perfect!!!!!

I have the following sed command:

sed...

Thks very much! I worked it out!
My last question would be: is there a way to save the contents of the modified file to the SAME file?
Thks again!

OK. Can you please tell me how it should be done?
Thks!!!!