08-30-2011
Script to parse a file faster
My example file is as given below:
conn=1 uid=oracle
conn=2 uid=db2
conn=3 uid=oracle
conn=4 uid=hash
conn=5 uid=skher
conn=6 uid=oracle
conn=7 uid=mpalkar
conn=8 uid=anarke
conn=1 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.10.5.6 to 10.18.6.5
conn=2 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.20.35.10 to 10.18.6.5
conn=3 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.30.35.19 to 10.18.6.5
conn=4 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.40.35.11 to 10.18.6.5
conn=5 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.50.35.12 to 10.18.6.5
conn=6 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.10.35.14 to 10.18.6.5
conn=7 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.20.35.15 to 10.18.6.5
conn=8 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.20.35.16 to 10.18.6.5
I need to write a scipt which will grep "uid=oracle" and find the IP address the connection is initiated from
using the connection ID "conn=x"
This is a sample file which I have kind of simplified and the actually file is in GBs.
I tried doing this using the cat and for loop but it takes atleast 2 days to complete the script.
Is there a faster way to do this using perl or awk?
I would like an output something like this:
connid=x IP=w.x.y.z
Any help would certainly be appreciated!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am faced with a :confused: tricky problem to parse a data file ( May not be a tricky problem to the scripting guru's ).
Here is what I am faced with. I have a file with multiple rows of data and the rows are not of fixed length. "|" is used as a delimiters for individual columns and each row... (3 Replies)
Discussion started by: yajaykumar
3 Replies
2. UNIX for Advanced & Expert Users
hi all,
i have a html file something similar to this.
<tr class="evenrow">
<td class="data">added</td><td class="data">xyz@abc.com</td>
<td class="data">filename.sql</td><td class="modifications-data">08/25/2009 07:58:40</td><td class="data">Added TK prof script</td>
</tr>
<tr... (1 Reply)
Discussion started by: sais
1 Replies
3. Shell Programming and Scripting
Hi Everybody,
I have an XML file containing some data and i want to extract it, but the specific issue in my file is that the data is repeated some times like the following example :
<section1>
<subsection1>
X=...
Y=...
Z=...
<\subsection1>
<subsection2>
X=...
Y=...
Z=...... (2 Replies)
Discussion started by: yassine
2 Replies
4. Shell Programming and Scripting
Raw Results:
results|192.168.2|192.168.2.1|general/udp|10287|Security Note|For your information, here is the traceroute from 192.168.2.24 to 192.168.2.1 : \n192.168.2.24\n192.168.2.1\n\n
results|192.168.2|192.168.2.1|ssh (22/tcp)|22964|Security Note|An SSH server is running on this port.\n... (2 Replies)
Discussion started by: jroberson
2 Replies
5. UNIX for Dummies Questions & Answers
Hello !
I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so...
As said in the title, I want to read a csv file with a bash script.
Here is a sample of the file:
... (4 Replies)
Discussion started by: Grhyll
4 Replies
6. Shell Programming and Scripting
Hi Friends,
I have a requirement to parse a properties file having a key=value pairs.
i need to count the number of key value pairs in the properties file and iterate through each key-value pair. I have written the script to read the number of lines from the property file, but cannot... (2 Replies)
Discussion started by: prashdeep
2 Replies
7. Shell Programming and Scripting
Dear All-
My requirement is as below, need your inputs please
1]
I have a file name Param.txt which contains the below data
#GLOBAL#
PARAM_VALUE=N
.............
............
CTRY=UK
.........
2] Next, I want to write a script which will check for some condition (lets assume... (1 Reply)
Discussion started by: sureshg_sampat
1 Replies
8. Shell Programming and Scripting
I am using Internet Explorer v10 at work and regularly need to import my personal Firefox bookmarks over. Long story short, I have found the import falling over on any bookmark elements which are over 256 characters.
The bookmark file contains bookmarks of this format:
<DT><A... (4 Replies)
Discussion started by: ozgadgetguy
4 Replies
9. Shell Programming and Scripting
Hi all, I need help for a script that pulls out a series of numbers from a file (attached file) Basically I need a parse to write me in a variable: 9d424312 Can someone help me? Thank you (2 Replies)
Discussion started by: gianvitolinuxs
2 Replies
10. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Hi all, I need help for a script that pulls out a series of numbers from a file (attached file) Basically I... (1 Reply)
Discussion started by: gianvitolinuxs
1 Replies
LEARN ABOUT PHP
sqlsrv_server_info
SQLSRV_SERVER_INFO(3) SQLSRV_SERVER_INFO(3)
sqlsrv_server_info - Returns information about the server
SYNOPSIS
array sqlsrv_server_info (resource $conn)
DESCRIPTION
Returns information about the server.
PARAMETERS
o $conn
- The connection resource that connects the client and the server.
RETURN VALUES
Returns an array as described in the following table:
Returned Array
+-----------------+----------------------------+
|CurrentDatabase | |
| | |
| | The connected-to database. |
| | |
+-----------------+----------------------------+
|SQLServerVersion | |
| | |
| | The SQL Server version. |
| | |
| SQLServerName | |
| | |
| | The name of the server. |
| | |
+-----------------+----------------------------+
EXAMPLES
Example #1
sqlsrv_server_info(3) example
<?php
$serverName = "serverNamesqlexpress";
$conn = sqlsrv_connect( $serverName);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$server_info = sqlsrv_server_info( $conn);
if( $server_info )
{
foreach( $server_info as $key => $value) {
echo $key.": ".$value."<br />";
}
} else {
die( print_r( sqlsrv_errors(), true));
}
?>
SEE ALSO
sqlsrv_client_info(3).
PHP Documentation Group SQLSRV_SERVER_INFO(3)