Clean Up Your Digits!

[MCWebsite.Staff]

** This thread discusses the article: Clean Up Your Digits! **
** This thread discusses the Content article: Clean Up Your Digits! **
0

[bibarnes@yahoo.com]

** This thread discusses the article: Clean Up Your Digits! **
What happens with negative numbers? If a number is embedded with either a minus sign (-) or brackets will it get converted to a negative or positive number?

[R.Cozzi]

** This thread discusses the article: Clean Up Your Digits! **
If you use %DEC or NumToChar() then negative numbers are converted properly. That is, assuming the minus sign is used as the negative sign. If the number contains "CR" or is enclosed in brackets, it will not be converted to negative.

[gingerlyell@aol.com]

** This thread discusses the article: Clean Up Your Digits! **
Any suggestions to use XLATE to convert an apostrophe (') to a blank?

[Guest.Visitor]

** This thread discusses the article: Clean Up Your Digits! **
myField = %XLate('''':' ':myField); All string literals are enclosed in single quotes and a single quote inside a literal string requires 2 single quotes (double it up). 'Bob''s Book' Chris

[gingerlyell@aol.com]

** This thread discusses the article: Clean Up Your Digits! **
Thanks. I had remembered to double, but had forgotten the "double" was to double the single apostrophe, not the surrounding delimiters.