i am be importing the data file from Web site . which are in a single column.



To make clear



2009,2,13,1,1,72.32

1) I need to place the data's in different column



2) here ......

First - year

Second - month

Third - date

Fourth - first hour of the day

Fifth - first five mins of the hour

Sixth - an integer value



3) Change the fifth column into actual mins



4) Fourth and Fifth column should look like....01:05 in a single column..



5) And every time the data refreshes ...it would come in the above format with the No:3 and No:4 condition.



example



2009,2,13,1,1,72.32

2009,2,13,1,2,75.45

would look like



2009| 2| 13| 1:05| 72.32|

2009| 2| 13| 1:10| 75.45|





Thanks ..



krofox