Whish List: File Formats Characters per line limit

[Aaron]

Unfortunately, the current limit is set to the upper bounds of our support. Would it be possible to get a pair of sample files we could use to review and test with?

Sample files can be emailed to [email protected] along with a link back to this forum thread for our reference.

[mewsance]

Is there a way to adjust the Characters per line limit for Table Comparisons?

A particular workflow involves extracting to CSV all the sheets of a Excel workbook and then diffing those CSVs. We embed database queries in the sheets that are sometimes in excess of 65536 chars per cell. These queries can be ignored as we are only interested in the resultant data.

When we diff the CSVs, we get the Characters per line limit error. BC quits on that file after that and won't compare the rest of the file contents. Manually removing the query line gets BC past this and we get a beautiful diff of the tables. Is there a way to avoid this manual cleanup to allow BC to diff the remainder of the file?

The placement of the query is not always deterministic (user error) so scripting something to prune those lines isn't trivial.

[Aaron]

Thanks, Michael.

Our current upwards limit is: 65536.

[Michael Bulgrien]

Click Tools --> File Formats...
Select the format that you want to change
On the Conversion tab, set your Characters per line limit then click Save

[agaida]

Is it possible to set the characters per line limit in File Formats to a higher value then 4k. IMHO 16k is great.

Or throw a warnig if the line limit is to small.

Reason: Comparing packed text files, 8 to 16k per line. (mostly java, html or php)