On Jul 5, 2006, at 2:58 PM, James E. Harvey wrote:
Basically I'm trying to simply remove everything but legitimate
alphabetic
characters.
Create a string containing the characters you want removed, and use
CHRTRAN(). The code would look like:
SELECT CHRTRAN(dam1, badChars, "")...
One thing to remember with functions is that Fox will set the width
of the fields based on the first record it finds, not the widest
entry. So if your first record was "The Dam", the stripped version
will only have 6 characters, and the Fox will make the column C(6).
If your next entry is "Hoover Dam", only "Hoover" will be in the result.
The solution is to change the function to add a PADR() to make the
column as wide as you need it to be.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
