Announcement

Collapse
No announcement yet.

Data compare - column widths

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

  • Data compare - column widths

    Hi,

    I don't know if this is a bug or whether I'm just causing an overload in the application or maybe something else.

    I have a file that I want to compare that has 422 columns. When I enter all the column widths in the File Formats -> Type tab, 422 columns are created (although not all with the widths I specified), but when I delete a column in the same way and reopen and press F5 to be sure, there are still 422 columns. When I create some extra columns and reopen and press F5, there are still 422 columns and the widths are still not compliant with the widths I specified (I checked with column nr 7 which is supposed to have 12 positions, but in fact the column is only 10 positions wide).

    I'm using BC3 build 9222. [edit: I updated to build 9357 and the problem still occurs]

    Is there a max number of columns?

    Unrelated, but while we're at it: is there also a max number of records that BC can process? (just out of curiosity, because our application crashed a couple of times while processing over 1 million records, but we're not sure whether it's our hardware or the software. maybe we'll make a separate thread for this matter when we know more).

    Thanks in advance.
    Kind regards,
    Regressie
    Last edited by Regressie; 06-Nov-2008, 08:32 AM. Reason: Updated to a newer version of BC3

  • #2
    If you need the column widths specification that I entered, I can provide you with that. I didn't post it yet for the overview, because it's such a huge series of numbers.

    Comment


    • #3
      Originally posted by Regressie View Post
      is there also a max number of records that BC can process? (just out of curiosity, because our application crashed a couple of times while processing over 1 million records, but we're not sure whether it's our hardware or the software. maybe we'll make a separate thread for this matter when we know more).
      BC3 is limited by memory. See this post for details...
      BC v4.0.7 build 19761
      ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

      Comment


      • #4
        Hi Regressie,

        I can't reproduce this issue here. Can you email us your settings and small sample files with specific instructions?

        Thanks,
        Erik Scooter Software

        Comment


        • #5
          Hi Regressie,

          Thanks for the files. Actually, everything is behaving as intended. However, here are some things you might find useful:
          • There is an implicit final column that includes all characters remaining on the line. That is why deleting only the last value has no effect.
          • Data is trimmed. You can change this in your Data Format by switching to its "Type" page and unchecking "Trim leading and trailing whitespace".
          • Column type is detected. Columns detected as numeric won't show leading zeros. You can shut off detection for all columns for your Data Session by switching to its "Columns" settings page, clicking "Edit Default..." and switching "Type:" to "Text".
          • The "Columns" settings page currently only allows you to customize the first 99 columns, but we hope to fix that in a future release.
          Erik Scooter Software

          Comment

          Working...
          X