Trim everything before the space [message #69599] |
Wed, 06 February 2002 06:04 |
Irina Dumitru
Messages: 7 Registered: February 2002
|
Junior Member |
|
|
Hello everybody,
I have to import data from Access to Oracle. There is a column about the number of hours needed to reach the office. In the Access table it is a date column. The visible values are, say, "1.30". I saved the Access table as a .txt file. The values in the time column appear as "30/12/99 1.30.00". How do I trim the date and the last ".00"? Or is there anything I could write in the control file, so as to load only the "1.30" part?
Thanks a lot,
Iri
|
|
|
|
|