I am trying to create a numeric field without decimals with leading zeros. This could also be a character field as long as the number is right justified.
How do I do this
Thank you
Leading zeros
Hot Topic
- Why this SQL select command is not optimized?
- import from excel
- DELETE FOR-PACK ON BUFFERED TABLES
- How to pass a variant value to CFRONT object (Navision) ?
- VFP 9.0 SQL worthless under a non client server network?
- foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc.
- crystal reports
- unresolved issue on DTPicker Control
- Need help on a small open table code
- How to get the UserID and password login to windows in Visual Foxpro?
Leading zeros
Alfie Cordaway
I'm not sure if I am using the answer correctly. Let me explain further. I'm creating a text file for a taxing entity. The wage field must be 11 places with dollars and cents without decimal point, right justified and zero filled. I have 350 records in this file with wages.
Example: the field is 753331, it needs to be 0000075331.
Thanks for the help!!
WholesaleElectric
This should also work:
cFormattedWage = Transform(nWage*100,"@L 99999999999")
Crusaders
Suppose you want a 10 characters (numbers) with leading zeroes.
nNumber = 1234
cNumbers = Padl(Transform(nNumber),10,"0")
HTH
TABARRY
nWage = 7533.31
cFormattedWage = Padl(Transform(nWage*100),11,"0")