Flat File Checker has an inbuild code parsert for VB expressions. To add VB code to the schema inclose it in square brackets, i.e.:
[Format(Now,"dd/MM/yyyy")]
You can use VB formulas almost in any field of Flat File Checker:
- Source file name
- Valid records file path
- Value rule
- Query rule
- Log files
Though most VB functions that can be used in Flat File Checker are global and can be accessed from any place of the schema, some are object specific and cannot be used everywhere.
Here are few examples that show how VB expressions can be used:
|
Examples
| |
|
Expression
|
Sample Result
|
|
[Format(Now, “dd/MM/yyy”)]
|
10/06/2009
|
|
[Format(Now.AddMonths(1), "MM")]
|
07 (if it was June now)
|