Announcement

Collapse
No announcement yet.

Whish List: File Formats Characters per line limit

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Aaron
    replied
    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.

    Leave a comment:


  • mewsance
    replied
    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.

    Leave a comment:


  • Aaron
    replied
    Thanks, Michael.

    Our current upwards limit is: 65536.

    Leave a comment:


  • Michael Bulgrien
    replied
    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

    Leave a comment:


  • agaida
    started a topic Whish List: File Formats Characters per line limit

    Whish List: File Formats Characters per line limit

    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)
Working...
X