Subject: | Re: FORMAT
| Date: | Mon, 20 Aug 2018 07:52:32 -0400
| From: | "Steven Green" <greens@diamondsg.com>
| Newsgroups: | pnews.paradox-dos
|
here's with all the weird shit you can do with it in pdoxwin, too
--
Steven Green
Myrtle Beach, South Carolina, USA
http://www.OasisTradingPost.com
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Bernie van't Hof" wrote in message
news:5b79c88b$1@pnews.thedbcommunity.com...
I don't disagree re that book.
I didn't lose what you sent :-) , it simply doesn't have the info beyond a
simple example. :-(
I know
Wl.p Width with length and no of places
AL, AR, AC Align left/right/centre
CC is mentioned in playrightpro thing as set "proper case"
- Bernie
On 19/8/18 10:43 pm, Steven Green wrote:
> Alan Simpson.. the worst paradox books in paradox history.. he was the one
> who had all the noobs using Edit Mode and trashing their data !!
>
> I gave you the text version of the complete help system, from playright
> pro.. you lost it? :-)
>
> so.. what is it about Format that you need to know?
>
> --
>
> Steven Green
> Myrtle Beach, South Carolina, USA
>
> http://www.OasisTradingPost.com
>
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
> "Bernie van't Hof" wrote in message
> news:5b79366e$1@pnews.thedbcommunity.com...
>
> Implementing calculated fields in forms has prompted proper translation of
> the pdox FORMAT command.
>
> Unfortunately, I don't have the spec. The only pxoxdos book I have is
> "Mastering Paradox 4 for DOS" by Alan Simpson and
> it does no more than mention the command with one example. Similarly
> online help.
>
> Anyone able to help?
>
> As an aside, at the back of the book I noticed two beautifully perforated
> pages of quick reference Rolodex cards. Very
> quaint! Anyone still use Rolodex?
Controls the format of displayed or printed values.
Syntax
format ( const FormatSpec String, const value AnyType ) String
Description
format controls the format of displayed or printed values. formatSpec is a
string expression containing one or more format specifications to be applied
to String.
The following table lists the default format specifications and valid data
types for each format category. You can also use AnyType values as data
types, if the values can be interpreted consistently with the format
category.
Format Meaning Valid data types Default
Width Set allowable field width All Entire data value
and decimal precision
Alignment Alignment within width All AR (right-aligned) for all numeric
types, AL (left-aligned) for all others (including point)
Case Uppercase or lowercase All string types No default
strings
Edit Specify characters and spacing All numeric types See following defaults
Include a specified symbol No default
Decimal point character ED. (period as decimal point)
Whole number separator No separator
Number of leading zeros None
Symbol spacing None
Scientific notation No
Hide trailing spaces No (show spaces)
Use zeros as fill pattern No
Scale numbers up No
Precede with dollar sign No
U.S. or Int'l separators U.S.
Sign Format of positive and All numeric See following
negative numbers
Positive No leading positive sign 999
Negative Leading minus sign -999
Date Specify date formats Date & DateTime mm/dd/yy(yy) for Date or hh:mm:ss
am(pm), mm/dd/yy(yy) for DateTime
Time Specify time formats Time & DateTime hh:mm:ss am(pm) for Date or
hh:mm:ss am(pm), mm/dd/yy(yy) for DateTime
Logical Logical value representation Logical True/False
You can combine two or more format specifications in formatSpec by
separating them with commas.
Type Spec Meaning
Width Wn Specifies the total format width, including special characters,
leading symbols or spaces, decimal point, and whole number separators
W.n Specifies the number of decimal places (W12.2 specifies a 12 character
field, two of which are after the decimal point)
W.W Use decimal places from Windows numbers
W.$ Use decimal places from Windows currency
Alignment AL Left align in field
AR Right align in field
AC Center in field
Case CU Convert to uppercase
CL Convert to lowercase
CC Convert to initial capitals
Edit E(s) s specifies the symbol that precedes a number
E$W Include currency symbol from Windows
EDd d specifies a decimal point character
EDW Use the Windows decimal point character
ENc c specifies whole-number separator
ENW Use the Windows whole number separator
ELn n specifies the number of leading zeros
ELW Use the Windows leading zero setting
EP0 No symbol spacing
EP- Make symbol spacing for negatives
EP+ Make symbol spacing for positives
EPB Make symbol spacing for all numbers
EPW Use the Windows symbol spacing setting
ES Use scientific notation
ET Hide trailing spaces
EZ Use zeros as fill pattern
EB Use blanks as fill pattern
E* Use '*' as fill pattern
E+n Scale the number up
E-n Scale the number down
E$ The same as E($)
EC The same as EN (or EN.D)
EI The same as ED (or ED,N. if EC is set)
Sign S+0 Format positives as $999
S+1 Format positives as +$999
S+2 Format positives as $+999
S+3 Format positives as $999+
S+4 Format positives as 999$
S+5 Format positives as +999$
S+6 Format positives as 999+$
S+7 Format positives as 999$+
S+8 Format positives as $999DB
S+W Format positives as Windows currency
S-0 Format negatives as ($999)
S-1 Format negatives as -$999
S-2 Format negatives as $-999
S-3 Format negatives as $999-
S-4 Format negatives as (999$)
S-5 Format negatives as -999$
S-6 Format negatives as 999-$
S-7 Format negatives as 999$-
S-8 Format negatives as $999CR
S-W Format negatives as Windows currency
SP The same as S-0
S- The same as S-1
S+ The same as S-1+1
SC The same as S-8
SD The same as S-8+8
Date DW1 Day of week as Mon
DW2 Day of week as Monday
DWL Day of week from Windows Long Date
DM1 Month as 1
DM2 Month as 01
DM3 Month as Jan
DM4 Month as January
DML Month from Windows Long Date
DMS Month from Windows Short Date
DD1 Day as 1
DD2 Day as 01
DDL Day from Windows Long Date
DDS Day from Windows Short Date
DY1 Year as 1
DY2 Year as 01
DY3 Year as 1901
DYL Year from Windows Long Date
DYS Year from Windows Short Date
DO(s) s specifies order and separators, use %W for weekday,%D for numeric
day, %M for month, and %Y for year. Separators are literal (12/28/92 as
DO(%W %M-%D-%Y) is Mon 12-28-92)
DOL Order and separators as Windows Long Date
DOS Order and separators as Windows ShortDate
D1 Default date format
D2 As DM4Y3O(%M %D,%Y)
D3 As DO(%M/%D)
D4 As DO(%M/%Y)
D5 As DM3O(%D-%M-%Y)
D6 As DM3O(%M %Y)
D7 As DM3Y3O(%D-%M-%Y)
D8 As DY3O(%M/%D/%Y)
D9 As DO(%D.%M.%Y)
D10 As DO(%D/%M/%Y)
D11 As DO(%Y-%M-%D)
DEYEA(s) s specifies A.D. dates
DEYEB(s) s specifies B.C. dates
Time TH1 Hours as 1T
TH2 Hours as 01
THW Hours from Windows
TM1 Minutes as 1
TM2 Minutes as 01
TMW Minutes from Windows
TS1 Seconds as 1
TS2 Seconds as 01
TSW Seconds from Windows
TNA(s) s is a string that follows times before noon
TNP(s) s is a string that follows times after noon
TNW Noon settings from Windows
TO(s) s specifies the order and separators, use %H for hours, %M for
minutes, %S for seconds, %N for am/pm
TOW Order and separators from Windows
Logical LT(s) s specifies the representation of the logical True value
LF(s) s specifies the representation of the logical False value
LY Logical values as Yes and No
LO Logical values as On and Off
Related Topics
|