Microsoft KB Archive/101000: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - "<" to "<") |
||
(One intermediate revision by the same user not shown) | |||
Line 19: | Line 19: | ||
SCAN | SCAN | ||
TEXT | TEXT | ||
<<TRANSFORM(<fieldname>,'9,999.99')>> | |||
*After the transform the number 1234 would look like 1,234.00 | *After the transform the number 1234 would look like 1,234.00 | ||
ENDTEXT | ENDTEXT |
Latest revision as of 10:17, 20 July 2020
How to Format a Numeric Field in a Text MergeID: Q101000 The information in this article applies to:
Using a text merge, you can format a numeric field differently than it appears in the database--for example, including commas, dollar signs, decimal points, and so on when the field is viewed in output. The following sample code shows how to format a numeric field in a text merge: SET TEXTMERGE ON SET TEXTMERGE DELIMITERS TO USE dbf_file SCAN TEXT <<TRANSFORM(<fieldname>,'9,999.99')>> *After the transform the number 1234 would look like 1,234.00 ENDTEXT ENDSCAN Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a textmerge number currency KBCategory: kbprg KBSubcategory: FxprgGeneral |
Last Reviewed: June 27, 1995 |