At 03:09 PM 6/14/2013, Steve Hartmann wrote:
Does anyone have a command file that will analyze variable and automatically replace unprintable characters with spaces. Much of our data is imported from client sources and now we have to export it and the receiver of the data objects to these characters. I know I have written one before myself. For now we can use such a function in the programs that create the exports, but ideally I would like to put it at the source. Unfortunately that means a lot of programs to change. I have not worked with R:Base triggers very much, just Oracle. Would it be possible to add a function to "clean" the data of unprintable characters as part of and ON UPDATE OR ON INSERT trigger.
You didn't mention the version of R:BASE you are using. However, IF you are using the current version and updates of R:BASE, you can take advantage of enhanced String Manipulation Functions, such as SRPL, SLOC, and SLOCP. SRPL: Enables searching for and replacing text within a specified string of text. SLOC: Locates string in text, returning the position if the string is found, 0 if it is not found. SLOCP: Locates the exact position of a given string and occurrence in a TEXT, NOTE or VARCHAR value, returning the position if the string is found, 0 if it is not found. Using -1 as the third parameter will return the LAST occurrence. For complete details, syntax, and examples ... HELP SRPL HELP SLOC HELP SLOCP Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
