Lotus Domino Designer 8.5 Help - Writing formulas for COL files

APPLICATION DESIGN

Writing formulas for COL files
All formulas in a COL file must appear after all the column definition statements. A COL file can have only one FORMULASTART and FORMULAEND sequence. FORMULASTART must appear alone on a line before the first formula. FORMULAEND must appear alone on a line after the last formula. Each line of formulas between these keywords must end with a semicolon.

Example

The following COL file is used to import a 1-2-3 .WK3 file that records a checkbook balance.

;COL file for checkbook worksheet ;Discovers checkbook errors Define five columns of input date: WKSCOL A chknum: WKSCOL B amount: WKSCOL C deposits: WKSCOL F withdrawals: WKSCOL G balance: WKSCOL K ;Define one column to mark bounced checks FORMULASTART FIELD bounced:=@IF(balance<0,"Yes"; "No"); FORMULAEND

In this example, columns D, E, H, I, and J in the worksheet are not imported into the view.

See Also

Creating a column descriptor (COL) file

Writing a COL file for a tabular text file

Writing a COL file for a worksheet

Using a column descriptor file (COL ) to map a source file to a Notes view

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary