topic Re: Urgent help in scripting in Operating System - HP-UX

Urgent help in scripting

SAM_24 — Wed, 21 May 2003 04:00:07 GMT

Hi,

I need to replace the date format in the access log file from

word dd/mm/yy to
word mm/dd/yy

How to accomplish using any one of these tools sed or awk or perl?

Any help is appreciated.

Thanks.

Re: Urgent help in scripting

Michael Tully — Wed, 21 May 2003 04:14:12 GMT

Try this:

$ sed 's/mm\dd/dd\/mm/' outputfile

Regards
Michael
"When I have trouble spelling, it's called fat finger syndrome"

Re: Urgent help in scripting

SAM_24 — Wed, 21 May 2003 04:31:59 GMT

Tully,

I think I didn't explain well.

My log file contains data :

user1 15/05/2003
user3 20/04/2003
user1 23/03/2003

Your suggestion just changes the letters mm/dd.

Thanks.

Re: Urgent help in scripting

Jordan Bean — Wed, 21 May 2003 04:46:05 GMT

perl -pi.bak -e 's/(\s)(\d\d)\/(\d\d)\//\1\3\/\2\//;' logfile

Re: Urgent help in scripting

Jordan Bean — Wed, 21 May 2003 04:48:07 GMT

perl -pi.bak -e 's[(\s)(\d\d)/(\d\d)/(\d\d)][\1\3/\2/\4];' logfile

Re: Urgent help in scripting

malay boy — Wed, 21 May 2003 04:49:41 GMT

Hi,
Try this :
cat test|while read u1 u2
do
date1=`echo $u2|cut -f1 -d/ `
date2=`echo $u2|cut -f2 -d/ `
date3=`echo $u2|cut -f3 -d/ `
echo $u1 $date2"/"$date1"/"$date3
done

test is your filename.

regards
mB

Re: Urgent help in scripting

Balaji N — Wed, 21 May 2003 05:00:25 GMT

[balajin@redpenguin tmp]$ cat a.txt
abcd 10/11/03
abcd 10/12/03
abcd 10/13/03
abcd 10/14/03
abcd 10/15/03
abcd 10/16/03
[balajin@redpenguin tmp]$ awk '{a=$1; b=substr($2,0,2);c=substr($2,4,2); d=substr($2,6);print a " " c "/" b d}' a.txt
abcd 11/10/03
abcd 12/10/03
abcd 13/10/03
abcd 14/10/03
abcd 15/10/03
abcd 16/10/03

-balaji

Re: Urgent help in scripting

Jean-Louis Phelix — Wed, 21 May 2003 05:12:42 GMT

Hi,

This sed will do it :

input :

user1 15/05/2003
user3 20/04/2003
user1 23/03/2003

sed 's;$[0-9][0-9]$/$[0-9][0-9]$$/[0-9][0-9][0-9][0-9]$;\2/\1\3;'

output :

user1 05/15/2003
user3 04/20/2003
user1 03/23/2003

Regards.

Re: Urgent help in scripting

Leif Halvarsson_2 — Wed, 21 May 2003 07:19:30 GMT

Hi,
Another awk example:

while read a b
do
echo $a `echo $b |awk 'BEGIN { FS = "/"; OFS = "/" }
{ print $2,$1,$3 }'`
done

Re: Urgent help in scripting

John Meissner — Wed, 21 May 2003 10:28:21 GMT

cat file |
while read line
do
var1=$(echo $line | awk '{print $1}'
var2=$(echo $line | awk '{print $2}' | awk -F/ '{print $1}'
var3=$(echo $line | awk '{print $2}' | awk -F/ '{print $2}'
var4=$(echo $line | awk '{print $2}' | awk -F/ '{print $3}'

echo $var1 $var3"/"$var2"/"$var4 >> newfile
done

Re: Urgent help in scripting

SAM_24 — Wed, 21 May 2003 20:31:30 GMT

Thank you all.

You are all masters!!!

Re: Urgent help in scripting

Francisco J. Soler — Wed, 21 May 2003 21:38:54 GMT

Hi,
Yes, i know it, it is too late, but i was traveling the last days. Anywere, this is my answer:

awk -F"[ \t/]" '{printf("%s %s/%s/%s\n",$1,$3,$2,$4)}' logfile

Cheers.

Frank.