Txt file or CSV file output length

Questions and Answers about DataEase for DOS

Txt file or CSV file output length

Postby NReiff » Sat Jun 21, 2014 12:00 am

I am not sure if this has anything to do with Dataease. It is most likely a DOS (yes, Remember that!).

I have created a data file that is very long. It is fine when viewed on the screen. But when saving as a file output the data has a line break at some point. When opening in Excel, the line break creates a corrupted file in that the line break takes up two rows in an Excel spreadsheet as opposed to longer lines which Excel can handle.

Is this perhaps because of a DOS length limitation?

Any clues on this?

Is there a workaround for this?

As always, my thanks I advance.

Neil
NReiff
 
Posts: 21
Joined: Wed Jun 22, 2011 2:16 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Txt file or CSV file output length

Postby NReiff » Sat Jun 21, 2014 3:38 pm

I am thinking perhaps my problem is due to using a "Custom" format as opposed to a variable length "Export" format. In that the output format is exceptionally long is there perhaps a way of modifying the format without having to "rewrite" the format?

With regard to my former post,this is an example of what I am seeing in my csv file:


AAAAA,BBBBBB,CCCCCC,DDDDDDD,EEEEEEE,FFFFFFF,........PPPPPPPPP,QQQQQ,RRRRR,SSSSS,. . .

When opened in Excel, the line info is on two lines instead of one long line.
NReiff
 
Posts: 21
Joined: Wed Jun 22, 2011 2:16 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Txt file or CSV file output length

Postby Phil Winkler » Sat Jun 21, 2014 7:02 pm

Neil, save the report under another name.

With the new report, modify the format and answer Yes to create a new one.
Select Export, then Mail-Merge then Yes to include field names.
Run it then open the file in Excel and tell me what you get.

It could be something in your data, too. There is no restriction on file length either.
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 890
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Txt file or CSV file output length

Postby NReiff » Mon Jun 23, 2014 8:56 pm

I am an idiot!!
The problem was in the Print Style Specification Page Width setting!!!

Neil
NReiff
 
Posts: 21
Joined: Wed Jun 22, 2011 2:16 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Txt file or CSV file output length

Postby Phil Winkler » Mon Jun 23, 2014 9:09 pm

Hand slapping forehead! :roll: =D>
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 890
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 
 

Return to DataEase for DOS

Who is online

Users browsing this forum: No registered users and 2 guests