Search Results

Awesome Work Ravinder!! :-D

My colleague and me are really thankful to your constant efforts. And we really appreciate this. Finally we have completed with our scripting. :) :)

Thanks...

Hi Ravinder,

Thanks for the code. Its working absolutely as we needed. But we want the 'TOTAL' variable to be declared globally. But as we are trying to print the TOTAL variable outside the awk...

Hi Ravinder,

Thanks a ton for your previous answer to my post regarding grep time form string. Its working amazingly!

Now, i have stored this time in lastrestart.txt file as follows:
...

Hi RudiC,

The time will be runtime value. I cannot pass this static value through this as illustrated in your example.
I need the 5th field (07:55) to be cut which is separated by multiple...

Hi Guys,

I have following different lines separated by multiple spaces. And i need to cut only the time part (16:53) from the string. How can we achieve it?

remedy 29210 1 1 07:55 ? ...

Hi ravinder,

This worked exactly as I needed! :-)

Hi Ravinder,

It Worked!! :b::)

Thank You so much!

Actually, the data that we will get would be run time data. And the first two columns namely var1 and var2 are highly unprdedicatble...

Hi Pals,

I have a file which contains a set of similar lines, as follows:

Remedy Support Action Triggered by Incident Modification of type: ARA username2 ...

Hi Cero,

Thanks for debugging. Worked on tablename issue.

Now how do i add semicolon to output.sql since it is being written using the awk command as follows:

awk '{print "select * from...

Well, I'm now trying the following script where I'm trying to run a .sql file from this script. But when i open the output file everything is blank. Why is this so?

Script:
PATH=.................

Thanks for the quick reply Ravinder.

When i execute the following in my script (named demon_script.sh):

awk '{print "select * from apsdi-apaction where request_id= " $0}' demo.txt

i get...

Hi,

i want to do the following:

Grep the following kind of strings for the 15digit ID which is stored in filename1:

"14:06:51.396 [Aug-21-2015] INFO BMCREMEDYSD INPUT-ACTION Failed to...

It worked!! thanks a ton!!

Hi Guys,

Is it possible to grep only the Request ID 000000000038775 from the string:

19:37:22.429 [Aug-20-2015] INFO BMCREMEDYSD INPUT-ACTION Failed to retrieve Remedy Incident Modification...

Hi,
when i run this code i get the following error:

kh.awk: line 1: FNR: command not found
kh.awk: line 2: syntax error near unexpected token `{'
kh.awk: line 2: ` if (!($2 in gA)) {'

Can...

Hi vgersh99,

Thanks a ton for the solution!
But I would like to know the naming conventions you have used her such as gA, gAl, aAa, gC, aA since i would like to make some format changes in the...

HI All,

I'm embedding SQL query in Script which gives following output:

Assignee Group Total
ABC Group1 17
PQR Group2 5
PQR Group3 6
XYZ Group1 10
XYZ Group3 5

I have saved the...