: Helen Zhung [SMTP:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 7:40 PM
To: Multiple recipients of list ORACLE-L
Subject:SQLLDR - whitespace (tab space) problem
Hello:
I'm new to SQL Loader. Is there a way to code in control file that
can
Great! That works too.
Now I can do it (modify the data) from either Shell script or control file.
Thanks for all the input.
Saj Raza [EMAIL PROTECTED] wrote:
Try something like the lines below, as 9 is the ASCII code for a TAB :load datainfile *INTO TABLE experiment_with_tab_delimiterFIELDS
Hello:
I'm new to SQL Loader. Is there a way to code incontrol filethatcan separate 'a tab' and 'a blank space' ?
I use "FIELDS TERMINATED BY WHITESPACE", but it will TERMINATE a field when there isa space or a tab. However, the data fields were separated only by the "tab", not 'a space'. Is it
Helen,
You can use the optionally parameter to specify multiple enclosed
by/terminated by parameters. NULLIF is also available to assist in
loading blanks.
Regards,
David A. Barbour
Oracle DBA, OCP
Helen Zhung wrote:
Hello:
I'm new to SQL Loader. Is there a way to code in control
You can no doubt do this with Sql*loader.
Personally, I like to clean up the data first instead. I find
it easier to work with that way.
These task are easy on unix, and not too bad on windoze if
you get some decent text tools.
The following line for instance will change all tab characters