Import File Size

[Danny Grizzle]

>> On import, ASCII tab-delimited data files are about 20% smaller when
>> saved as a Panorama document.

On 3/2/08 8:52 PM, "Michael" <audax at wideband.net.au> wrote:

> I suppose you checked to make sure you didn't lose 20% of your data?

On 3/3/08 12:05 AM, "James Rea" <jim at provue.com> wrote:

> Is some of the information numbers and/or dates? Panorama would usually
> store these more efficiently than a text file.
> 
> In some cases you could also use Choice fields for great savings, but in
> that case I would think you would know about it.

No data is lost, and no date or choice field types are set.

Comparison is raw ASCII straight into Panorama.

Example: 128.2 MB .csv becomes 94.9 MB Panorama.

I inspected the ASCII in BBEdit, checking record cound with line numbering.

The only thing I see is tons of empty cells with quote wrappers, and commas
to delimit fields. Scanning through the BBEdit doc, this visually appears to
be 20%.

Danny Grizzle