R>SET VAR vPhone TEXT = '(250) 464-5864' R>set var vDigits TEXT = (SKEEP(.vPhone,'1234567890')) R>SET VAR vShowPhone TEXT = (FORMAT(.vDigits,'999-999-9999')) R>SHOW v v% Variable = Value Type -------------------- ------------------------------ ------- vPhone = (250) 464-5864 TEXT vDigits = 2504645864 TEXT vShowPhone = 250-464-5864 TEXT
> On Mar 24, 2019, at 8:46 AM, Myron Finegold <[email protected]> wrote: > > Background: I have a table that stores a telephone number as a text value. > Challenge: How do display the telephone number in a form formatted as > 555-698-4567 (or something close)? > I’ve used the input format mask as shown below. > > I’ve tried the format mask (000) 000_0000;1;_ in a DB Edit ‘Input Format > Mask’ field – no joy. > And I’ve tried !\(999\)\ 000\-0000;0; - again – no joy. > > <image003.jpg> > > > And is there a way to format the number is an ‘Enhanced BD Grid Properties’ > column field? > > Then of course the question that begs to be asked is; should I change the > table data to reflect the output I need? > If so, what is the best way to accomplish this? > > Myron Finegold > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
