Hope this issue somebody encountered.
When I generating the datafile with ORABULK stage , the traling spaces in the input string will be taken off. May I have any explanation on this ?
eg:
Input File Data
-------------------
sno, name
1,"Pennsylvania "
2,"New Jersey "
Output File Data ( datafile generated from ORABULK)
sno, name
1,"Pennsylvania"
2,"New Jersey"
Trimming issue with ORABULK
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Hi,
What is your input file format? I can see it is a comma delimited-file. Does it have any quote character??
How are you reading this file? What transformations are you putting it through?
Input Data given by you:
Is it exactly like the above or is it like:
That would help us better understand the problem.
Thanks,
Naveen.
What is your input file format? I can see it is a comma delimited-file. Does it have any quote character??
How are you reading this file? What transformations are you putting it through?
Input Data given by you:
Code: Select all
eg:
Input File Data
-------------------
sno, name
1,"Pennsylvania "
2,"New Jersey "
Code: Select all
Input File Data
-------------------
sno, name
"1","Pennsylvania "
"2","New Jersey "
Thanks,
Naveen.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
It's not available in Server. We've had to script changes into the .ctl file 'on the fly' before the actual load using 'sed' to handle things like that.
Or let it generate a .ctl file and then use your own (static) pre-edited one during the load.
Or let it generate a .ctl file and then use your own (static) pre-edited one during the load.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers