RecordIN reference

RecordIN data consists of records with one or more fields. A record can be of fixed or variable length. The fields can be character separated, or located in fixed positions.

Example 3

RecordIN input

INVOICE;1234;JOHN SMITH
ARTICLE;010;Ball;30.00
ARTICLE;020;Rope;125.00
AMOUNT;SEK;155.00

 

Example 4

RecordIN description file

STREAMIN "STR123"
BEGIN
    TYPEPREFIX;
    RECORD "INVOICE" 1 CHRSEP ";"
        MATCH "INVOICE"
        NEWEVENT "Invoice"
        FIELDS
            "Record_id";
            "Invoice_no";
            "Your_ref";
        END
    END
    RECORD "ARTICLE" 1 CHRSEP ";"
        MATCH "ARTICLE"
        INEVENT "Invoice"
        FIELDS
            "Record_id";
            "Pos_no";
            "Item";
            "Price";
        END
    END
    RECORD "AMOUNT" 1 CHRSEP ";"
        MATCH "AMOUNT"
        INEVENT "Invoice"
        FIELDS
            "Record_id";
            "Currency";
            "To_pay";
        END
    END
END

 

RecordIN syntax

STREAMIN <str> BEGIN [TYPEPREFIX;] [RECLEN <num>;] RECORD <str> 1 [[IGNORE;]|[FIXPOS|CHRSEP <str>]] [FIELDQUOTE <str>] [ESCQUOTE <str>] [NEWEVENT <str>;] [INEVENT <str1> <str2> <str3> ... <strN>;] [EVENT <str>;] [JOBBEGIN;] [JOBEND;] [MATCH [<str1> <str2> ... <strN>|EMPTY|SCRIPT <{...}>];] [FIELDS <str1> [<num11> <num12>] [KEEPSP|KEEPLEADINGSP|KEEPTRAILINGSP|SCRIPT <{...}>] [VARNAME <str>]; ... <strN> [<numN1> <numN2>] [KEEPSP|KEEPLEADINGSP|KEEPTRAILINGSP|SCRIPT <{...}>] [VARNAME <str>]; END] END END

•	All keywords and arguments are separated with white spaces (space or tab).

•	Keywords within “[ ]” are optional.

•	Pipe “|” indicates “OR”.

All string and character arguments must be enclosed by quotation marks, for example "String 1" or "A". You can also enter characters as ASCII within angle brackets. For example, enter "<33>" instead of an exclamation mark ("!").