Conditional formatting in Mask property of [String] field

[RSZ-EC]

Hi everybody!

Working in version 5, I need to return a numeric value with sign always expressed. By now, I use a long-step method, using [1(Value)], and if it not a minus, adding a plus sign.

I wonder if there's a way to avoid inflating my database with more [Composite] and [String] fields for such trivial task. Maybe a conditional formatting in the Mask property of a [String] field, such as "+#.##;-#.##" so positive values get a plus sign and negative value keep its sign?

BTW, where can I find a list with all formatting options of Mask property?

Thanks in advance!

 

[Anti]

Hi, Rommel!

If the task is only to always have a sign before the number, then the String function in the Сomposite field is enough.
[String(Number>0?+:)][Number]

Hope this helps.

 

[Anti]

About the mask.
The table below shows the characters that can be used in an input mask. A space character, the default character for a blank, is needed for cases where a character is permitted but not required.

Character	Meaning
A	ASCII alphabetic character required. A-Z, a-z.
a	ASCII alphabetic character permitted but not required.
N	ASCII alphanumeric character required. A-Z, a-z, 0-9.
n	ASCII alphanumeric character permitted but not required.
X	Any character required.
x	Any character permitted but not required.
9	ASCII digit required. 0-9.
0	ASCII digit permitted but not required.
D	ASCII digit required. 1-9.
d	ASCII digit permitted but not required (1-9).
#	ASCII digit or plus/minus sign permitted but not required.
H	Hexadecimal character required. A-F, a-f, 0-9.
h	Hexadecimal character permitted but not required.
B	Binary character required. 0-1.
b	Binary character required. 0-1.
>	All following alphabetic characters are uppercased.
<	All following alphabetic characters are lowercased.
!	Switch off case conversion.
[ ] { }	Reserved.
\	Use \ to escape the special characters listed above to use them as separators.

Some examples of masks:

Mask	Notes
000.000.000.000;_	IP address; blanks are _.
HH:HH:HH:HH:HH:HH;_	MAC address
0000-00-00	ISO Date; blanks are space
>AAAAA-AAAAA-AAAAA-AAAAA-AAAAA;#	License number; blanks are - and all (alphabetic) characters are converted to uppercase.

 

[RSZ-EC]

Hi, Rommel!

If the task is only to always have a sign before the number, then the String function in the Сomposite field is enough.
[String(Number>0?+:)][Number]

Hope this helps.

Thank you so much! It works as I needed!

Now, my database has two fields less... only if I could put nested [String()] functions in my [Composite] fields it would be perfect.

 

[Anti]

only if I could put nested [String()] functions in my [Composite] fields it would be perfect.

In the future, it is planned to add processing for other Composite fields in the Composite field formula.