Using CR 8.0
I have a string field of 14 digits to show phone numbers.
I would like to display the result in the following format
(780)123-4567 Extn. 9999
I have used the following formula adapted from answers found in previous threads -
Picture({RM00102.PHONE1},"(XXX) XXX-XXXX-Extn.-XXXX")
but get the following result
(780) 123-4567 E9tn. 999
The "x" in Extn. is being replaced by the first digit of the last group of four digits.
Is there any way to write this formula to display "Extn." without the x being substituted by a digit from the string ?
I have a string field of 14 digits to show phone numbers.
I would like to display the result in the following format
(780)123-4567 Extn. 9999
I have used the following formula adapted from answers found in previous threads -
Picture({RM00102.PHONE1},"(XXX) XXX-XXXX-Extn.-XXXX")
but get the following result
(780) 123-4567 E9tn. 999
The "x" in Extn. is being replaced by the first digit of the last group of four digits.
Is there any way to write this formula to display "Extn." without the x being substituted by a digit from the string ?