Concatenation:

You can combine ('concatenate') two, three or four pre-existing variables to create a new variable. Type (in the left column if the IDB screen) the new variable beneath the existing variables. (It does not have to be immediately beneath an existing variable. It can also be on a different page.) In the right column, type the two to four existing variables that you want to combine. You must include the '=' sign to indicate a 'calculation event' and the formula, and an ampersand ('&') to indicate the concatenation.

So, if you have the variables [First Name] and [Last Name] in your Instant Database mask, but wish to use the variable [FullName] in the document, you do not need to type the First and Last Name values again. Just provide in the Instant Database mask the target variable '[FullName]' at the left and the equivalency formula at the right.

                                             

Variable

 

Value

[First Name]

 

John

[Last Name]

 

Doe

[FullName]

n

=[First Name]& [Last Name]

A red square appears in the 'middle' column when the '=' is present.
Click the red square between the two columns and the equivalency is 'calculated'.
(The  space between the & and [Last Name] is needed to assure the proper formation of the new variable.)

 

Variable

 

Value

[First Name]

 

John

[Last Name]

 

Doe

[FullName]

n

John Doe

Click it again and the formula is restored for editing, if necessary.

In-line concatenation:

   The above can be also accomplished 'in-line' (i.e., within the document body. (This avoids the need for a mask.)

   Pathagoras will see the in line formula as a complete variable. It will automatically create the equivalency formula at the right with no action on your part. Click the red button that will appear between the two columns to toggle between the formula and the calculated value.

   Let's assume that [First Name] and [Last Name] (the 'precedent' variables) reside in the 'upper part' document. You now want to reference the concatenated value of those two variables somewhere below the first appearance of the precedent variables. Here is the formula that would reside in the actual document.

[#Concat#Full Name=[First Name]& [Last Name]]

 

   When the document is scanned, the precedent variables are (presumably) found first and inserted into the IDB screen. When the #Concat# instruction is encountered, entire block is place into the variables list (left side) the variable. The formula is then automatically parsed from the #Concat# block and placed in the 'values' column of the IDB screen

Variable

 

Value

[First Name]

 


[Last Name]

 


[#Concat#FullName

n

=[First Name]& [Last Name]

(Note: just like in the IDB screen, the example doesn't show the entire very long variable in the left column.
If you hover your mouse over the variable, it will display in its entirety.)

  A red square appears in the 'middle' column when the '=' is present.

Variable

 

Value

[First Name]

 

Eleanor

[Last Name]

 

Roosevelt

[#Concat#FullName

n

=[First Name]& [Last Name]

Click the red square between the two columns and the equivalency is 'calculated'.

Variable

 

Value

[First Name]

 

Eleanor

[Last Name]

 

Roosevelt

[#Concat#FullName

n

Eleanor Roosevelt

Click it again and the formula is restored for editing, if necessary.

Created with Help & Manual 7 and styled with Premium Pack Version 2.70 © by EC Software