Can this be done?

[rlporter]

I have a field with 7 digits in it, 1234567. Is there a way, in CR9, to separate the digits and display them in different formats? Example, 123-4567 or 1234-567.

Thanks for any help.

rlporter

 

[synapsevampire]

Is this a string or a numeric field?

If it's numeric, try:

picture(totext(1234567,0,"&quot,"XXX-XXXXXXX&quot

Otherwise omit the totext.

-k

 

[rlporter]

The field value is a text field, although only 7 digits, is different for each person listed. I tried this:

picture(totext{{INSTransInmates.Bkg#},0,"&quot,"XXX-XXXX&quot

but got an error:

Too many arguments have been given to this function.

It then highlights the 0,"" as shown above.

If I takeout the totext I get the error, The ) is missing.

Thanks for your help.

 

[synapsevampire]

Your syntax was wrong here:

picture(totext{{INSTransInmates.Bkg#},0,"&quot,"XXX-XXXX&quot

The totext should have had a ( not a {

But all you need is:

picture({INSTransInmates.Bkg#},"XXX-XXXX&quot

-k