Shell Programming and Scripting

Hi,

I've no problems filtering text in awk but whenever I try to filter date format such as 03022013, I couldn't get awk to filter the item out.

Any tips?

Can you explain what do you mean by filter?

Please post some sample data and show us what did you try and what issues you are facing?

Hi,

Code:

	echo -e "Date(ddmmyyyy): \c"
	read datte
	echo -e "User ID: \c"
	read userid
	awk /$userid/,/$datte/'{print $1"\t"$2"\t"$6"\t"$5"\t"$4}' samplefile

I am trying to filter out user and login date.
I am running a LAST -command

Make sure the date is in ddmmyyyy format

Try this code:

Code:

awk -v U="$userid" -v L="$datte" '$0~U&&$0~L{ print $1"\t"$2"\t"$6"\t"$5"\t"$4}' samplefile

OR

Code:

awk -v U="$userid" -v L="$datte" '$0~U&&$0~L{ print $1,$2,$6,$5,$4}' OFS='\t' samplefile

It still is not clear what you want. If you only want to print lines that match both $userid and $datte, the script bipinajith provided should do what you want.

If you want to print sets of lines starting with a line that matches $userid and want to print that line and the lines following it up to and including the next line that contains $datte, change the && in bipinajith's code to ,.

If you want to print any line that matches $userid or matches $datte, change the && to ||.

Thank you so much for the replies.

I've tried out the code given.
I wanted print any line that matches $userid and matches $datte.
So far when I try enter $userid it can filter but when I enter $datte e.g. 03022013 nothing comes out.

Can you post sample data from your file: samplefile