Changing all date fields from mm/dd/yy to dd/mm/yy

Please, I'm looking for a way to change all date fields in a specified
file, like this:

solaris> cat file

05/23/06 03/12/06

07/10/06 11/12/06 09/20/06

03/11/06

I need change all date field from mm/dd/yy to dd/mm/yy, like this:

solaris> ./script < cat file


23/05/06 12/03/06

10/07/06 12/11/06 20/09/06

11/03/06


Thanks !

Re: Changing all date fields from mm/dd/yy to dd/mm/yy

contracer11@gmail.com wrote:
> Please, I'm looking for a way to change all date fields in a specified
> file, like this:
>
> solaris> cat file
>
> 05/23/06 03/12/06
>
> 07/10/06 11/12/06 09/20/06
>
> 03/11/06
>
> I need change all date field from mm/dd/yy to dd/mm/yy, like this:
>

perl -i -pe 's{(\d\d)/(\d\d)/(\d\d)}{\2/\1/\3}g' file

Xicheng

> solaris> ./script < cat file
>
>
> 23/05/06 12/03/06
>
> 10/07/06 12/11/06 20/09/06
>
> 11/03/06
>
>
> Thanks !

Re: Changing all date fields from mm/dd/yy to dd/mm/yy

contracer11@gmail.com wrote:
> Please, I'm looking for a way to change all date fields in a specified
> file, like this:
>
> solaris> cat file
>
> 05/23/06 03/12/06
>
> 07/10/06 11/12/06 09/20/06
>
> 03/11/06
>
> I need change all date field from mm/dd/yy to dd/mm/yy, like this:
>
> solaris> ./script < cat file
>
>
> 23/05/06 12/03/06
>
> 10/07/06 12/11/06 20/09/06
>
> 11/03/06
>
>
> Thanks !

ruby -i -pe'gsub( %r!(\d\d)/(\d\d)/(\d\d)! )
{ $~.captures.values_at(1,0,2).join "/" }' myfile

Re: Changing all date fields from mm/dd/yy to dd/mm/yy

contracer11@gmail.com wrote:

> Please, I'm looking for a way to change all date fields in a specified
> file, like this:
>
> solaris> cat file
>
> 05/23/06 03/12/06
>
> 07/10/06 11/12/06 09/20/06
>
> 03/11/06
>
> I need change all date field from mm/dd/yy to dd/mm/yy, like this:
>
> solaris> ./script < cat file
>
>
> 23/05/06 12/03/06
>
> 10/07/06 12/11/06 20/09/06
>
> 11/03/06
>
>
> Thanks !

sed 's:\(../\)\(../\)\(..\):\2\1\3:' file

Regards,

Ed.

Re: Changing all date fields from mm/dd/yy to dd/mm/yy

wrote in message news:1138889407.015457.162760@f14g2000cwb.googlegroups.com.. .
: Please, I'm looking for a way to change all date fields in a specified
: file, like this:
:
: solaris> cat file
:
: 05/23/06 03/12/06
:
: 07/10/06 11/12/06 09/20/06
:
: 03/11/06
:
: I need change all date field from mm/dd/yy to dd/mm/yy, like this:
:
: solaris> ./script < cat file

perl -pe 's:(\d{2})/(\d{2})/(\d{2}):$2/$1/$3:g' infile >outfile

Dan Mercer

:
:
: 23/05/06 12/03/06
:
: 10/07/06 12/11/06 20/09/06
:
: 11/03/06
:
:
: Thanks !
:

Re: Changing all date fields from mm/dd/yy to dd/mm/yy

On 2006-02-02, contracer11@gmail.com wrote:
> Please, I'm looking for a way to change all date fields in a specified
> file, like this:



> I need change all date field from mm/dd/yy to dd/mm/yy, like this:
>


Sed will do that easily:

sed 's/\([0-9][0-9]\)\/\([0-9][0-9]\)\/\([0-9][0-9]\)/\2\/\1\/\3 /g'

--
for((P=10**8,Q=P/100,X=320*Q/(`tput cols`-1),Y=210*Q/`tput lines`,y=-105*Q,v=-2\
20*Q,x=v;y<105*Q;x=v,y+=Y));do for((;x P*P&&i++<99;a=((c=a)*a-b*b)/P+x,b=2*c*b/P+y));do :;done;(((j=(i<99?i%16:0)+30)>\
37?k=1,j-=8:0));echo -ne "\E[$k;$j"mE;done;echo -e \\E[0m;done # Charles Cooke