Formating number without leading zeros

Hello everyone.
I am using PB 9.0.1 Build 7275.
I have problems with formatting number-columns in a datawindow.
I want to display the value 12.3456 as an area using the format "#,##0.00
m�". I expect it to be "12,35 m�".
But it is displaid as "0.012,35 m�". That is, with leading zeros.
Replacing "m�" by any other string always displays the number with leading
zeros.
Except for the euro (?) or dollar ($). Using these signs with the same
format ("#,##0.00 ?") displays the number as "12,35 ?" (which I would
prefer).

Why is this so? How can I get rid of the leading zeros?

Thanks.


-- 

Rolf Knaden
conject GmbH, c/o Business-Contor Philosophenweg 31-33, 47051 Duisburg

Fon:    +49 (0203) 9414.138
Fax:    +49 (0203) 9414.555
Rolf.Knaden@conject.com

www.conject.com

konsequent conject.


0
Rolf
3/3/2005 12:47:07 PM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

4 Replies
527 Views

Similar Articles

[PageSpeed] 28

Rolf;

    Are you applying this to a DW column of type Long or decimal?

Chris

"Rolf Knaden" <rolf.knaden@conject.com> wrote in message
news:4227074b@forums-1-dub...
> Hello everyone.
> I am using PB 9.0.1 Build 7275.
> I have problems with formatting number-columns in a datawindow.
> I want to display the value 12.3456 as an area using the format "#,##0.00
> m�". I expect it to be "12,35 m�".
> But it is displaid as "0.012,35 m�". That is, with leading zeros.
> Replacing "m�" by any other string always displays the number with leading
> zeros.
> Except for the euro (?) or dollar ($). Using these signs with the same
> format ("#,##0.00 ?") displays the number as "12,35 ?" (which I would
> prefer).
>
> Why is this so? How can I get rid of the leading zeros?
>
> Thanks.
>
>
> -- 
>
> Rolf Knaden
> conject GmbH, c/o Business-Contor Philosophenweg 31-33, 47051 Duisburg
>
> Fon:    +49 (0203) 9414.138
> Fax:    +49 (0203) 9414.555
> Rolf.Knaden@conject.com
>
> www.conject.com
>
> konsequent conject.
>
>


0
Chris
3/3/2005 1:19:41 PM
Hi Chris,
It is a number column I want to display.
In the test datawindow, I attached to this, you can see it.
Rolf

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> schrieb im Newsbeitrag
news:42270ee8$1@forums-2-dub...
> Rolf;
>
>     Are you applying this to a DW column of type Long or decimal?
>
> Chris
>
> "Rolf Knaden" <rolf.knaden@conject.com> wrote in message
> news:4227074b@forums-1-dub...
> > Hello everyone.
> > I am using PB 9.0.1 Build 7275.
> > I have problems with formatting number-columns in a datawindow.
> > I want to display the value 12.3456 as an area using the format
"#,##0.00
> > m�". I expect it to be "12,35 m�".
> > But it is displaid as "0.012,35 m�". That is, with leading zeros.
> > Replacing "m�" by any other string always displays the number with
leading
> > zeros.
> > Except for the euro (?) or dollar ($). Using these signs with the same
> > format ("#,##0.00 ?") displays the number as "12,35 ?" (which I would
> > prefer).
> >
> > Why is this so? How can I get rid of the leading zeros?
> >
> > Thanks.
> >
> >
> > -- 
> >
> > Rolf Knaden
> > conject GmbH, c/o Business-Contor Philosophenweg 31-33, 47051 Duisburg
> >
> > Fon:    +49 (0203) 9414.138
> > Fax:    +49 (0203) 9414.555
> > Rolf.Knaden@conject.com
> >
> > www.conject.com
> >
> > konsequent conject.
> >
> >
>
>


