Search Results

Hello

I am asked to run around 5-6 SQL queries in a shell script and take a note of the time taken to execute each query to a file. How do I get the time taken to run the individual SQL queries

Try with removing those *


$ nawk -v a=1 -v b=1 'NR==FNR{if($0 ~ /NEXT/){a++}else{A[$0]++;X[a]=X[a]?X[a] FS $0 : $0}next}{
if($0 ~ /NEXT/){b++}else{Y[b]=Y[b]?Y[b] FS $0 : $0}}END{
for(i in...

Awesome, it worked... you are a rock star.. thanks a lot

I need the original order (in the first 2 files) as it is

---------- Post updated at 06:55 AM ---------- Previous update was at 06:53 AM ----------

Pamu - I am a bit naive when it comes to...

Thanks Pamu. But I get this error


couldn't set locale correctly
couldn't set locale correctly
awk: syntax error near line 1
awk: bailing out near line 1

The 2 files contains the data one below the other as shown in the examples above and if you take a look at both the files, the common data is available in both the text files with the ***NEXT***...

Hello all,

I have 2 text files.
For example:
File1.txt contains data

A
B
C
D
****NEXT****
X
Y
Z
****NEXT****
L
M
N

and File2.txt contains data

Hi - I cant think of generalizing this further.

Hi I recently joined a project where I have been asked to generate a report using shell script accessing UNIX box.
I have no idea on how to do it as I am a beginner and learning shell scripts.
...

Hi I recently joined a project where I have been asked to generate a report using shell script accessing UNIX box.
I have no idea on how to do it as I am a beginner and learning shell scripts.
...