Thanks for the REPLACE explanation Stephen. I also now see the hex editor does give me the CHAR decimal now. I also did a search on google Carey and was not 100% clear, hence the question. ;)
Date: Thu, 1 Nov 2007 09:18:41 -0400From: [EMAIL PROTECTED]: Re: Replace function on a special characterTo: [EMAIL PROTECTED] Jackson, The line feed character is decimal 10 (carriage return is decimal 13). To replace the line feed character in a character field with something else. Set Fields SQL $zTmpField1$ = SELECT CHAR(10) Set Fields $CharField$ = REPLACE($CharField$, $zTmpField1$, “x”) If you only want to remove the line field change “x” to “”. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jack SamsonSent: Thursday, November 01, 2007 8:55 AMTo: [EMAIL PROTECTED]: Re: Replace function on a special character Stephen, Thank you for the information. Is their a chart that gives a conversion for each character? I looked at the ASCII table and was not sure how to convert it from this to a CHAR(9). I have a line feed or a hex of 0A. What would give me the equivalent in the SELECT CHAR(<What would this be for 0A>). Once I know the value I then want to remove this character from the string. Regards, Jackson Date: Wed, 31 Oct 2007 16:22:56 -0400From: [EMAIL PROTECTED]: Re: Replace function on a special characterTo: [EMAIL PROTECTED] Jackson, You can use your RDBMS to return special characters. You just need to find out the numeric value of them. For example, to get the Tab character, Set Fields SQL: SELECT CHAR(9) Once you have the value in a character field you can use that for your replacing. HTH Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jack SamsonSent: Wednesday, October 31, 2007 4:19 PMTo: [EMAIL PROTECTED]: Re: Replace function on a special character Hi All, I am using ARS version 6.3 and am trying to perform a REPLACE() function using a filter. I have a few special characters that I can see using a hex editor and the editor gives me the hex equivalent. My question is how do I perform a replace on a special character? Thanks, Jackson Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! Try now! __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ Windows Live Hotmail and Microsoft Office Outlook – together at last. Get it now!__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _________________________________________________________________ Windows Live Hotmail and Microsoft Office Outlook – together at last. Get it now. http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=CL100626971033 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
