Mark, I don't believe Word will count characters correctly as it will try to fix up things like carriage returns and such.
If I remember correctly you are using Oracle. To get a correct count in SQL do a SELECT LENGTH(Cxxxxx) from T120 WHERE .... Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Friday, August 24, 2012 1:48 PM To: [email protected] Subject: Export though Golden Gate - exceeds field length ** Hi All, I have an situation where we are trying to export data from the Remedy tables (e.g. T120) though Golden Gate and some records are being rejected because the incoming data exceeds the expected field/colmn size. If I take the character data from field and do a count in MS Word I get 992. During the import/export Golden Gate is detecting 1001 characters which exceeds to the 1000 character limit set for this field. I am being told the issue is hidden characters. Has anyone seen this sort of thing with Golden Gate or other tools? Is there a way to filter out special characters in a field. ALNUM and ALPHA patterns are not an option. Any ideas would be greatly appreciated. Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company [email protected] Office: 315-453-2912 x5335 Mobile: 315-882.5360 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
