Output pattern

[William Conable]

You want the change statement. If there are no other 0s in the field 
except the one you want to change to spaces then it's totally easy:

field YourField
change "0" "  "

(That second parameter is 2 spaces surrounded by quotes.)

If you have other zeros in your field then you'll have to use text 
funnels and maybe a variable or two in order to get what you want. Also 
look at the replace() function. I started to fool with this and ran out 
of time to play before I figured it out but someone else will be able to 
do it on his head.

Bill Conable

O.Calvo wrote:
> I'm sorry, let me correct my request.
>
> I have a series of numbers in a text field of which the second number  
> is always a zero (0). I wish to replace the zero with two spaces.
>
>  From 1023456789
> To 1  23456789
>
> Thanks again for any help.
>
> On Apr 18, 2008, at 8:38 PM, O.Calvo wrote:
>   
>> I have a list of numbers in a text field. I wish to separate the
>> first number from the remaing ones with two (2) spaces, like so:
>>
>>  From 123456789
>> To 1  23456789
>>
>> I tried using the OutputPattern in the Design Sheet with no results.
>> Can someone please tell me how to do it?
>>
>> Thanks in advance,
>> OC
>>
>>
>>
>> _______________________________________________
>> Qna mailing list
>> Qna at provue.com
>> http://provue.com/mailman/listinfo/qna
>>     
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna
>
>