Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Using Save Rows As Text and date formats - Zero is removed

2 posts in DataWindow Last posting was on 2008-07-23 16:52:03.0Z
Steve Posted on 2008-07-08 04:43:53.0Z
Sender: 4b10.4872eda7.1804289383@sybase.com
From: Steve
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Using Save Rows As Text and date formats - Zero is removed
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4872f089.4bbf.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jul 2008 21:43:53 -0700
X-Trace: forums-1-dub 1215492233 10.22.241.41 (7 Jul 2008 21:43:53 -0700)
X-Original-Trace: 7 Jul 2008 21:43:53 -0700, 10.22.241.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87328
Article PK: 416584

Hello There,

I am using a datawindow in the IDE of 11.2 to manipulate
some data that comes to me in a tab separated text file.

I have set up an external datawindow with the correpsonding
column specifications (one being the "Date of Birth")

I can successfully import the data using the "Rows - Import"
but my problems arise when doing a "Save Rows As..." to
another text file.

My date format is "dd/mm/yyyy" but when 05/04/1993 is saved
to the text file the leading zero is removed.

It looks like the "Save As" is using my system date format
which is "d/mm/yyyy" but I can't (and don't want) to change
this to the "dd/mm/yyyy" format.

I have tried using edit masks and format options for the
field but it just seems to get ignored.

Anybody got any hints?

Thanks in advance

- Steve


"John Olson [Team Sybase]" <john.olson Posted on 2008-07-23 16:52:03.0Z
From: "John Olson [Team Sybase]" <john.olson@nospam_teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4872f089.4bbf.1681692777@sybase.com>
Subject: Re: Using Save Rows As Text and date formats - Zero is removed
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <488761b3@forums-1-dub>
Date: 23 Jul 2008 09:52:03 -0700
X-Trace: forums-1-dub 1216831923 10.22.241.152 (23 Jul 2008 09:52:03 -0700)
X-Original-Trace: 23 Jul 2008 09:52:03 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87439
Article PK: 416695

The editmasks and formats are presentation settings and aren't considered
when exporting data. The system formatting is used for exporting. If you
want to use the built-in SaveAs functionality then you're stuck with the
system formatting. Alternatives are to write your own code for the export or
export from PB to Excel and from Excel to a text file.

Regards,
John

<Steve> wrote in message news:4872f089.4bbf.1681692777@sybase.com...
> Hello There,
>
> I am using a datawindow in the IDE of 11.2 to manipulate
> some data that comes to me in a tab separated text file.
>
> I have set up an external datawindow with the correpsonding
> column specifications (one being the "Date of Birth")
>
> I can successfully import the data using the "Rows - Import"
> but my problems arise when doing a "Save Rows As..." to
> another text file.
>
> My date format is "dd/mm/yyyy" but when 05/04/1993 is saved
> to the text file the leading zero is removed.
>
> It looks like the "Save As" is using my system date format
> which is "d/mm/yyyy" but I can't (and don't want) to change
> this to the "dd/mm/yyyy" format.
>
> I have tried using edit masks and format options for the
> field but it just seems to get ignored.
>
> Anybody got any hints?
>
> Thanks in advance
>
> - Steve