Difference between revisions of "SET TEXTMERGE"

From Recital Documentation Wiki
Jump to: navigation, search
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET TEXTMERGE=
 
 
 
==Class==
 
Input/Output
 
 
 
 
==Purpose==
 
==Purpose==
 
Specify delimiting characters
 
Specify delimiting characters
Line 20: Line 13:
  
 
==See Also==
 
==See Also==
[[\]], [[\\]], [[TEXT]]
+
[[Single Textmerge|\]], [[Double Textmerge|\\]], [[TEXT]]
  
  
Line 32: Line 25:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
use test
+
open database southwind
 +
use example
 
set textmerge to balance.txt
 
set textmerge to balance.txt
et textmerge to delimiters to "{{","}}"
+
set textmerge delimiters to "{{","}}"
 
set textmerge on
 
set textmerge on
 
go top
 
go top
 
do while balance > 0
 
do while balance > 0
Date: {{date()}}
+
    text
Name: {{last_name}}  {{first_name}}
+
    Date: {{date()}}
 
+
    Name: {{last_name}}  {{first_name}}
Account Number  :  {{account_no}}
+
Current Balance  :  {{balance}}
+
Credit Limit:        :  {{limit}}
+
 
+
  
 +
    Account Number  :  {{account_no}}
 +
    Current Balance  :  {{balance}}
 +
    Credit Limit:        :  {{limit}}
 +
    endtext
 +
    skip
 
enddo
 
enddo
 
set textmerge off
 
set textmerge off
set textmerge to</pre>
+
set textmerge to
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|TEXTMERGE]]
 
[[Category:Set_Commands|TEXTMERGE]]
 +
[[Category:Input Output]]
 +
[[Category:Input Output Set Commands]]

Latest revision as of 11:27, 27 November 2012

Purpose

Specify delimiting characters


Syntax

SET TEXTMERGE ON | OFF | (<expL>)

SET TEXTMERGE TO [<filename>] [ADDITIVE]

SET TEXTMERGE DELIMITERS TO [<expC1>] [,<expC2>]


See Also

\, \\, TEXT


Description

The SET TEXTMERGE ON | OFF command determines whether expressions that have been enclosed by the text merge delimiters will be evaluated, or output literally. When SET TEXTMERGE is ON, delimited expressions are evaluated and then output to the screen or to a file. If SET TEXTMERGE is OFF, delimited expressions are output literally. Delimited expressions may include table field names, memory variables, and functions. The default text delimiters are << and >>. To use a different set of characters to delimit text, use the SET TEXTMERGE DELIMETERS command. Delimited text is output when it is placed after the and commands, or when it is between the TEXT...ENDTEXT commands. When SET TEXTMERGE is ON, expressions placed within the TEXT...ENDTEXT commands are evaluated and merged with text.

The SET TEXTMERGE TO command directs delimited text to an output file. If the name of the text file, as specified by <filename>, already exits, the file will be overwritten unless the ADDITIVE keyword is used. If the text file does not exist and the ADDITIVE qualifier is used, the file will be created. If the file does exist, then the text will be appended to the end of the text file. If the command SET TEXTMERGE TO is issued without a <filename>, all output will be directed to the current output device, such as the screen or a window.

The SET TEXTMERGE DELIMITERS TO command is used to specify the delimiting characters. The first character expression, <expC1>, is used to specify the beginning text delimiter. If only one character expression is specified, the same character is used to delimit the beginning and ending of text. The second character expression, <expC2>, is used to specify the ending text delimiter. If no character expressions are specified, the SET TEXTMERGE DELIMITER TO command restores the delimiting characters to << and >>.


Example

open database southwind
use example
set textmerge to balance.txt
set textmerge delimiters to "{{","}}"
set textmerge on
go top
do while balance > 0
    text
    Date: {{date()}}
    Name: {{last_name}}  {{first_name}}
 
    Account Number  :  {{account_no}}
    Current Balance  :   {{balance}}
    Credit Limit:        :   {{limit}}
    endtext
    skip
enddo
set textmerge off
set textmerge to


Products

Recital Server, Recital