Paradox Community

Items in pnews.paradox-dos

Subject:Re: FORMAT
Date:Mon, 20 Aug 2018 07:52:32 -0400
From:"Steven Green" <>

here's with all the weird shit you can do with it in pdoxwin, too


Steven Green
Myrtle Beach, South Carolina, USA

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Bernie van't Hof"  wrote in message 

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
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
> "Bernie van't Hof"  wrote in message 
> news:5b79366e$
> 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.


format ( const FormatSpec String, const value AnyType ) String


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

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
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

Copyright © 2004