Search results for query: *

Guys thanks for your replies. p5wizard, thanks for your helpful tip. that would have probably been my next question. :-D I also found another useful one liner, which I am going to use: tail +`grep -n "keyword" file | cut -d: -f1` file

Hi, I need help in writing a shell (awk / sed / shell). I am trying to write a script to be able to automate my daily check of the syslog and oracle alert logs. Basically, I need to be able to extract the file from a point onwards based on date. So lets say today is 4 th Sept, I want to...

Hi all Awk gurus, I have a simple (i hope) query here. I have this awk script which I want to be able to reformat a file. The file looks like this: Manufactured Item | ZLDRS1 ULTRA·STRIP III,DUAt 0649-1046-48 | BOX,275 X 197 X| BN | 2450-0054-01 | LBL,BLNK,PAP TH| A0 |...

Thanks That worked BG

I am trying to figure out shift date for the night shift. So if the time is before 8:00 am then it is the night shift of the previous day. So I wrote this formula to do it. But it gives an error on the 3rd line (start of the if) saying "a date-time is needed here" I don't understand it... need...

Hi , Newbie to Sybase db. Could anyone help me out... How do I connect to a Sybase (SQL Anywhere 5.5) database. Thanks Bhas

Hi, I am reporting off a view in sql server. I had a report created from the view. Now iif I go and add a field to the view the crystal report does not see this new field. Is there any way to do this or do I have to create a new report. I tried repointing to the same view (database --> set...

Hi I wanted to calculate the number os working days in a query. So I went about wrint a function which accepts the start date end date and the calculates the number os working days: Public Function getWorkingDays(startDate As String, endDate As String) On Error GoTo Err_getWorkingDays...