Re: problems with import from *.txt file
Hi Bartek,
Why not import the .txt file into Excel, add columns before and after the text columns with no apostrophes ("'"), fill these new columns with apostrophes , and then use "concatenate" to make a fourth column which has the right format, copy the new (fourth) column onto itself using only values (so it doesn´t just contain a formula), delete all the old columns, and save as .txt? That way your .txt file will be in the proper format.
Hope that helps,
Regards,
Tristram
Subject
Views
Written By
Posted
4802
November 02, 2009 06:26PM
Re: problems with import from *.txt file
2885
November 10, 2009 07:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.