09-06-2012
Sorry for the confusion
Let me give you a complete example what I am trying to achieve.
1. Below is the log file structure where I need 2,5 and 14th column of the logs after grepping through the linkId=1ddoic.
Log file structure:-
abc.com 20120829001415 127.0.0.1 app none11111 sas 0 0 N clk Mozilla/5.0 id=82c6a15ca06b2372c3b3ec2133fc8b14 referrer=google.com linkId=1ddoic
abc.com 20120829001416 127.0.0.1 dyn UD3BSAp8appncXlZ UD3BSAp8app4xHbz 0 0 N page Mozilla/5.0 id=82c6a15ca06b2372c3b3ec2133fc8b14 segments=
2. Now for the 1st log you can see I have invalid(none11111) 5th column. So I have to look for the actual 5th column value. 'id' column will help you to find that. So you have to run another grep based on the 'id' value so that you can find the actual 5th column in the same log file.
3. If you see the second log it has the exact matching 'id' value. So what I have to do I have to take the 5th column(UD3BSAp8appncXlZ) from the second log instead of the invalid one(none11111).
Output:-
20120829001415, UD3BSAp8appncXlZ, linkId=1ddoic
Note:- I have bunch of log files where I have to perform the above procedure. But I have to come up with a single file as output after grepping through all the log files.
It has a format like abc-2012-10-01_00000,abc-2012-10-01_00001.... etc.
Hope this time it makes clear.
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
Thanks for looking into it.
Last edited by kmajumder; 09-06-2012 at 05:48 PM..
10 More Discussions You Might Find Interesting
1. Programming
Hi gurus
I am not a C programmer but I need to read and write files on a computer on LAN using IP address.
Suppose on a computer that has an IP 192.168.0.2
Any help or code example. I did in JAVA using URL, but do not know how to do in ANSI-C.
In java:
-------
URL url = new... (3 Replies)
Discussion started by: lucky001
3 Replies
2. UNIX for Advanced & Expert Users
Hi All,
Not sure if this would be in a dummies sectiin or advanced. I'm looking for a script if someone has doen something like this.
I have list of files -
adc_earnedpoints.20070630.txt
adc_earnedpoints.20070707.txt
adc_earnedpoints.20070714.txt
adc_earnedpoints.20070721.txt... (1 Reply)
Discussion started by: thebeginer
1 Replies
3. UNIX for Dummies Questions & Answers
Hi my prob statement is to create a new file or to append to the 1tst file the followign chages.
File 1: txt file.
portfolio No a b c d
abc 1 Any Any Any charString
cds 2 values values values charString
efd 3 can can can charString
fdg 4 come come come charString... (4 Replies)
Discussion started by: szchmaltz
4 Replies
4. UNIX for Dummies Questions & Answers
Hi all,
I have the following shell script code which tries to sftp and writes the log into the log file.
TestConnection ()
{
echo 'Connection to ' $DESTUSERNAME@$DESTHOSTNAME
$SETDEBUG
if ]; then rm $SCRIPT ; fi
touch $SCRIPT
echo "cd" $REMOTEDIR >> $SCRIPT
echo "quit" >>... (10 Replies)
Discussion started by: valluvan
10 Replies
5. Programming
Hello everybody,
I'm trying to code a program which makes the following:
It sends an ARP request frame and when it gets the reply, extracts the IP address of source and writes it to a .txt file. This is gonna be done with many hosts (with a for() loop), so, the text file would look like... (2 Replies)
Discussion started by: Zykl0n-B
2 Replies
6. Shell Programming and Scripting
Hi All,
Please help me in writing data to a file in one row.
In database there is a column which contains large data which does not fit in the file in one row. The column contains list of paths. I want to write these paths to a file in one row.
Please find the code below writes :
... (2 Replies)
Discussion started by: rajeshorpu
2 Replies
7. Shell Programming and Scripting
Need to develop a unix shell script for the below requirement and I need your assistance:
1) search for file.log and file.bad file in a directory and read them
2) pull out "Load_Start_Time", "Data_File_Name", "Error_Type" from log file
4) concatinate each row from bad file as... (3 Replies)
Discussion started by: mlpathir
3 Replies
8. Programming
In the code below i try to write and read from a file, but i get unexpected results, like after writing i cannot open the file, and when reading the file the value entered earlier is not shown
bool creat_fragments(int nFragment)
{
int fd, rand_value;
char frag_path, buf;
for(int... (8 Replies)
Discussion started by: saman_glorious
8 Replies
9. Shell Programming and Scripting
Hi
I am trying to extract information out of a file but keep getting grep cant open errors
the code is below:
#bash
#extract orders with blank address details
#
# obtain the current date
# set today to the current date ccyymmdd format
today=`date +%c%m%d | cut -c24-31`
echo... (8 Replies)
Discussion started by: Bruble
8 Replies
10. Shell Programming and Scripting
Hello all
As part of my TUI - (line based) Text User Interface, i do have 2 commands to assist working with conf files.
Now, for me they work, but since i wrote them, i automaticly use them they way they should be used... you know what i mean. ;)
Anyway, they are designed to read 'simple'... (3 Replies)
Discussion started by: sea
3 Replies
LEARN ABOUT SUNOS
wbemlogviewer
wbemlogviewer(1M) wbemlogviewer(1M)
NAME
wbemlogviewer - start WBEM Log Viewer
SYNOPSIS
/usr/sadm/bin/wbemlogviewer
The wbemlogviewer utility starts the WBEM Log Viewer graphical user interface, which enables administrators to view and maintain log
records created by WBEM clients and providers. The WBEM Log Viewer displays a Login dialog box. You must log in as root or a user with
write access to the rootcimv2 namespace to view and maintain log files. Namespaces are described in wbemadmin(1M).
Log events can have three severity levels.
o Errors
o Warnings
o Informational
The WBEM log file is created in the /var/sadm/wbem/log directory, with the name wbem_log. The first time the log file is backed up, it is
renamed wbem_log.1, and a new wbem_log file is created. Each succeeding time the wbem_log file is backed up, the file extension number of
each backup log file is increased by 1, and the oldest backup log file is removed if the limit, which in turn is specified in the log ser-
vice settings, on the number of logfiles is exceeded. Older backup files have higher file extension numbers than more recent backup files.
The log file is renamed with a .1 file extension and saved when one of the following two conditions occur:
o The current file reaches the specified file size limit.
o A WBEM client application uses the clearLog() method in the Solaris_LogService class to clear the current log file.
o A WBEM client application uses the clearLog() method in the Solaris_LogService class to clear the current log file.
o A user chooses Action->Back Up Now in the Log Viewer application.
Help is displayed in the left panel of each dialog box. Context help is not displayed in the main Log Viewer window.
The WBEM Log Viewer is not the tool for a distributed environment. It is used for local administration.
The WBEM Log Viewer allows you to perform the following tasks:
View the logs
Set properties of log fiClick Action->Log File Settings to specify log file parameters and the log file directory.
Back up a log file Click Action->Back Up Now to back up and close the current log file and start a new log file.
Open historical log fileClick Action->Open Log File to open a backed-up log file.
Delete an old log file Open the file and then click Action->Delete Log File. You can only delete backed-up log files.
View log record details Double-click a log entry or click View->Log Entry Details to display the details of a log record.
Sort the logs Click View->Sort By to sort displayed entries. You can also click any column heading to sort the list. By default,
the log entries are displayed in reverse chronological order (new logs first).
EXIT STATUS
The wbemlogviewer utility terminates with exit status 0.
/var/sadm/wbem/log/wbem_log
WBEM log file
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWwbcor |
+-----------------------------+-----------------------------+
wbemadmin(1M), init.wbem(1M), mofcomp(1M), attributes(5)
3 Jan 2000 wbemlogviewer(1M)