Have you tried it directly using SQL??
_____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Barbour, Brandi D Sent: Tuesday, January 08, 2013 12:36 PM To: [email protected] Subject: Replace function in VARChar Max fields RKM All, We have some RKM records that have the wrong server name in the Unlimited field. For example: in Reference form in the Reference field we need to substitute everywhere there is "servername" with " servername.domain.com and where there is javascript:parent.DView.SendSignalToParent replace it with javascript:DView.SendSignalToParent. I have tried exporting as a csv file however it will do a find but will not replace due to the size of the field. I then exported them out as an arx file and modified the entries in word pad. Saved it and tried to import using data Import tool. However if you do more than one then I get plug in errors. Tue Jan 08 10:52:59 2013 390620 : Error in plugin : RMDY.ITSM.RKM.UPDATEKAMMAPPINGS (ARERR 8753) Tue Jan 08 10:52:59 2013 390620 : An application command failed. (ARERR 4554) Tue Jan 08 10:52:59 2013 Application-Delete-Entry "RKM:KAMAsynchronousUpdate" 000000000042412 I also have engaged our DBA's however since this is a VARCHAR MAX field they say this is either not possible or very cumbersome to do. Has anyone done this before and any ideas on how to proceed? We are using ITSM 7.6.4 sp 2 ARS 7.6.4 sp 3 Windows SQL Thanks, Brandi _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
