INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

awk : matcing timestamps, date, and manipulations colums to create a new file

awk : matcing timestamps, date, and manipulations colums to create a new file

awk : matcing timestamps, date, and manipulations colums to create a new file

(OP)
Hi,

I would like to have some help from you because i am not programmer in awk.

the first file is :

Code:

3184 2014-07-28 04:15 global.Remote-Access 10.111.8.25 81.245.6.25 tcp 3268
3035 2014-07-28 04:16 global.Remote-Access 10.111.8.12 81.245.6.25 tcp 3268


The second file is:

Code:

1 Jul 28 04:12 2014-07-28 id967254(group3)[attribute1 attribute2] Tunneling: User with IP 10.111.8.12 10 connected
1 Jul 28 04:15 2014-07-28 id920767(group2)[attribute3 attribute4 .... attribute n] Tunneling: User with IP 10.111.8.25 connected
1 Jul 28 04:16 2014-07-28 ID926072(group3)[attribute1 attribute2] Tunneling:User with IP 10.111.8.12 connected


the 3rd file will be:
if the IP address in the file 1 is equal to file 2 , and
if the time ( hh:mm ) and date (yyyy-mm-dd) and group and attribute in the file 1 are equal to file2, then displays:

Code:

3184 04:15 2014-07-28 global.Remote-Access id920767(group2)[attribute3 attribute4 .... attribute n] 10.111.8.25 81.245.6.25 tcp 3268
3035 04:16 2014-07-28 global.Remote-Access ID926072(group3)[attribute1 attribute2] 10.111.8.12 81.245.6.25 tcp 3268

Note: idXXXXX may have other many attribute in [ ]

any help will appreciated...

Rgds
FXSME

RE: awk : matcing timestamps, date, and manipulations colums to create a new file

Quote (FXSME)

. . .
the 3rd file will be:
if the IP address in the file 1 is equal to file 2 , and
if the time ( hh:mm ) and date (yyyy-mm-dd) and group and attribute in the file 1 are equal to file2, then displays:
There are no "group and attribute" in file 1.
thumbsdown

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

RE: awk : matcing timestamps, date, and manipulations colums to create a new file

(OP)
Yes you are right

Errata:

the 3rd file will be:
if the IP address in the file 1 is equal to file 2 , and
if the time ( hh:mm ) and date (yyyy-mm-dd) in the file 1 are equal to file2, then displays:

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close