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
|