I like to use a .col file from an import. Anyone has a sample copy?
Subject: How do I create a .COL?
There are a few examples in the designer help, try searching for “col file”.
If you are struggling after looking at the examples in the help, then post an example of the data, and what you are struggling with specifically.
HTH - Rufus.
Subject: How do I create a .COL?
Sample COL file is listed below to read from a 123 worksheet.
FIELD_A:WKSCOL A;
FIELD_B: WKSCOL B;
FORMULASTART
FIELD FIELD_A := @trim(@lowercase(FIELD_A));
FORMULAEND
Yet another sample (for text files)
FIELD_A: Type Text Until “|”;
FIELD_B: Type Text Until “|”;
FIELD_C: Type Text until “|”;
FIELD_D: Type Text until “”;
All this is illustrated in the Designer Help files.