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 Samson Sent: Thursday, November 01, 2007 8:55 AM To: arslist@ARSLIST.ORG Subject: 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 -0400 From: [EMAIL PROTECTED] Subject: Re: Replace function on a special character To: arslist@ARSLIST.ORG ** 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 Samson Sent: Wednesday, October 31, 2007 4:19 PM To: arslist@ARSLIST.ORG Subject: 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! <http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hot mailnews> __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=CL100 626971033> __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
