topic Re: How to change date format using sed or awk in Operating System - HP-UX

How to change date format using sed or awk

Eric Leung_2 — Tue, 20 Jul 2004 03:29:06 GMT

Re: How to change date format using sed or awk

Jose Mosquera — Tue, 20 Jul 2004 03:49:29 GMT

Hi,

Try this script procedure:

TEXT=`cat text_file`
FIELD_1=`echo $TEXT|awk -F"|" '{ print $1 }'`
FIELD_2=`echo $TEXT|awk -F"|" '{ print $2 }'`
FIELD_3=`echo $TEXT|awk -F"|" '{ print $3 }'`
FIELD_4=`echo $TEXT|awk -F"|" '{ print $4 }'`
DATE=`echo $FIELD_2|awk -F"/" '{ print $3"/"$1"/"$2 }'`
echo "$FIELD_1|$DATE|$FIELD_3|$FIELD_4" > text_file

Rgds.

Re: How to change date format using sed or awk

Steve Steel — Tue, 20 Jul 2004 04:08:42 GMT

Re: How to change date format using sed or awk

Eric Leung_2 — Tue, 20 Jul 2004 04:19:00 GMT

Thanks for your replies and maybe I need to define my problem more clearly.

Actually, I need to change five different files and the number of fields varies from file to file. Unfortunately, there are more than 20 fields in some files.

Hence, it would be better if there is a function to handle all these files.

Thanks.

Re: How to change date format using sed or awk

Muthukumar_5 — Tue, 20 Jul 2004 04:20:47 GMT

It is good to operate it with the awk. There are | and / can be used as field separators.

FLD="abcdefg|MM/DD/YY|00:30|xyzxyz"
echo "$(echo $FLD | awk -F "|" '{ print $1 }')|$(echo $FLD | awk -F "|" '{ print $2 }' | awk -F "/" '{ print $3"/"$2"/"$1 }')|$(echo $FLD | awk -F "|" '{ print $3"|"$4 }')"

It will give you the desired output.

Re: How to change date format using sed or awk

Mark Grant — Tue, 20 Jul 2004 04:21:56 GMT

or

perl -pne 's#(..)/(..)/(..)#$3/$1/$2#' textfile > newfile

Re: How to change date format using sed or awk

Muthukumar_5 — Tue, 20 Jul 2004 04:31:41 GMT

Get line by line from a file as,

fun1()
{
filename=$1
newfile=/tmp/test.log
rm -f $newfile
touch $newfile

while read line; do
echo line | grep -q "[[:alpha:]]*/[[:alpha:]]*/[[:alpha:]]"
if [[ $? -eq 0 ]]; then
operation of awk to change the format >> newfile
else
echo $file >>newfile
done < filename

mv $newfile $filename

}

fun1
...
fun1

It is good to have your file examples to make a scipt appropriate to ur requirement.

Re: How to change date format using sed or awk

Fred Ruffet — Tue, 20 Jul 2004 05:25:35 GMT

Re: How to change date format using sed or awk

curt larson_1 — Tue, 20 Jul 2004 09:21:50 GMT

cat yourFile |
awk -F"|" '{
split($2,a,"/");
$2=sprintf("%s/%s/%s",a[3],a[1],a[2]);
print $0;
}'

i don't have my computer running to test that, but it should be pretty close to what you need.

Re: How to change date format using sed or awk

curt larson_1 — Tue, 20 Jul 2004 09:29:49 GMT

sed would be something like this:

sed 's!|$..$/$..$/$..$|!|\3/\1/\2|!' yourFile

Re: How to change date format using sed or awk

Rodney Hills — Tue, 20 Jul 2004 09:32:10 GMT

If you want a function within "awk" so you can call it multiple times, here is a sample-

echo "hello|10/17/03|abc" | awk -F\| 'function swap(x) { split(x,a,"/"); return a[3] "/" a[2] "/" a[1] };{print swap($2)}'

You can call "swap" multiple times within your awk script. My sample is a one-line but you may want to put the awk script into a seperate file.

HTH

-- Rod Hills