begin 666 dg_test_format.srd
M)%!"17AP;W)T2&5A9&5R)&1G7W1E<W1?9F]R;6%T+G-R9 T*<F5L96%S92 Y
M.PT*9&%T87=I;F1O=RAU;FET<STP('1I;65R7VEN=&5R=F%L/3 @8V]L;W(]
M-C<Q,#@X-C0@<')O8V5S<VEN9STQ($A434Q$5SUN;R!P<FEN="YP<FEN=&5R
M;F%M93TB(B!P<FEN="YD;V-U;65N=&YA;64](B(@<')I;G0N;W)I96YT871I
M;VX@/2 P('!R:6YT+FUA<F=I;BYL969T(#T@,3$P('!R:6YT+FUA<F=I;BYR
M:6=H=" ](#$Q,"!P<FEN="YM87)G:6XN=&]P(#T@.38@<')I;G0N;6%R9VEN
M+F)O='1O;2 ](#DV('!R:6YT+G!A<&5R+G-O=7)C92 ](# @<')I;G0N<&%P
M97(N<VEZ92 ](# @<')I;G0N8V%N=7-E9&5F875L='!R:6YT97(]>65S('!R
M:6YT+G!R;VUP=#UN;R!P<FEN="YB=71T;VYS/6YO('!R:6YT+G!R979I97<N
M8G5T=&]N<SUN;R!P<FEN="YC;&EP=&5X=#UN;R!P<FEN="YO=F5R<FED97!R
M:6YT:F]B/6YO('!R:6YT+F-O;&QA=&4]>65S(&AI9&5G<F%Y;&EN93UN;R!G
M<FED+FQI;F5S/3 @*0T*:&5A9&5R*&AE:6=H=#TW-B!C;VQO<CTB-3,V.#<P
M.3$R(B I#0IS=6UM87)Y*&AE:6=H=#TP(&-O;&]R/2(U,S8X-S Y,3(B("D-
M"F9O;W1E<BAH96EG:'0],"!C;VQO<CTB-3,V.#<P.3$R(B I#0ID971A:6PH
M:&5I9VAT/3@X(&-O;&]R/2(U,S8X-S Y,3(B("D-"G1A8FQE*&-O;'5M;CTH
M='EP93UN=6UB97(@=7!D871E=VAE<F5C;&%U<V4];F\@;F%M93UP<FEC92!D
M8FYA;64](E!R:6-E(B I#0H@8V]L=6UN/2AT>7!E/6YU;6)E<B!U<&1A=&5W
M:&5R96-L875S93UN;R!N86UE/6%R96$@9&)N86UE/2)!<F5A(B I#0H@8V]L
M=6UN/2AT>7!E/6YU;6)E<B!U<&1A=&5W:&5R96-L875S93UN;R!N86UE/6YU
M;6)E<B!D8FYA;64](DYU;6)E<B(@*0T*("D-"F1A=&$H(#$R+C,T-38L(#$R
M+C,T-38L(#$R+C,T-38L*2 -"G1E>'0H8F%N9#UH96%D97(@86QI9VYM96YT
M/2(R(B!T97AT/2)!<F5A(B!B;W)D97(](C B(&-O;&]R/2(S,S4U-#0S,B(@
M>#TB-S$X(B!Y/2(X(B!H96EG:'0](C8T(B!W:61T:#TB,S<U(B!H=&UL+G9A
M;'5E:7-H=&UL/2(P(B @;F%M93UA<F5A7W0@=FES:6)L93TB,2(@(&9O;G0N
M9F%C93TB07)I86PB(&9O;G0N:&5I9VAT/2(M,3 B(&9O;G0N=V5I9VAT/2(T
M,# B("!F;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C:#TB,B(@9F]N="YC:&%R
M<V5T/2(P(B!B86-K9W)O=6YD+FUO9&4](C$B(&)A8VMG<F]U;F0N8V]L;W(]
M(C4U,S8T.#$R-R(@*0T*8V]L=6UN*&)A;F0]9&5T86EL(&ED/3(@86QI9VYM
M96YT/2(Q(B!T86)S97%U96YC93TR,"!B;W)D97(](C B(&-O;&]R/2(S,S4U
M-#0S,B(@>#TB-S$X(B!Y/2(X(B!H96EG:'0](C<R(B!W:61T:#TB,S<U(B!F
M;W)M870](B,L(R,P+C P(&VR(B!H=&UL+G9A;'5E:7-H=&UL/2(P(B @;F%M
M93UA<F5A('9I<VEB;&4](C$B(&5D:70N;&EM:70],"!E9&ET+F-A<V4]86YY
M(&5D:70N9F]C=7-R96-T86YG;&4];F\@961I="YA=71O<V5L96-T/7EE<R!E
M9&ET+F%U=&]H<V-R;VQL/7EE<R!E9&ET+FEM96UO9&4]," @9F]N="YF86-E
M/2)!<FEA;"(@9F]N="YH96EG:'0](BTQ,"(@9F]N="YW96EG:'0](C0P,"(@
M(&9O;G0N9F%M:6QY/2(R(B!F;VYT+G!I=&-H/2(R(B!F;VYT+F-H87)S970]
M(C B(&)A8VMG<F]U;F0N;6]D93TB,2(@8F%C:V=R;W5N9"YC;VQO<CTB-34S
M-C0X,3(W(B I#0IT97AT*&)A;F0]:&5A9&5R(&%L:6=N;65N=#TB,B(@=&5X
M=#TB4')I8V4B(&)O<F1E<CTB,"(@8V]L;W(](C,S-34T-#,R(B!X/2(S-S B
M('D](C@B(&AE:6=H=#TB-C0B('=I9'1H/2(S,S@B(&AT;6PN=F%L=65I<VAT
M;6P](C B("!N86UE/7!R:6-E7W0@=FES:6)L93TB,2(@(&9O;G0N9F%C93TB
M07)I86PB(&9O;G0N:&5I9VAT/2(M,3 B(&9O;G0N=V5I9VAT/2(T,# B("!F
M;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C:#TB,B(@9F]N="YC:&%R<V5T/2(P
M(B!B86-K9W)O=6YD+FUO9&4](C$B(&)A8VMG<F]U;F0N8V]L;W(](C4U,S8T
M.#$R-R(@*0T*=&5X="AB86YD/6AE861E<B!A;&EG;FUE;G0](C B('1E>'0]
M(DYU;6)E<B(@8F]R9&5R/2(P(B!C;VQO<CTB,"(@>#TB-2(@>3TB."(@:&5I
M9VAT/2(V-"(@=VED=&@](C,U-R(@:'1M;"YV86QU96ES:'1M;#TB,"(@(&YA
M;64];G5M8F5R7W0@=FES:6)L93TB,2(@(&9O;G0N9F%C93TB07)I86PB(&9O
M;G0N:&5I9VAT/2(M,3 B(&9O;G0N=V5I9VAT/2(T,# B("!F;VYT+F9A;6EL
M>3TB,B(@9F]N="YP:71C:#TB,B(@9F]N="YC:&%R<V5T/2(P(B!B86-K9W)O
M=6YD+FUO9&4](C$B(&)A8VMG<F]U;F0N8V]L;W(](C4U,S8T.#$R-R(@*0T*
M8V]L=6UN*&)A;F0]9&5T86EL(&ED/3$@86QI9VYM96YT/2(Q(B!T86)S97%U
M96YC93TQ,"!B;W)D97(](C B(&-O;&]R/2(S,S4U-#0S,B(@>#TB,S<P(B!Y
M/2(X(B!H96EG:'0](C<R(B!W:61T:#TB,S,X(B!F;W)M870](B,L(R,P+C P
M(( B(&AT;6PN=F%L=65I<VAT;6P](C B("!N86UE/7!R:6-E('9I<VEB;&4]
M(C$B(&5D:70N;&EM:70],"!E9&ET+F-A<V4]86YY(&5D:70N9F]C=7-R96-T
M86YG;&4];F\@961I="YA=71O<V5L96-T/7EE<R!E9&ET+F%U=&]H<V-R;VQL
M/7EE<R!E9&ET+FEM96UO9&4]," @9F]N="YF86-E/2)!<FEA;"(@9F]N="YH
M96EG:'0](BTQ,"(@9F]N="YW96EG:'0](C0P,"(@(&9O;G0N9F%M:6QY/2(R
M(B!F;VYT+G!I=&-H/2(R(B!F;VYT+F-H87)S970](C B(&)A8VMG<F]U;F0N
M;6]D93TB,2(@8F%C:V=R;W5N9"YC;VQO<CTB-34S-C0X,3(W(B I#0IC;VQU
M;6XH8F%N9#UD971A:6P@:60],R!A;&EG;FUE;G0](C B('1A8G-E<75E;F-E
M/3,P(&)O<F1E<CTB,"(@8V]L;W(](C B('@](CDB('D](C@B(&AE:6=H=#TB
M-S(B('=I9'1H/2(S-3(B(&AT;6PN=F%L=65I<VAT;6P](C B("!N86UE/6YU
M;6)E<B!V:7-I8FQE/2(Q(B!E9&ET+FQI;6ET/3 @961I="YC87-E/6%N>2!E
M9&ET+F9O8W5S<F5C=&%N9VQE/6YO(&5D:70N875T;W-E;&5C=#UN;R!E9&ET
M+FEM96UO9&4]," @9F]N="YF86-E/2)!<FEA;"(@9F]N="YH96EG:'0](BTQ
M,"(@9F]N="YW96EG:'0](C0P,"(@(&9O;G0N9F%M:6QY/2(R(B!F;VYT+G!I
M=&-H/2(R(B!F;VYT+F-H87)S970](C B(&)A8VMG<F]U;F0N;6]D93TB,2(@
M8F%C:V=R;W5N9"YC;VQO<CTB-34S-C0X,3(W(B I#0IH=&UL=&%B;&4H8F]R
M9&5R/2(Q(B I#0IH=&UL9V5N*&-L:65N=&5V96YT<STB,2(@8VQI96YT=F%L
M:61A=&EO;CTB,2(@8VQI96YT8V]M<'5T961F:65L9',](C$B(&-L:65N=&9O
M<FUA='1I;F<](C B(&-L:65N='-C<FEP=&%B;&4](C B(&=E;F5R871E:F%V
M87-C<FEP=#TB,2(@96YC;V1E<V5L9FQI;FMA<F=S/2(Q(B!N971S8V%P96QA
M>65R<STB,"(@*0T*97AP;W)T+GAM;"AH96%D9W)O=7!S/2(Q(B!I;F-L=61E
M=VAI=&5S<&%C93TB,"(@;65T861A=&%T>7!E/3 @<V%V96UE=&%D871A/3 @
M*0T*:6UP;W)T+GAM;"@I#0IE>'!O<G0N<&1F*&UE=&AO9#TP(&1I<W1I;&PN
J8W5S=&]M<&]S='-C<FEP=#TB,"(@>'-L9F]P+G!R:6YT/2(P(B I#0H@
`
end

0
Rolf
3/4/2005 7:22:47 AM
Rolf;

    Computed columns work fine (see attached)! Your technique certainly
throws the DW into never-never-land <lol>.

Regards ... Chris


"Rolf Knaden" <rolf.knaden@conject.com> wrote in message
news:42280cc4@forums-2-dub...
> Hi Chris,
> It is a number column I want to display.
> In the test datawindow, I attached to this, you can see it.
> Rolf
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> schrieb im Newsbeitrag
> news:42270ee8$1@forums-2-dub...
> > Rolf;
> >
> >     Are you applying this to a DW column of type Long or decimal?
> >
> > Chris
> >
> > "Rolf Knaden" <rolf.knaden@conject.com> wrote in message
> > news:4227074b@forums-1-dub...
> > > Hello everyone.
> > > I am using PB 9.0.1 Build 7275.
> > > I have problems with formatting number-columns in a datawindow.
> > > I want to display the value 12.3456 as an area using the format
> "#,##0.00
> > > m�". I expect it to be "12,35 m�".
> > > But it is displaid as "0.012,35 m�". That is, with leading zeros.
> > > Replacing "m�" by any other string always displays the number with
> leading
> > > zeros.
> > > Except for the euro (?) or dollar ($). Using these signs with the same
> > > format ("#,##0.00 ?") displays the number as "12,35 ?" (which I would
> > > prefer).
> > >
> > > Why is this so? How can I get rid of the leading zeros?
> > >
> > > Thanks.
> > >
> > >
> > > -- 
> > >
> > > Rolf Knaden
> > > conject GmbH, c/o Business-Contor Philosophenweg 31-33, 47051 Duisburg
> > >
> > > Fon:    +49 (0203) 9414.138
> > > Fax:    +49 (0203) 9414.555
> > > Rolf.Knaden@conject.com
> > >
> > > www.conject.com
> > >
> > > konsequent conject.
> > >
> > >
> >
> >
>
>
>


begin 666 dg_grouptest1.srd
M)%!"17AP;W)T2&5A9&5R)&1G7V=R;W5P=&5S=#$N<W)D#0IR96QE87-E(#D[
M#0ID871A=VEN9&]W*'5N:71S/3 @=&EM97)?:6YT97)V86P],"!C;VQO<CTQ
M-C<W-S(Q-2!P<F]C97-S:6YG/3$@2%1-3$17/6YO('!R:6YT+G!R:6YT97)N
M86UE/2(B('!R:6YT+F1O8W5M96YT;F%M93TB(B!P<FEN="YO<FEE;G1A=&EO
M;B ](# @<')I;G0N;6%R9VEN+FQE9G0@/2 Q,3 @<')I;G0N;6%R9VEN+G)I
M9VAT(#T@,3$P('!R:6YT+FUA<F=I;BYT;W @/2 Y-B!P<FEN="YM87)G:6XN
M8F]T=&]M(#T@.38@<')I;G0N<&%P97(N<V]U<F-E(#T@,"!P<FEN="YP87!E
M<BYS:7IE(#T@,"!P<FEN="YC86YU<V5D969A=6QT<')I;G1E<CUY97,@<')I
M;G0N<')O;7!T/6YO('!R:6YT+F)U='1O;G,];F\@<')I;G0N<')E=FEE=RYB
M=71T;VYS/6YO('!R:6YT+F-L:7!T97AT/6YO('!R:6YT+F]V97)R:61E<')I
M;G1J;V(];F\@<')I;G0N8V]L;&%T93UY97,@:&ED96=R87EL:6YE/6YO(&=R
M:60N;&EN97,]," I#0IH96%D97(H:&5I9VAT/3<V(&-O;&]R/2(U,S8X-S Y
M,3(B("D-"G-U;6UA<GDH:&5I9VAT/3 @8V]L;W(](C4S-C@W,#DQ,B(@*0T*
M9F]O=&5R*&AE:6=H=#TP(&-O;&]R/2(U,S8X-S Y,3(B("D-"F1E=&%I;"AH
M96EG:'0],3 P(&-O;&]R/2(U,S8X-S Y,3(B("D-"G1A8FQE*&-O;'5M;CTH
M='EP93UC:&%R*#8I('5P9&%T97=H97)E8VQA=7-E/7EE<R!N86UE/6=R;W5P
M8V]L=6UN(&1B;F%M93TB9W)O=7!C;VQU;6XB("D-"B!C;VQU;6X]*'1Y<&4]
M;G5M8F5R('5P9&%T97=H97)E8VQA=7-E/7EE<R!N86UE/79A;'5E(&1B;F%M
M93TB9'5A;"YV86QU92(@*0T*(')E=')I979E/2)S96QE8W0@)U9A;'5E,2<@
M87,@1W)O=7!#;VQU;6XL(#$@87,@=F%L=64@9G)O;2!D=6%L('5N:6]N#0IS
M96QE8W0@)U9A;'5E,2<L(#$P(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=6
M86QU93$G+" Q,2!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64Q)RP@
M,3(@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,2<L(#$S(&9R;VT@
M9'5A;"!U;FEO;@T*<V5L96-T("=686QU93$G+" Q-"!F<F]M(&1U86P@=6YI
M;VX-"G-E;&5C=" G5F%L=64Q)RP@,34@9G)O;2!D=6%L('5N:6]N#0IS96QE
M8W0@)U9A;'5E,2<L(#$V(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU
M93$G+" Q-R!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64Q)RP@,3@@
M9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,2<L(#$Y(&9R;VT@9'5A
M;"!U;FEO;@T*<V5L96-T("=686QU93$G+" R(&9R;VT@9'5A;"!U;FEO;@T*
M<V5L96-T("=686QU93$G+" R,"!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G
M5F%L=64Q)RP@,C$@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,2<L
M(#(R(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU93$G+" R,R!F<F]M
M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64Q)RP@,C0@9G)O;2!D=6%L('5N
M:6]N#0IS96QE8W0@)U9A;'5E,2<L(#(U(&9R;VT@9'5A;"!U;FEO;@T*<V5L
M96-T("=686QU93$G+" R-B!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L
M=64Q)RP@,C<@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,2<L(#(X
M(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU93$G+" R.2!F<F]M(&1U
M86P@=6YI;VX-"G-E;&5C=" G5F%L=64Q)RP@,R!F<F]M(&1U86P@=6YI;VX-
M"G-E;&5C=" G5F%L=64Q)RP@,S @9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@
M)U9A;'5E,2<L(#0@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,2<L
M(#4@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,2<L(#8@9G)O;2!D
M=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,2<L(#<@9G)O;2!D=6%L('5N:6]N
M#0IS96QE8W0@)U9A;'5E,2<L(#@@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@
M)U9A;'5E,2<L(#D@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,B<L
M(#$@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,B<L(#$P(&9R;VT@
M9'5A;"!U;FEO;@T*<V5L96-T("=686QU93(G+" Q,2!F<F]M(&1U86P@=6YI
M;VX-"G-E;&5C=" G5F%L=64R)RP@,3(@9G)O;2!D=6%L('5N:6]N#0IS96QE
M8W0@)U9A;'5E,B<L(#$S(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU
M93(G+" Q-"!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64R)RP@,34@
M9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,B<L(#$V(&9R;VT@9'5A
M;"!U;FEO;@T*<V5L96-T("=686QU93(G+" Q-R!F<F]M(&1U86P@=6YI;VX-
M"G-E;&5C=" G5F%L=64R)RP@,3@@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@
M)U9A;'5E,B<L(#$Y(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU93(G
M+" R(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU93(G+" R,"!F<F]M
M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64R)RP@,C$@9G)O;2!D=6%L('5N
M:6]N#0IS96QE8W0@)U9A;'5E,B<L(#(R(&9R;VT@9'5A;"!U;FEO;@T*<V5L
M96-T("=686QU93(G+" R,R!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L
M=64R)RP@,C0@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,B<L(#(U
M(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU93(G+" R-B!F<F]M(&1U
M86P@=6YI;VX-"G-E;&5C=" G5F%L=64R)RP@,C<@9G)O;2!D=6%L('5N:6]N
M#0IS96QE8W0@)U9A;'5E,B<L(#(X(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T
M("=686QU93(G+" R.2!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64R
M)RP@,R!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64R)RP@,S @9G)O
M;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,B<L(#0@9G)O;2!D=6%L('5N
M:6]N#0IS96QE8W0@)U9A;'5E,B<L(#4@9G)O;2!D=6%L('5N:6]N#0IS96QE
M8W0@)U9A;'5E,B<L(#8@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E
M,B<L(#<@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,B<L(#@@9G)O
M;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,B<L(#D@9G)O;2!D=6%L('5N
M:6]N#0IS96QE8W0@)U9A;'5E,R<L(#$@9G)O;2!D=6%L('5N:6]N#0IS96QE
M8W0@)U9A;'5E,R<L(#$P(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU
M93,G+" Q,2!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64S)RP@,3(@
M9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,R<L(#$S(&9R;VT@9'5A
M;"!U;FEO;@T*<V5L96-T("=686QU93,G+" Q-"!F<F]M(&1U86P@=6YI;VX-
M"G-E;&5C=" G5F%L=64S)RP@,34@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@
M)U9A;'5E,R<L(#$V(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU93,G
M+" Q-R!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64S)RP@,3@@9G)O
M;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,R<L(#$Y(&9R;VT@9'5A;"!U
M;FEO;@T*<V5L96-T("=686QU93,G+" R(&9R;VT@9'5A;"!U;FEO;@T*<V5L
M96-T("=686QU93,G+" R,"!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L
M=64S)RP@,C$@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,R<L(#(R
M(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU93,G+" R,R!F<F]M(&1U
M86P@=6YI;VX-"G-E;&5C=" G5F%L=64S)RP@,C0@9G)O;2!D=6%L('5N:6]N
M#0IS96QE8W0@)U9A;'5E,R<L(#(U(&9R;VT@9'5A;"!U;FEO;@T*<V5L96-T
M("=686QU93,G+" R-B!F<F]M(&1U86P@=6YI;VX-"G-E;&5C=" G5F%L=64S
M)RP@,C<@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,R<L(#(X(&9R
M;VT@9'5A;"!U;FEO;@T*<V5L96-T("=686QU93,G+" R.2!F<F]M(&1U86P@
M=6YI;VX-"G-E;&5C=" G5F%L=64S)RP@,R!F<F]M(&1U86P@=6YI;VX-"G-E
M;&5C=" G5F%L=64S)RP@,S @9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A
M;'5E,R<L(#0@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,R<L(#4@
M9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A;'5E,R<L(#8@9G)O;2!D=6%L
M('5N:6]N#0IS96QE8W0@)U9A;'5E,R<L(#<@9G)O;2!D=6%L('5N:6]N#0IS
M96QE8W0@)U9A;'5E,R<L(#@@9G)O;2!D=6%L('5N:6]N#0IS96QE8W0@)U9A
M;'5E,R<L(#D@9G)O;2!D=6%L#0HB("!S;W)T/2)G<F]U<&-O;'5M;B!!('9A
M;'5E($$@(B I#0ID871A*")/;F4B+" Q,C,N-#0L(D]N92(L(#,S+C(Q+")4
M=V\B+" Q+C(S+")4=V\B+" P+CDY+")4:')E92(L(#,Q,C0N.3DL*2 -"F=R
M;W5P*&QE=F5L/3$@:&5A9&5R+FAE:6=H=#TU-B!T<F%I;&5R+FAE:6=H=#TW
M,B!B>3TH(F=R;W5P8V]L=6UN(B I(&YE=W!A9V4]>65S(&AE861E<BYC;VQO
M<CTB-C4R.# B('1R86EL97(N8V]L;W(](C,R-S8X(B I#0IT97AT*&)A;F0]
M:&5A9&5R+C$@86QI9VYM96YT/2(P(B!T97AT/2)'<F]U<$AE861E<B(@8F]R
M9&5R/2(P(B!C;VQO<CTB,"(@>#TB.2(@>3TB-"(@:&5I9VAT/2(V,"(@=VED
M=&@](C4S.2(@:'1M;"YV86QU96ES:'1M;#TB,"(@(&YA;64]<W1?,2!V:7-I
M8FQE/2(Q(B @9F]N="YF86-E/2)!<FEA;"(@9F]N="YH96EG:'0](BTY(B!F
M;VYT+G=E:6=H=#TB-S P(B @9F]N="YF86UI;'D](C(B(&9O;G0N<&ET8V@]
M(C(B(&9O;G0N8VAA<G-E=#TB,"(@8F%C:V=R;W5N9"YM;V1E/2(Q(B!B86-K
M9W)O=6YD+F-O;&]R/2(U-3,V-#@Q,C<B("D-"G1E>'0H8F%N9#UT<F%I;&5R
M+C$@86QI9VYM96YT/2(P(B!T97AT/2)'<F]U<%1R86EL97(B(&)O<F1E<CTB
M,"(@8V]L;W(](C$V-S<W,C$U(B!X/2(Y(B!Y/2(T(B!H96EG:'0](C8P(B!W
M:61T:#TB-3,Y(B!H=&UL+G9A;'5E:7-H=&UL/2(P(B @;F%M93US=%\R('9I
M<VEB;&4](C$B("!F;VYT+F9A8V4](D%R:6%L(B!F;VYT+FAE:6=H=#TB+3DB
M(&9O;G0N=V5I9VAT/2(W,# B("!F;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C
M:#TB,B(@9F]N="YC:&%R<V5T/2(P(B!B86-K9W)O=6YD+FUO9&4](C$B(&)A
M8VMG<F]U;F0N8V]L;W(](C4U,S8T.#$R-R(@*0T*8V]L=6UN*&)A;F0]9&5T
M86EL(&ED/3$@86QI9VYM96YT/2(P(B!T86)S97%U96YC93TS,C<V-B!B;W)D
M97(](C B(&-O;&]R/2(P(B!X/2(Y(B!Y/2(X(B!H96EG:'0](C<R(B!W:61T
M:#TB-3,Y(B!F;W)M870](EMG96YE<F%L72(@:'1M;"YV86QU96ES:'1M;#TB
M,"(@(&YA;64]9W)O=7!C;VQU;6X@=FES:6)L93TB,2(@961I="YL:6UI=#TV
M(&5D:70N8V%S93UA;GD@961I="YF;V-U<W)E8W1A;F=L93UN;R!E9&ET+F%U
M=&]S96QE8W0]>65S(&5D:70N875T;VAS8W)O;&P]>65S(&5D:70N:6UE;6]D
M93TP("!F;VYT+F9A8V4](D%R:6%L(B!F;VYT+FAE:6=H=#TB+3DB(&9O;G0N
M=V5I9VAT/2(T,# B("!F;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C:#TB,B(@
M9F]N="YC:&%R<V5T/2(P(B!B86-K9W)O=6YD+FUO9&4](C$B(&)A8VMG<F]U
M;F0N8V]L;W(](C4S-C@W,#DQ,B(@*0T*8V]L=6UN*&)A;F0]9&5T86EL(&ED
M/3(@86QI9VYM96YT/2(Q(B!T86)S97%U96YC93TS,C<V-B!B;W)D97(](C B
M(&-O;&]R/2(P(B!X/2(U-C(B('D](C@B(&AE:6=H=#TB-S(B('=I9'1H/2(R
M-C4B(&9O<FUA=#TB6T=E;F5R86Q=(B!H=&UL+G9A;'5E:7-H=&UL/2(P(B @
M;F%M93UV86QU95\Q('9I<VEB;&4](C$B(&5D:70N;&EM:70],"!E9&ET+F-A
M<V4]86YY(&5D:70N9F]C=7-R96-T86YG;&4];F\@961I="YA=71O<V5L96-T
M/7EE<R!E9&ET+F%U=&]H<V-R;VQL/7EE<R!E9&ET+FEM96UO9&4]," @9F]N
M="YF86-E/2)!<FEA;"(@9F]N="YH96EG:'0](BTY(B!F;VYT+G=E:6=H=#TB
M-# P(B @9F]N="YF86UI;'D](C(B(&9O;G0N<&ET8V@](C(B(&9O;G0N8VAA
M<G-E=#TB,"(@8F%C:V=R;W5N9"YM;V1E/2(Q(B!B86-K9W)O=6YD+F-O;&]R
M/2(U,S8X-S Y,3(B("D-"F-O;'5M;BAB86YD/61E=&%I;"!I9#TR(&%L:6=N
M;65N=#TB,2(@=&%B<V5Q=65N8V4],S(W-C8@8F]R9&5R/2(P(B!C;VQO<CTB
M,"(@>#TB.#0Q(B!Y/2(X(B!H96EG:'0](C<R(B!W:61T:#TB-#,P(B!F;W)M
M870](B,L(R,P+C P(&TR(B!H=&UL+G9A;'5E:7-H=&UL/2(P(B @;F%M93UV
M86QU95\R('9I<VEB;&4](C$B(&5D:70N;&EM:70],"!E9&ET+F-A<V4]86YY
M(&5D:70N9F]C=7-R96-T86YG;&4];F\@961I="YA=71O<V5L96-T/7EE<R!E
M9&ET+F%U=&]H<V-R;VQL/7EE<R!E9&ET+FEM96UO9&4]," @9F]N="YF86-E
M/2)!<FEA;"(@9F]N="YH96EG:'0](BTY(B!F;VYT+G=E:6=H=#TB-# P(B @
M9F]N="YF86UI;'D](C(B(&9O;G0N<&ET8V@](C(B(&9O;G0N8VAA<G-E=#TB
M,"(@8F%C:V=R;W5N9"YM;V1E/2(Q(B!B86-K9W)O=6YD+F-O;&]R/2(U,S8X
M-S Y,3(B("D-"F-O;7!U=&4H8F%N9#UD971A:6P@86QI9VYM96YT/2(Q(B!E
M>'!R97-S:6]N/2(@4W1R:6YG("AV86QU92P@?B(C+",C,"XP,'XB*2 K('XB
M(&TR?B(B8F]R9&5R/2(P(B!C;VQO<CTB,"(@>#TB,3(X,"(@>3TB."(@:&5I
M9VAT/2(W,B(@=VED=&@](C0Y-"(@9F]R;6%T/2);1V5N97)A;%TB(&AT;6PN
M=F%L=65I<VAT;6P](C B("!N86UE/6-C7W9A;'5E('9I<VEB;&4](C$B("!F
M;VYT+F9A8V4](D%R:6%L(B!F;VYT+FAE:6=H=#TB+3DB(&9O;G0N=V5I9VAT
M/2(T,# B("!F;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C:#TB,B(@9F]N="YC
M:&%R<V5T/2(P(B!B86-K9W)O=6YD+FUO9&4](C$B(&)A8VMG<F]U;F0N8V]L
M;W(](C4S-C@W,#DQ,B(@*0T*=&5X="AB86YD/6AE861E<B!A;&EG;FUE;G0]
M(C(B('1E>'0](D=R;W5P8V]L=6UN(B!B;W)D97(](C B(&-O;&]R/2(P(B!X
M/2(Y(B!Y/2(X(B!H96EG:'0](C8P(B!W:61T:#TB-3,Y(B!H=&UL+G9A;'5E
M:7-H=&UL/2(P(B @;F%M93UG<F]U<&-O;'5M;E]T('9I<VEB;&4](C$B("!F
M;VYT+F9A8V4](D%R:6%L(B!F;VYT+FAE:6=H=#TB+3DB(&9O;G0N=V5I9VAT
M/2(T,# B("!F;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C:#TB,B(@9F]N="YC
M:&%R<V5T/2(P(B!B86-K9W)O=6YD+FUO9&4](C$B(&)A8VMG<F]U;F0N8V]L
M;W(](C4S-C@W,#DQ,B(@*0T*=&5X="AB86YD/6AE861E<B!A;&EG;FUE;G0]
M(C$B('1E>'0](D%S($ES(B!B;W)D97(](C B(&-O;&]R/2(S,S4U-#0S,B(@
M>#TB-34X(B!Y/2(X(B!H96EG:'0](C8P(B!W:61T:#TB,C<P(B!H=&UL+G9A
M;'5E:7-H=&UL/2(P(B @;F%M93US=%\S('9I<VEB;&4](C$B("!F;VYT+F9A
M8V4](D%R:6%L(B!F;VYT+FAE:6=H=#TB+3DB(&9O;G0N=V5I9VAT/2(T,# B
M("!F;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C:#TB,B(@9F]N="YC:&%R<V5T
M/2(P(B!B86-K9W)O=6YD+FUO9&4](C(B(&)A8VMG<F]U;F0N8V]L;W(](C$P
M-S,W-#$X,C0B("D-"G1E>'0H8F%N9#UH96%D97(@86QI9VYM96YT/2(Q(B!T
M97AT/2)$:7-P;&%Y($9O<FUA="(@8F]R9&5R/2(P(B!C;VQO<CTB,S,U-30T
M,S(B('@](C@S-R(@>3TB."(@:&5I9VAT/2(V,"(@=VED=&@](C0S-"(@:'1M
M;"YV86QU96ES:'1M;#TB,"(@(&YA;64]<W1?-"!V:7-I8FQE/2(Q(B @9F]N
M="YF86-E/2)!<FEA;"(@9F]N="YH96EG:'0](BTY(B!F;VYT+G=E:6=H=#TB
M-# P(B @9F]N="YF86UI;'D](C(B(&9O;G0N<&ET8V@](C(B(&9O;G0N8VAA
M<G-E=#TB,"(@8F%C:V=R;W5N9"YM;V1E/2(R(B!B86-K9W)O=6YD+F-O;&]R
M/2(Q,#<S-S0Q.#(T(B I#0IT97AT*&)A;F0]:&5A9&5R(&%L:6=N;65N=#TB
M,2(@=&5X=#TB0V]M<'5T960B(&)O<F1E<CTB,"(@8V]L;W(](C,S-34T-#,R
M(B!X/2(Q,C@P(B!Y/2(X(B!H96EG:'0](C8P(B!W:61T:#TB-#DT(B!H=&UL
M+G9A;'5E:7-H=&UL/2(P(B @;F%M93US=%\U('9I<VEB;&4](C$B("!F;VYT
M+F9A8V4](D%R:6%L(B!F;VYT+FAE:6=H=#TB+3DB(&9O;G0N=V5I9VAT/2(T
M,# B("!F;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C:#TB,B(@9F]N="YC:&%R
M<V5T/2(P(B!B86-K9W)O=6YD+FUO9&4](C(B(&)A8VMG<F]U;F0N8V]L;W(]
M(C$P-S,W-#$X,C0B("D-"FAT;6QT86)L92AB;W)D97(](C$B("D-"FAT;6QG
M96XH8VQI96YT979E;G1S/2(Q(B!C;&EE;G1V86QI9&%T:6]N/2(Q(B!C;&EE
M;G1C;VUP=71E9&9I96QD<STB,2(@8VQI96YT9F]R;6%T=&EN9STB,"(@8VQI
M96YT<V-R:7!T86)L93TB,"(@9V5N97)A=&5J879A<V-R:7!T/2(Q(B!E;F-O
M9&5S96QF;&EN:V%R9W,](C$B(&YE='-C87!E;&%Y97)S/2(P(B I#0IE>'!O
M<G0N>&UL*&AE861G<F]U<',](C$B(&EN8VQU9&5W:&ET97-P86-E/2(P(B!M
M971A9&%T871Y<&4],"!S879E;65T861A=&$]," I#0II;7!O<G0N>&UL*"D-
M"F5X<&]R="YP9&8H;65T:&]D/3 @9&ES=&EL;"YC=7-T;VUP;W-T<V-R:7!T
:/2(P(B!X<VQF;W N<')I;G0](C B("D-"B `
`
end

begin 666 dg_test_format.srd
M)%!"17AP;W)T2&5A9&5R)&1G7W1E<W1?9F]R;6%T+G-R9 T*<F5L96%S92 Y
M.PT*9&%T87=I;F1O=RAU;FET<STP('1I;65R7VEN=&5R=F%L/3 @8V]L;W(]
M-C<Q,#@X-C0@<')O8V5S<VEN9STQ($A434Q$5SUN;R!P<FEN="YP<FEN=&5R
M;F%M93TB(B!P<FEN="YD;V-U;65N=&YA;64](B(@<')I;G0N;W)I96YT871I
M;VX@/2 P('!R:6YT+FUA<F=I;BYL969T(#T@,3$P('!R:6YT+FUA<F=I;BYR
M:6=H=" ](#$Q,"!P<FEN="YM87)G:6XN=&]P(#T@.38@<')I;G0N;6%R9VEN
M+F)O='1O;2 ](#DV('!R:6YT+G!A<&5R+G-O=7)C92 ](# @<')I;G0N<&%P
M97(N<VEZ92 ](# @<')I;G0N8V%N=7-E9&5F875L='!R:6YT97(]>65S('!R
M:6YT+G!R;VUP=#UN;R!P<FEN="YB=71T;VYS/6YO('!R:6YT+G!R979I97<N
M8G5T=&]N<SUN;R!P<FEN="YC;&EP=&5X=#UN;R!P<FEN="YO=F5R<FED97!R
M:6YT:F]B/6YO('!R:6YT+F-O;&QA=&4]>65S(&AI9&5G<F%Y;&EN93UN;R!G
M<FED+FQI;F5S/3 @*0T*:&5A9&5R*&AE:6=H=#TW-B!C;VQO<CTB-3,V.#<P
M.3$R(B I#0IS=6UM87)Y*&AE:6=H=#TP(&-O;&]R/2(U,S8X-S Y,3(B("D-
M"F9O;W1E<BAH96EG:'0],"!C;VQO<CTB-3,V.#<P.3$R(B I#0ID971A:6PH
M:&5I9VAT/3DV(&-O;&]R/2(U,S8X-S Y,3(B("D-"G1A8FQE*&-O;'5M;CTH
M='EP93UN=6UB97(@=7!D871E=VAE<F5C;&%U<V4];F\@;F%M93UP<FEC92!D
M8FYA;64](E!R:6-E(B I#0H@8V]L=6UN/2AT>7!E/6YU;6)E<B!U<&1A=&5W
M:&5R96-L875S93UN;R!N86UE/6%R96$@9&)N86UE/2)!<F5A(B I#0H@8V]L
M=6UN/2AT>7!E/6YU;6)E<B!U<&1A=&5W:&5R96-L875S93UN;R!N86UE/6YU
M;6)E<B!D8FYA;64](DYU;6)E<B(@*0T*("D-"F1A=&$H(#$R+C,T-38L(#$R
M+C,T-38L(#$R+C,T-38L*2 -"G1E>'0H8F%N9#UH96%D97(@86QI9VYM96YT
M/2(R(B!T97AT/2)0<FEC92(@8F]R9&5R/2(P(B!C;VQO<CTB,S,U-30T,S(B
M('@](C,W,"(@>3TB."(@:&5I9VAT/2(V-"(@=VED=&@](C,S."(@:'1M;"YV
M86QU96ES:'1M;#TB,"(@(&YA;64]<')I8V5?="!V:7-I8FQE/2(Q(B @9F]N
M="YF86-E/2)!<FEA;"(@9F]N="YH96EG:'0](BTQ,"(@9F]N="YW96EG:'0]
M(C0P,"(@(&9O;G0N9F%M:6QY/2(R(B!F;VYT+G!I=&-H/2(R(B!F;VYT+F-H
M87)S970](C B(&)A8VMG<F]U;F0N;6]D93TB,2(@8F%C:V=R;W5N9"YC;VQO
M<CTB-34S-C0X,3(W(B I#0IT97AT*&)A;F0]:&5A9&5R(&%L:6=N;65N=#TB
M,"(@=&5X=#TB3G5M8F5R(B!B;W)D97(](C B(&-O;&]R/2(P(B!X/2(Y(B!Y
M/2(X(B!H96EG:'0](C8T(B!W:61T:#TB,S4R(B!H=&UL+G9A;'5E:7-H=&UL
M/2(P(B @;F%M93UN=6UB97)?="!V:7-I8FQE/2(Q(B @9F]N="YF86-E/2)!
M<FEA;"(@9F]N="YH96EG:'0](BTQ,"(@9F]N="YW96EG:'0](C0P,"(@(&9O
M;G0N9F%M:6QY/2(R(B!F;VYT+G!I=&-H/2(R(B!F;VYT+F-H87)S970](C B
M(&)A8VMG<F]U;F0N;6]D93TB,2(@8F%C:V=R;W5N9"YC;VQO<CTB-34S-C0X
M,3(W(B I#0IC;VQU;6XH8F%N9#UD971A:6P@:60],2!A;&EG;FUE;G0](C$B
M('1A8G-E<75E;F-E/3(P(&)O<F1E<CTB,"(@8V]L;W(](C,S-34T-#,R(B!X
M/2(S-S B('D](C@B(&AE:6=H=#TB-S(B('=I9'1H/2(S,S@B(&9O<FUA=#TB
M(RPC(S N,# @@"(@:'1M;"YV86QU96ES:'1M;#TB,"(@(&YA;64]<')I8V4@
M=FES:6)L93TB,2(@961I="YL:6UI=#TP(&5D:70N8V%S93UA;GD@961I="YF
M;V-U<W)E8W1A;F=L93UN;R!E9&ET+F%U=&]S96QE8W0]>65S(&5D:70N875T
M;VAS8W)O;&P]>65S(&5D:70N:6UE;6]D93TP("!F;VYT+F9A8V4](D%R:6%L
M(B!F;VYT+FAE:6=H=#TB+3$P(B!F;VYT+G=E:6=H=#TB-# P(B @9F]N="YF
M86UI;'D](C(B(&9O;G0N<&ET8V@](C(B(&9O;G0N8VAA<G-E=#TB,"(@8F%C
M:V=R;W5N9"YM;V1E/2(Q(B!B86-K9W)O=6YD+F-O;&]R/2(U-3,V-#@Q,C<B
M("D-"F-O;'5M;BAB86YD/61E=&%I;"!I9#TS(&%L:6=N;65N=#TB,"(@=&%B
M<V5Q=65N8V4],3 @8F]R9&5R/2(P(B!C;VQO<CTB,"(@>#TB.2(@>3TB."(@
M:&5I9VAT/2(W,B(@=VED=&@](C,U,B(@9F]R;6%T/2);9V5N97)A;%TB(&AT
M;6PN=F%L=65I<VAT;6P](C B("!N86UE/6YU;6)E<B!V:7-I8FQE/2(Q(B!E
M9&ET+FQI;6ET/3 @961I="YC87-E/6%N>2!E9&ET+F9O8W5S<F5C=&%N9VQE
M/6YO(&5D:70N875T;W-E;&5C=#UN;R!E9&ET+FEM96UO9&4]," @9F]N="YF
M86-E/2)!<FEA;"(@9F]N="YH96EG:'0](BTQ,"(@9F]N="YW96EG:'0](C0P
M,"(@(&9O;G0N9F%M:6QY/2(R(B!F;VYT+G!I=&-H/2(R(B!F;VYT+F-H87)S
M970](C B(&)A8VMG<F]U;F0N;6]D93TB,2(@8F%C:V=R;W5N9"YC;VQO<CTB
M-34S-C0X,3(W(B I#0IT97AT*&)A;F0]:&5A9&5R(&%L:6=N;65N=#TB,B(@
M=&5X=#TB07)E82(@8F]R9&5R/2(P(B!C;VQO<CTB,S,U-30T,S(B('@](C<Q
M."(@>3TB."(@:&5I9VAT/2(V-"(@=VED=&@](C,W-2(@:'1M;"YV86QU96ES
M:'1M;#TB,"(@(&YA;64]87)E85]T('9I<VEB;&4](C$B("!F;VYT+F9A8V4]
M(D%R:6%L(B!F;VYT+FAE:6=H=#TB+3$P(B!F;VYT+G=E:6=H=#TB-# P(B @
M9F]N="YF86UI;'D](C(B(&9O;G0N<&ET8V@](C(B(&9O;G0N8VAA<G-E=#TB
M,"(@8F%C:V=R;W5N9"YM;V1E/2(Q(B!B86-K9W)O=6YD+F-O;&]R/2(U-3,V
M-#@Q,C<B("D-"G1E>'0H8F%N9#UH96%D97(@86QI9VYM96YT/2(Q(B!T97AT
M/2)#;VUP=71E9"!0<FEC92(@8F]R9&5R/2(P(B!C;VQO<CTB,S,U-30T,S(B
M('@](C$Q,#(B('D](C@B(&AE:6=H=#TB-C0B('=I9'1H/2(T,SDB(&AT;6PN
M=F%L=65I<VAT;6P](C B("!N86UE/7-T7S$@=FES:6)L93TB,2(@(&9O;G0N
M9F%C93TB07)I86PB(&9O;G0N:&5I9VAT/2(M,3 B(&9O;G0N=V5I9VAT/2(T
M,# B("!F;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C:#TB,B(@9F]N="YC:&%R
M<V5T/2(P(B!B86-K9W)O=6YD+FUO9&4](C$B(&)A8VMG<F]U;F0N8V]L;W(]
M(C4U,S8T.#$R-R(@*0T*=&5X="AB86YD/6AE861E<B!A;&EG;FUE;G0](C B
M('1E>'0](D-O;7!U=&5D($%R96$B(&)O<F1E<CTB,"(@8V]L;W(](C,S-34T
M-#,R(B!X/2(Q-34P(B!Y/2(X(B!H96EG:'0](C8T(B!W:61T:#TB-#0S(B!H
M=&UL+G9A;'5E:7-H=&UL/2(P(B @;F%M93US=%\R('9I<VEB;&4](C$B("!F
M;VYT+F9A8V4](D%R:6%L(B!F;VYT+FAE:6=H=#TB+3$P(B!F;VYT+G=E:6=H
M=#TB-# P(B @9F]N="YF86UI;'D](C(B(&9O;G0N<&ET8V@](C(B(&9O;G0N
M8VAA<G-E=#TB,"(@8F%C:V=R;W5N9"YM;V1E/2(Q(B!B86-K9W)O=6YD+F-O
M;&]R/2(U-3,V-#@Q,C<B("D-"F-O;'5M;BAB86YD/61E=&%I;"!I9#TR(&%L
M:6=N;65N=#TB,2(@=&%B<V5Q=65N8V4],S @8F]R9&5R/2(P(B!C;VQO<CTB
M,S,U-30T,S(B('@](C<Q."(@>3TB."(@:&5I9VAT/2(W,B(@=VED=&@](C,W
M-2(@9F]R;6%T/2(C+",C,"XP,"!MLB(@:'1M;"YV86QU96ES:'1M;#TB,"(@
M(&YA;64]87)E82!V:7-I8FQE/2(Q(B!E9&ET+FQI;6ET/3 @961I="YC87-E
M/6%N>2!E9&ET+F9O8W5S<F5C=&%N9VQE/6YO(&5D:70N875T;W-E;&5C=#UY
M97,@961I="YA=71O:'-C<F]L;#UY97,@961I="YI;65M;V1E/3 @(&9O;G0N
M9F%C93TB07)I86PB(&9O;G0N:&5I9VAT/2(M,3 B(&9O;G0N=V5I9VAT/2(T
M,# B("!F;VYT+F9A;6EL>3TB,B(@9F]N="YP:71C:#TB,B(@9F]N="YC:&%R
M<V5T/2(P(B!B86-K9W)O=6YD+FUO9&4](C$B(&)A8VMG<F]U;F0N8V]L;W(]
M(C4U,S8T.#$R-R(@*0T*8V]M<'5T92AB86YD/61E=&%I;"!A;&EG;FUE;G0]
M(C$B(&5X<')E<W-I;VX](E-T<FEN9R H<')I8V4L('XB(RPC(S N,#!^(BD@
M*R @?B(@@'XB(F)O<F1E<CTB,"(@8V]L;W(](C,S-34T-#,R(B!X/2(Q,3 R
M(B!Y/2(X(B!H96EG:'0](C<R(B!W:61T:#TB-#,Y(B!F;W)M870](EM'96YE
M<F%L72(@:'1M;"YV86QU96ES:'1M;#TB,"(@(&YA;64]8V-?,2!V:7-I8FQE
M/2(Q(B @9F]N="YF86-E/2)!<FEA;"(@9F]N="YH96EG:'0](BTQ,"(@9F]N
M="YW96EG:'0](C0P,"(@(&9O;G0N9F%M:6QY/2(R(B!F;VYT+G!I=&-H/2(R
M(B!F;VYT+F-H87)S970](C B(&)A8VMG<F]U;F0N;6]D93TB,2(@8F%C:V=R
M;W5N9"YC;VQO<CTB-34S-C0X,3(W(B I#0IC;VUP=71E*&)A;F0]9&5T86EL
M(&%L:6=N;65N=#TB,2(@97AP<F5S<VEO;CTB4W1R:6YG("AA<F5A+'XB(RPC
M(S N,#!^(BD@*R!^(B!M,GXB(F)O<F1E<CTB,"(@8V]L;W(](C,S-34T-#,R
M(B!X/2(Q-34P(B!Y/2(X(B!H96EG:'0](C<R(B!W:61T:#TB-#0S(B!F;W)M
M870](EM'96YE<F%L72(@:'1M;"YV86QU96ES:'1M;#TB,"(@(&YA;64]8V-?
M,B!V:7-I8FQE/2(Q(B @9F]N="YF86-E/2)!<FEA;"(@9F]N="YH96EG:'0]
M(BTQ,"(@9F]N="YW96EG:'0](C0P,"(@(&9O;G0N9F%M:6QY/2(R(B!F;VYT
M+G!I=&-H/2(R(B!F;VYT+F-H87)S970](C B(&)A8VMG<F]U;F0N;6]D93TB
M,2(@8F%C:V=R;W5N9"YC;VQO<CTB-34S-C0X,3(W(B I#0IH=&UL=&%B;&4H
M8F]R9&5R/2(Q(B I#0IH=&UL9V5N*&-L:65N=&5V96YT<STB,2(@8VQI96YT
M=F%L:61A=&EO;CTB,2(@8VQI96YT8V]M<'5T961F:65L9',](C$B(&-L:65N
M=&9O<FUA='1I;F<](C B(&-L:65N='-C<FEP=&%B;&4](C B(&=E;F5R871E
M:F%V87-C<FEP=#TB,2(@96YC;V1E<V5L9FQI;FMA<F=S/2(Q(B!N971S8V%P
M96QA>65R<STB,"(@*0T*97AP;W)T+GAM;"AH96%D9W)O=7!S/2(Q(B!I;F-L
M=61E=VAI=&5S<&%C93TB,"(@;65T861A=&%T>7!E/3 @<V%V96UE=&%D871A
M/3 @*0T*:6UP;W)T+GAM;"@I#0IE>'!O<G0N<&1F*&UE=&AO9#TP(&1I<W1I
M;&PN8W5S=&]M<&]S='-C<FEP=#TB,"(@>'-L9F]P+G!R:6YT/2(P(B I#0H@
`
end

0
Chris
3/4/2005 12:47:44 PM
Chris,
Sorry, but my outlook express, did not accept your attachments. Perhaps you
could zip it!?

But I think you suggest using a computed column like string(newrate
,"#,##0.00")+" m�" as "Dawn T Brown Eyes" suggested in the other thread.
This probably shows the wanted display, but includes some other
disadvantages: The column is sorted as string and querymode will not work
for it.
I'm not satisfied with that.

Rolf

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> schrieb im Newsbeitrag
news:422858f0@forums-1-dub...
> Rolf;
>
>     Computed columns work fine (see attached)! Your technique certainly
> throws the DW into never-never-land <lol>.
>
> Regards ... Chris
>
>
> "Rolf Knaden" <rolf.knaden@conject.com> wrote in message
> news:42280cc4@forums-2-dub...
> > Hi Chris,
> > It is a number column I want to display.
> > In the test datawindow, I attached to this, you can see it.
> > Rolf
> >
> > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> schrieb im Newsbeitrag
> > news:42270ee8$1@forums-2-dub...
> > > Rolf;
> > >
> > >     Are you applying this to a DW column of type Long or decimal?
> > >
> > > Chris
> > >
> > > "Rolf Knaden" <rolf.knaden@conject.com> wrote in message
> > > news:4227074b@forums-1-dub...
> > > > Hello everyone.
> > > > I am using PB 9.0.1 Build 7275.
> > > > I have problems with formatting number-columns in a datawindow.
> > > > I want to display the value 12.3456 as an area using the format
> > "#,##0.00
> > > > m�". I expect it to be "12,35 m�".
> > > > But it is displaid as "0.012,35 m�". That is, with leading zeros.
> > > > Replacing "m�" by any other string always displays the number with
> > leading
> > > > zeros.
> > > > Except for the euro (?) or dollar ($). Using these signs with the
same
> > > > format ("#,##0.00 ?") displays the number as "12,35 ?" (which I
would
> > > > prefer).
> > > >
> > > > Why is this so? How can I get rid of the leading zeros?
> > > >
> > > > Thanks.
> > > >
> > > >
> > > > -- 
> > > >
> > > > Rolf Knaden
> > > > conject GmbH, c/o Business-Contor Philosophenweg 31-33, 47051
Duisburg
> > > >
> > > > Fon:    +49 (0203) 9414.138
> > > > Fax:    +49 (0203) 9414.555
> > > > Rolf.Knaden@conject.com
> > > >
> > > > www.conject.com
> > > >
> > > > konsequent conject.
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>
>


0
Rolf
3/7/2005 8:07:18 AM
Reply:

Similar Artilces:

Formatting numbers without leading zeros
Hello everyone. I have problems with formatting number-columns in a datawindow. I want to display the value 12.3456 as an area using the format "#,##0.00 m�". I expect it to be "12,35 m�". But it is displaid as "0.012,35 m�", that is with leading zeros. Replacing "m�" by any other string always displays the number with leading zeros. Except for signs of currencies, as dollar ($) and euro (?). Using these signs with the same format ("#,##0.00 $") displays the number as "12,35 $" (which I would prefer). Why is this so? How...

format number with leading non-zero
Hello, I want to format a number to become a 9 digits representation, every= time it must have an integer 1 at the front.=0A=0AE.g =0A123 become 100000= 123=0A123456 become 100123456=0A=0AIf I use sprintf I can only make it to h= ave leading zero such as sprintf("%09d", $number);=0A=0AThanks.=0A=0AWillia= m=0A=0A=0ASend instant messages to your online friends http://uk.messenger.= yahoo.com Just insert the literal digit in the format and trim the size accordingly. sprintf("1%08d", $number); Bob McConnell -----Original Message----- From: William [mailto:e...

Format leading zeros?
How can I format a value to always be seven digits with leading zeros? ie: select number from table where it will come out as: 0000007 0000077 0000777 etc. Thank you. BTW _ I know I can do this with a hefty CASE statement but I was looking for something easier. -Robert "Robert Paresi" <FirstInitialLastName@innquest.com> wrote in message news:470ea531$1@forums-1-dub... > How can I format a value to always be seven digits with leading zeros? > > ie: > > select number from table > > where it will come out as: > ...

Zero is not a number for datawindow.
I want to use editmask field for numeric values representing floors in a building.The problem is that no mask allows me to enter 0 (zero) representing ground floor.I need to show the diffrence between the ground floor and the lack of the information about the floor. The mask "###0" is not the solution because null value is shown as 0 (zero) and if I use such a mask, enter any number and delete it I will always have the 0 (zero) shown. Please help me, I am starting to believe that the PowerBuilder is good for nothing. ...

Pad Number with Leading Zeros
------_=_NextPart_001_01C146C3.16F952D0 Content-Type: text/plain; charset="iso-8859-1" Hello. Is there a way to pad a number with leading zeros with 1 command rather than the 2 I used below? It looks like you're supposed to be able to zero-fill with sprintf but I couldn't figure it out. #!/bin/perl -wd $f = 1234; $g = sprintf "%6s", $f; $g =~ s/ /0/g; print "$f\n"; print "$g\n"; ~Carl ------_=_NextPart_001_01C146C3.16F952D0-- ------_=_NextPart_001_01C146C7.025BA040 Content-Type: t...

XSLT, format-number and zero
i use in xslt format-number <xsl:decimal-format decimal-separator="," grouping-separator="."/> at start of doument (it is corect, i'm not american) and in document <xsl:attribute name="sdex"><xsl:value-of select="format-number(./client/name/adr/birth/items/sdex, '###')"/></xsl:attribute> and my problem is, that when there is zero, format-number method returns empty, but i need it to return 0 number. have some ideas?Ales Ruzicka18 years old Czech student & cleaner :)interested in internet technologiesmyBlog Re...

Formatting number with and without decimal point
This is more of a generic powerbuilder question, but can anyone describe how to format a number so that it will show decimal places when there are some but then show the number as an integer (no decimal point) when there are none. Ex. when rounded to 2 decimal places 2.75 should show as 2.75 2.50 should show as 2.5 2.00 should show as 2 Thanks Jay ...

Formatting number with and without decimal point
Can anyone describe how to format a number so that it will show decimal places when there are some but then show the number as an integer (no decimal point) when there are none. Ex. when rounded to 2 decimal places 2.75 should show as 2.75 2.50 should show as 2.5 2.00 should show as 2 Thanks Jay well ... for number display formats, the # represents a number and 0 represents a required number so ... #.## should be what you're looking for Jim On 6 Feb 2008 09:26:12 -0800, in sybase.public.powerbuilder.general <Jay> wrote: >Can anyone describe how...

[Patch] to format for Zero Padded Numbers
--simple boundary Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Description: "cc:Mail Note Part" Since my original posting generated deafening silence, here are patches to enable zero padded numerics in Perl format lines. Context diffs to patch form.h, pp_ctl.c, t/op/write.t and pod/perlform.pod attached. Extracted from patched perlform.pod: ------------ As an alternate form of right justification, you may also use "#" or "0#" characters (with an optional ".") to specify a numeric field. This way you ...

format number as a percent without rounding?
I am trying to display a number as a percentage.  From SQL, it is coming in as .99998.  So, when I do: string.Format("{0:P2}" I am getting 100.00% displayed.  I don't want it to round up to 100 - I want it to display 99.99%.  Is this possible?Thanks! One solution (with 'd' being the number 0.99998) string.Format("{0:P2}", Math.Truncate(d*10000) / 10000)JasonFA View Inside My Head...

What are proper format strings for String.format, Number.format, etc?
Hi guys, I just started using the client side version of the Ajax framework. Everything is working out so far, except that I can't seem to be able to format any strings of numbers the way I want. Wheather I use the String.format or Number.format functions, I just keep getting Sys.FormatException errors. What are the proper format strings? I tried the relevant ones that I use in C#, but it just doesn't work.Help would be much appreciated!  I believe D, C, N, and P are the only valid ones for numbers (client side).Encosia - ASP.NET, AJAX, and more.Latest article: Using complex ...

Re:[Patch] to format for Zero Padded Numbers
--simple boundary Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Description: "cc:Mail Note Part" Oops, new copy of t/op/write.t patch; I forgot to change the number of tests at the top of the file. John Peacock --simple boundary Content-Type: text/plain; charset=US-ASCII; name="write.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="write.patch" *** t/op/write.orig Wed Feb 9 19:51:55 2000 --- t/op/write.t Fri Apr 7 13:27:39 2000 *************** *** 1,6 **** #!....

Number Format and String Format ?
Suppose I have a number "1", how can change the number format to "001" ? How can I convert the number "1" into string format "001" ? Thx for your help ~ :) http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconnumericformatstrings.asp int x = 1;Response.Write(x.ToString("000"));Steven A SmithAspAlliance.com - The #1 ASP.NET CommunityDevAdvice.com - Answers to Questions If you got your data from SQL Stored Procedure, you can do the formating in your query: RIGHT('000' + CAST(Col1 AS varchar), 3) -- Tough People Do Tough Task -- It works ~ Thank you ve...

Formatting columns in a datawindow (Problems with rounding of numbers)
Hello, I have a problem with a datawindow. For a value "qty", the select statement for the datawindow is Select qty = 0.00 from .... In the datawindow, the field qty is formatted with the format #.## or 0.00 When I enter values in this field, it is rounded, either upwards or downwards. So that 3,3 is 3,0 and 3,6 is 4,0 How can I make the datawindow NOT round the numbers I put in? Alf Hi Alf, you have an answer to this question in the database NG. Please refrain from cross posting the same question in multiple sybase.public NGs. Kind regards Chris...

Web resources about - Formating number without leading zeros - sybase.powerbuilder.datawindow

Wikipedia:WikiProject Current Local City Time - Wikipedia, the free encyclopedia
This WikiProject is believed to be inactive. If you are not currently a member of the project, please consider joining it and/or its parent project ...

Wikipedia:WikiProject Current Local City Time - Wikipedia, the free encyclopedia
This WikiProject is believed to be inactive. If you are not currently a member of the project, please consider joining it and/or its parent project ...

Brooker website advert gallery
Our People Affiliations Contact Home Services About Us Positions Resume/CV formating Download an overview of our preferred resume/CV format and ...

Software - Future Shop Community Forums
Discuss software for all types of home or business applications.

AMERICAblog
skip to main skip to sidebar About us - Elections - Gay GOP Primary Schedule - Elections - Romney Economic Crisis - Jobs - TSA - Limbaugh - Fun ...

Wikiful - ARCTABLET NEWS
English (reference page) Translations to be done, your help is needed for the following languages: Korean Completed translations: French , ...

BoardGameGeek - BGG Bugs - Forum - BoardGameGeek
Register Board Games Home Recent Additions Welcome Wiki Subdomains All Abstract Games Customizable Games Children's Games Family Games Party ...

Special Character - Computer, Telephony and Electronics Glossary and Dictionary
Computer, Telephony and Electronics Glossary and Dictionary - CSGNetwork.Com's award winning online glossary of computer, telephony and electronics ...


FileBuzz - Find Software Fast
FileBuzz is your online download destination for Windows, Macintosh, Linux and PDA Freeware, Shareware and Demos.

Resources last updated: 11/26/2015 10:59:18 PM