Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[tunnie]

I used to be fairly good with Unix Awk/Grep sort commands, but I'm doing some now for the first time in about 4 years and I can remember sod all!   

(btw I'm using Cygwin)

I've got a standard Apache log file, that I'm working from, in which I can successfully awk and sort, eg:

$ awk '{print $7}' ManU\ GameBShort.log | sort -u

From the apache log that gives me lots of rows like this, but with all kinds of usernames and other images ect:

users/tunnie/channels/1301/streams/14157378
users/tunnie/channels/1301/streams
users/tunnie/streams/delete

I removed a lot of custom directories and the username from example above, can't really post that! But in essence I only want to grep unique rows with unique username (tunnie) and "/1301/streams"

So all I want as a result of my command is a list of:

users/user1/channels/1301/streams
users/user2/channels/1301/streams
users/user3/channels/1301/streams
users/user4/channels/1301/streams

And drop all the other junk, but I'm flagging on how I can do this. 

Help!

[cem_devecioglu]

Tunnie its been nearly 20 years since I left unix..
 
but here is a short way: list the directories and re-direct it to a text file..
 
copy the file to windows and using sql import and export manager load them in sql server
 
then select distinct field name from table where field like '%Tunnie%parameter' 

[tunnie]

well that is one way, yeah pipe it into a text file. But my SQL is just about as good as my Unix.

Got less and less techy in my current position, its set to be even less soon 

[cem_devecioglu]

or something like this
find . -exec grep -H "something" {} \;

[tunnie]

that would still leave me in same position, it would work for single username i think, but i want all users, but unique requests 

[cem_devecioglu]

that would still leave me in same position, it would work for single username i think, but i want all users, but unique requests 

really cant remember   
 
I need to read several documents again to solve your problem   too tired sorry

[cem_devecioglu]

or pipe it to a text file and write a small vb or javascript whatever

[tunnie]

or wait until my unix buddies are in tomorrow morning, which is looking increasingly like best option 

[cem_devecioglu]

or wait until my unix buddies are in tomorrow morning, which is looking increasingly like best option 

yep

[dbug]

Should be easy Tunnie, but like cem, my unix is 20+ years old.  Like cem I'd pipe it into a text file and sort from there

[cem_devecioglu]

Should be easy Tunnie, but like cem, my unix is 20+ years old.  Like cem I'd pipe it into a text file and sort from there

 

[Andy B]

WTF is the question? 

[Vamps]

WTF is the question? 

Never mind the question, read the replies......   I have absolutely no idea what they are talking about..........and I pressed the translate button.....

[Andy B]

WTF is the question? 

Never mind the question, read the replies......   I have absolutely no idea what they are talking about..........and I pressed the translate button.....

Likewise ............ 

[tunnie]

Should be easy Tunnie, but like cem, my unix is 20+ years old.  Like cem I'd pipe it into a text file and sort from there

Should be easy, embarrassed asking unix guys in the morning really