Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking field data
Message
 
To
10/03/2004 09:33:39
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00884808
Message ID:
00884813
Views:
14
I assume you are talking about character type values.

Then you may check for occurs("-",value)>0 or just use:
value= chrtran(value,"-","")

To append 0's you may use padl() or padr() functions, like:
value=padl(value,Length_you_need,"0")


>My data arrives is two different formats:
>
>9999-99-999-9999
>and/or
>9999999999999
>
>1. How can I check to see which format it is arriving in?
>
>2. Based off the format that it arrives in, be able to appen 0's to those particular records that dont fill all the way (i.e. 123456, or 1234-56)
Previous
Reply
Map
View

Click here to load this message in the networking platform