Search Results

Orig file
==========
XX| ABCD9089929 | PEP | 20090114 | 0.00 | 2 | F1 | STATE
XX| ABCD9089933 | PEP | 20090114 | 0.00 | 2 | F1 | STATE
XX| ABCD9104256 | PEP | 20090114 | 357.50 | 2 | F2 |...

Can anyone help come up with an sql code for the below?

The fields are as follows:
SerialNum
GroupCode
TktType
DueDate
Amount

Examples values are:
1.
SN123456
GC0001
Start
15-OCT-2008...

Hi,
Anyone has an idea how to go about this?
Once the below logfile starts populating line by line, I want to send an email alert whenever the following keywords both appears, so users will know...

Hi,
The contents of my file is below:

Name,Location,Degree,Gender,Awards
Robert,Philadelphia,Accounting,Male,5
Jane,Chicago,Business,Female,2
Allan,New York,Engineering,Male,6...

Actually it is an executable file so we can not view the contents.
Basically, when I run this command, it will just display the below messages:
1. Show processes
2. Start process
3. Stop process ...

When I run this command (showstatus <username> <dbname>) in the prompt, the following will be displayed in the screen:
1. Show processes
2. Start process
3. Stop process
4. Go back to prompt...

Thanks so much radoulov, it worked :)

But do u mind explaining a bit on the code.
Appreciate it mate.

Hi perl gurus,

The below lines are the 1st few lines of my logfile to scan.
Based on this, i need to get the TOP5 UserIDs having the most activities/transactions, and the top5 tasks as well.
...

Thanks danmero.

Hi ynir,
I posted my expected output in the previous post :)
Appending 1, 2, 3, and so on at the end of the lines in the input file.
Thanks.

I would like to append the numbers 1, 2, 3, 4 and so on to the lines of the file:
Adam Wilkins | Colorado | 36
John Butler | Los Angeles | 47
Cassey Johnson | Minneapolis | 25
Albert Aniston |...

Anyone has an easy approach on the below please? :)
I want the output of my "ls" command to output only the 5th-9th characters only.

For example:
ls FILE*.txt
==>>
FILEXINOO123.txt...

This is great :)
ls file* | awk '{ ORS="|"; print; }'

But what if you want to put something in between?
For example:
file1|<filler1>|file2|<filler2>|file3|<filler3>|file4....

Thanks.