Views:

Product: LABELVIEW, CODESOFT

Version: All Versions

 

text(<<value>> , <<format>>): Returns the value argument written in the format imposed by the format argument, which corresponds to the format described in the explanation of the When Printed variable.

Examples:
text (012345678,"###-##-####") = 012-24-5678
text (2125551212,"(###)###-####") = (212)555-1212

 

Example:
text (12 , "~~~~") = 0012
where ''~'' is replaced by 0 in result value if the input value length is less then format length.

 

Example:
text (12 , "****") or text (12 , "####") = 12
where "*'' and ''#'' are the special symbols replaced by data.