Shell Programming and Scripting

file1
E106,0,1/9/1993,0,E001,E003,A,45200,3766.667,21.730769
E108,0,2/3/1995,0,E001,E003,A,15000,1250,7.211538
E109,0,06-mar-07,0,E001,E001,A,78000,6500,37.5
E110,0,09-dec-2008,0,E001,E001,A,56000,4666.667,26.923077
E104,0,06/04/1994,0,E001,E003,A,95000,7916.667,45.673077
E105,0,7/30/1993,0,E001,E003,A,87000,7250,41.826923
E106,0,1/9/1993,0,E001,E003,A,45200,3766.667,21.730769
E108,0,01-feb-2008,0,E001,E003,A,15000,1250,7.211538
E109,0,2/15/1995,0,E001,E001,A,78000,6500,37.5

I want to convert the date format to yyyymmdd for a every line in a file.

Please let me know on this....


Thanks in advance
cherry

Code:

cat file | sed -E 's/([0-9][0-9])-([[:alpha:]]+)-([0-9]{4})/\3\2\1/'

And case for month.

Thanks for code ....

But, iam getting the following error ....

-----------------------------------------------------------
sed: illegal option 'E'
usage: sed script [-anW] [file ...]
sed [-anW] [-e script] ... [-f script_file] ...[file ...]
--------------------------------------------------------------

can you explain the code ? Please help me .......

Code:

cat file | sed -e 's/([0-9][0-9])-([[:alpha:]]+)-([0-9]{4})/$3$2$1/'

Take out the Useless Use of Cat while you are at it.

I don't think basic sed knows about $1 $2 $3, try with \3\2\1 instead.

Code:

sed -e 's/([0-9][0-9])-([[:alpha:]]+)-([0-9]{4})/\3\2\1/' file

But then, if you have a really pedestrian sed, it probably doesn't grok [[:alpha:]] or {4} either.

Code:

sed -e 's/([0-9][0-9])-([A-Za-z]+)-([0-9][0-9][0-9][0-9])/\3\2\1/' file

If you have ksh93 version h or better you can use the printf %T feature to easily do the date format conversion i.e.

Code:

#!/usr/bin/ksh93

IFS=','
while read v1 v2 v3 v4
do
    printf "%s,%s,%(%Y%m%d)T,%s\n" $v1 $v2 $v3 "$v4"
done < file

I checked the code but it is not working
cat > file6
E106,0,1/9/1993,0,E001,E003,A,45200,3766.667,21.730769
$ cat file6 | sed -e 's/([0-9][0-9])-([[:alpha:]]+)-([0-9]{4})/$3$2$1/'
E106,0,1/9/1993,0,E001,E003,A,45200,3766.667,21.730769


it is giving the same formate.......And i need to validate every line
in a file

yyyymmdd formate.........
E102 0 1/23/1994 0
E104 0 6/4/1994 0
E105 0 7/30/1993 0
E106 0 1/9/1993 0
E108 0 2/3/1995 0
E109 0 2/15/1995 0
E110 0 10/12/1995 0

result
E102 0 19940123 0
E104 0 19940604 0
E105 0 19930730 0
E106 0 19930109 0
E108 0 19950203 0
E109 0 19950215 0
E110 0 19951012 0