The options CONTINUEIF and CONCATENATE can be used to combine several lines of a file to form one logical input line. The options run:
and
CONCATENATE <number> always combines the predefined number of lines, while for CONTINUEIF, the concatenation depends on whether a certain character is located on a certain position of the line just read. The position can be fixed (number) or variable (LAST). Equal (=) and not equal (<>) are allowed as comparison operators. The character must be enclosed in single quotation marks. 'x' precedes a hexadecimal constant. If the CONTINUEIF condition is met because the continuation character was found, this character will not be inserted into the logical input line.
Example:
DATALOAD TABLE time_entry
day 1
from 2
to 3
break 4
INFILE *
COMPRESS SEPARATOR ','
CONTINUEIF LAST = '&'
01.04.97,08:05,17:00&
,0.5
02.04.97,07:55,16:00,0.5
...