Home » RDBMS Server » Server Utilities » Trim everything before the space
Trim everything before the space [message #69599] Wed, 06 February 2002 06:04 Go to next message
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
Re: Trim everything before the space [message #69604 is a reply to message #69599] Wed, 06 February 2002 13:36 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
load data

..

(fld1 "to_char(to_date(:fld1,'mm/dd/yyyy hh:mi'),'hh:mi')")
Re: Trim everything before the space [message #69609 is a reply to message #69604] Wed, 06 February 2002 23:21 Go to previous message
Irina Dumitru
Messages: 7
Registered: February 2002
Junior Member
Thank you very much, it worked!
I have also found very useful info in other answers you gave to other persons.
Thanks a lot again,
Iri
Previous Topic: Facing error during Import (Pls help me out...)
Next Topic: sqlplus
Goto Forum:
  


Current Time: Fri Mar 29 05:44:55 CDT 2024