About the Variable-Length-Delimited Data Format

The variable-length-delimited data format enables you to map delimited files, such as comma-separated variable (CSV) files. Variable-length-delimited files must follow these guidelines:

• Records are contained on one line of data, terminated by a carriage return and a line feed, or just by a line feed.
• Fields must be delimited, even if some do not have any data in them.
• If a field in the variable-length-delimited file contains a delimiter, you must use quotation marks around the field.
• When processing Variable Delimited data, the number of fields received in the data file must be the exact number fields defined for the record in the map.

You can create variable-length-delimited layouts with the assistance of a wizard. By selecting Customize, you instruct the Sterling B2B Integrator Map Editor to use the file you are mapping to create the basic structure of your layout for you.