Use a hard space [alt]0255 (0255 on the numeric pad)
Ben Petersen
On 20 Apr 2001, at 18:42, Bernie Corrigan wrote:
> SET VAR vphone TEXT = '8001234567'
> SET VAR vptest TEXT = (FORMAT(.vphone, '(%%%)^%%%-%%%%'))
>
> Then vptest = (800)^123-4567
>
> I don't know how to insert a space in the string using a simple FORMAT command.
> _______________________________________
> At 04:32 PM 4/20/2001 -0500, you wrote:
> >AHA! the light dawns. You need the ^ space holder in the format
> >
> >(%%%)^%%%-%%%
> >
> >
> >
> >-----Original Message-----
> >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> >Behalf Of Bernie Corrigan
> >Sent: Friday, April 20, 2001 4:48 PM
> >To: [EMAIL PROTECTED]
> >Subject: Re: Formatting a column
> >
> >
> >At 07:07 PM 4/19/2001 -0700, you wrote:
> >>(FORMAT(columname,'(%%%) %%%-%%%%))
> >
> >Doesn't work. This will result in an error condition.
> >
> >It needs to be: (FORMAT(columname,'(%%%) %%%-%%%%'))
> >
> >Also, say we start with a value of 8001234567
> >
> >then leaving the space in the FORMAT argument results in (800)1234-567
> >
> >FORMAT(columname,'(%%%)%%%-%%%%')) results in (800)123-4567
> >
> >
> >
>
>
