[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] REMOVE NON CHARACTERS
- Subject: RE: [sqr-users] REMOVE NON CHARACTERS
- From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
- Date: Mon, 15 Nov 2004 13:52:43 -0800
- Delivery-date: Tue, 16 Nov 2004 09:05:31 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Translate should work if you give it a string of punctuation characters and
tell it to translate them all to null. What is the exact statement you've
tried?
-----Original Message-----
From: Jaques, Dona [mailto:djaques@acs.utah.edu]
Sent: Monday, November 15, 2004 8:56 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] REMOVE NON CHARACTERS
Can anyone tell me how to remove all non-characters using sqr? I have
tried the translate and replace function with no success.
Thanks for any input!
Dona
For example
Before Value
AL-Sadar's
After Value
ALSadars
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users