I'm maintaining a PB9 system. A datastore needs to SaveAs Text. However, the resulting text file has spaces between the columns instead of Tabs (CHAR(9)). As a result the file is four times biggger than it need be. The identical code in PB11.5 produces an acceptable file with TABs. Is there something I should or shouldn't be doing to influence the result? The doco says to expect TABs. lds_file.SAVEAS ( 'mytext.txt', Text!, FALSE ) where lds_file is a pfc n_ds datastore created by retrieving 4500 records from an MS_SQL database table. TIA Larry Peters
![]() |
0 |
![]() |
I've never heard of a bug in PB9 where the tab becomes a set of spaces. Sounds to me like you may be missing a trim trailing spaces db parameter (TrimSpaces). -- Terry Dykstra (TeamSybase) http://powerbuilder.codeXchange.sybase.com/ http://casexpress.sybase.com http://my.isug.com/cgi-bin/1/c/submit_enhancement "Larry Peters" wrote in message news:o0e0j6p1h6g521vdkgqplnruc2j7r0fcfe@4ax.com... I'm maintaining a PB9 system. A datastore needs to SaveAs Text. However, the resulting text file has spaces between the columns instead of Tabs (CHAR(9)). As a result the file is four times biggger than it need be. The identical code in PB11.5 produces an acceptable file with TABs. Is there something I should or shouldn't be doing to influence the result? The doco says to expect TABs. lds_file.SAVEAS ( 'mytext.txt', Text!, FALSE ) where lds_file is a pfc n_ds datastore created by retrieving 4500 records from an MS_SQL database table. TIA Larry Peters
![]() |
0 |
![]() |
Hi Larry, Is it possible the text editor your using to view the file is changing the tabs to spaces? I know Textpad has an option to do that so other text editors may as well. Just a thought. hth, Mark On 1/14/2011 6:54 AM, Larry Peters wrote: > I'm maintaining a PB9 system. > > A datastore needs to SaveAs Text. > However, the resulting text file has spaces between the columns > instead of Tabs (CHAR(9)). As a result the file is four times biggger > than it need be. > > The identical code in PB11.5 produces an acceptable file with TABs. > > Is there something I should or shouldn't be doing to influence the > result? The doco says to expect TABs. > > lds_file.SAVEAS ( 'mytext.txt', Text!, FALSE ) > where lds_file is a pfc n_ds datastore created by retrieving 4500 > records from an MS_SQL database table. > > TIA > > Larry Peters
![]() |
0 |
![]() |