• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • dw.saveAsFormattedText delivers additional empty rightmost column

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved dw.saveAsFormattedText delivers additional empty rightmost column

  1. Issue
0
Votes
Undo
  1. Peter Klopfer
    Peter Klopfer
  2. PowerBuilder
  3. Monday, 20 July 2020 13:20 PM UTC

Hi,

we are saving the contents of a multi-column grid datawindow using saveAsFormattedText:

dw.saveAsFormattedText (

   ls_file

   , EncodingANSI!

   , "~t" /*sep*/

   , ''" /*quote*/

   , "~r~n" /*lineending*/

   , false /*retainnewlinechar*/

)

There will always be an additional empty column, i.e. each line will end by "~t~r~n".

This is no big issue with text files or export to excel, but with some more specific applications such as R.

Besides, this problem has been bothering us for many years and several different PB versions.

Any hints?

 

Regards,

Peter

 

 

PowerBuilder and JAWS Screen Reader
Problem with right mouse button drag and drop
Responses (2)
Peter Klopfer
Peter Klopfer Accepted Answer Pending Moderation
  1. Monday, 20 July 2020 20:17 PM UTC
  2. PowerBuilder
  3. # 1

Hi Chris,
thank you for your answer.

As a workaround, something like a FileReadEx(), then a ReplaceAll ( "~t~r~n", "~r~n" ) , followed by a FileWriteEx() should fix that.

This is exactly what we did, but with datawindows of considerable size it will cost too much time. Some of our clients generate datasets of several million rows.

So we will follow your advice and open a support ticket.

Regards, Peter

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 20 July 2020 16:23 PM UTC
  2. PowerBuilder
  3. # 2

Hi Peter;

  This sounds like a legacy bug. Please open a Support Ticket for this issue.

   As a workaround, something like a FileReadEx(), then a ReplaceAll ( "~t~r~n", "~r~n" ) , followed by a FileWriteEx() should fix that.

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.