Common use of Format Guidelines Clause in Contracts

Format Guidelines. All files submitted to the HCCD will be formatted as standard text files. Text files must comply with the following standards: 5.1.1 One line item per row. No single line item of data may contain carriage return or line feed characters. 5.1.2 All rows delimited by the carriage return + line feed character combination. 5.1.3 All fields are variable field length, delimited using the pipe character (ASCII=124). It is imperative that no pipes (‘|’) appear in the data itself. If your data contains pipes, either remove them or discuss using an alternate delimiter character. 5.1.4 Text fields are never demarcated or enclosed in single or double quotes. Any quotes detected are regarded as a part of the actual data. 5.1.5 The first row always contains the names of data columns. 5.1.6 Unless otherwise stipulated, numbers (e.g. ID numbers, account numbers, etc.) do not contain spaces, hyphens or other punctuation marks. 5.1.7 Text fields are never padded with leading or trailing spaces or tabs. 5.1.8 Numeric fields are never padded with leading or trailing zeroes. 5.1.9 If a field is not available, or is not applicable, leave it blank. ‘Blank’ means do not supply any value at all between pipes (including quotes or other characters).