| Loader loading some garbage characters at the end of the data field [message #501096] |
Fri, 25 March 2011 15:10  |
rappaj
Messages: 147
Registered: June 2010
Location: NYC
|
Senior Member |
|
|
Hi,
After exporting some data to excel, I noticed that on one row all the columns shifted over some. So I queried this record in the database and noticed that the ADDRESS field has some unknown characters at the end of it. They are little squares. I think they are TABS.
2630 LINDEN BLVD, APT. #8G(2 squares are in here)
ADDRESS_1 "TRIM(:ADDRESS_1)",
Besides trimming the data, is there some other function I can use to clean up the address further?
Thanks,
Joe
|
|
|
|
|
|
|
|
|
|
| Re: Loader loading some garbage characters at the end of the data field [message #502628 is a reply to message #501102] |
Thu, 07 April 2011 11:20  |
rappaj
Messages: 147
Registered: June 2010
Location: NYC
|
Senior Member |
|
|
Hi all,
Just letting you know that the garbage character that was in the input file that I loaded were 2 TABS.
So right from the initial load in the ctl file, I used the replace function. I know that it would only work for TABS, but that seems to be the only type of garbage that I've been getting....hopefully
ADDRESS_1 "trim(replace (:address_1, chr(9),' '))",
Thanks,
Joe
|
|
|
|
|
|
| Re: Loader loading some garbage characters at the end of the data field [message #502633 is a reply to message #502632] |
Thu, 07 April 2011 13:06 |
rappaj
Messages: 147
Registered: June 2010
Location: NYC
|
Senior Member |
|
|
Hi Michel,
I wanted to try your version too, so I reloaded the data with the garbage tabs, but the rtrim(:address1, chr(9)) did not work. The data loaded with the garbage. Even when I used it in SQL, the data still returns garbage.
No need to go crazy with this if you don't want to........the REPLACE works.
The attached snapshot shows this version used...
Thank you
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
