Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Zip Code Format
Message
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Title:
Miscellaneous
Thread ID:
00236707
Message ID:
00236719
Views:
6
Kevin,

Any time you insert characters into an item with transform() you need to use @R in the format string.

? transform( "123456789", "@R 99999-9999" )

Note though that if your field already contains the - the transform will actually insert another -

>Why does this not work?
>
>The ZipZode field is C(10) and contains
> "12345-6789"
>
>I use
>
> cZipCode = TRANSFORM(Addresses.ZipCode, "99999-9999")
>
>And I get back:
>
> "12345-789"
>
>What am I doing wrong?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform