Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with copying a num field padded with zero!
Message
From
31/05/2001 13:24:47
Ed Rauh
Trumbull, Connecticut, United States
 
 
To
31/05/2001 11:19:06
Eric Dieffenwierth
Riverside Health System
Newport News, Virginia, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Help with copying a num field padded with zero!
Miscellaneous
Thread ID:
00513180
Message ID:
00513287
Views:
11
>I have a table that has three fields and one is numeric. I want to copy the fields type sdf but I want to padl() the numeric field with one zero. I was hoping that I wouldn't have to add a character field and replace the numeric field over and then copy.
>
>tried:
>copy fields padl((str(chargecode)),9,"0"),... to file type sdf.
COPY FIELDS PADL('0'+TRANSFORM(chargecode),9), ... TO FILE TYPE SDF
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater

NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform