Skip to main content

Comp Calc/Cost Estimate Flexible CSV Import Technical Details - File Format

The input data file should be a CSV-formatted text file.  A comma (“,”) must be used to separate each column.  A carriage-return+line-feed character combination must be used to terminate each row.  If

Updated over 2 weeks ago

The input data file should be a CSV-formatted text file. A comma (“,”) must be used to separate each column. A carriage-return+line-feed character combination must be used to terminate each row. If a column’s content already contains a carriage-return+line-feed character combination, then the column’s data should be enclosed in double-quotes. The same is true if a comma must be included as part of the data of a column. If a double-quote character must be included as part of the data of a column, then it should be “escaped” by being immediately proceeded by another double-quote character. (e.g. "Hello world" would be encoded as ""Hello World"".)

Did this answer your question?