Re: Importing TAB-delimited data

In article <3857c338.76058942_at_news.earthlink.net>,   andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
> Any advice on how I can import TAB delimited file into Oracle?
> I cannot use DELIMITED BY WHITESPACE b/c
>
> If TERMINATED BY WHITESPACE is specified, data is read until the first
> occurrence of a whitespace character (space, tab, newline). Then the
> current position is advanced until no more adjacent whitespace
> characters are found. This allows field values to be delimited by
> varying amounts of whitespace
>
> but my street column will surely have whitespaces
>
> I tried doing this thru Access (it has the Tab-delimited feature), but
> got ODBC call failed (maybe b/c it's too large or something, its like
> 200K records)

You could try a generic parser/converter like ParseRat (http://www.guysoftware.com/parserat.htm) which can convert tab delimited to fixed format or some other delimiter (including comma delimited with quoted strings) or dBase. It handles name and address data particularly well - even parses out the components if you want.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 22:42:16 CST