Changing Numeric Data in a Field

[gfath]

Using foxpro to change large inventory database from delimited text file and exporting to excel file. Have one field i need to add decimal in it. example (12123) need to have 12.123 and its a numeric field

 

[RickBorup]

Let's assume the value you're working with is a character data type in VFP and is stored in a variable named lcx. Then if you need a numeric result you can simply do

VAL( lcx) / 1000

If you need a character string as the result you can do

STR( VAL(lcx)/1000, 10, 3)

where 10 is an arbitrary overall length for the result string. Alternatively you can use VFP's string functions, something like this:

LEFT( lcx, LEN( lcx) - 3) + "." + RIGHT( lcx, 3)

And if you need a numeric result from that just do a VAL() on the above:

VAL( LEFT( lcx, LEN( lcx) - 3) + "." + RIGHT( lcx, 3))

 

[Imaginecorp]

If you are using VFP9, look up CAST() function. Do not remember if it was available in 8
t = "100.25"
? vartype(t) **** C
z = CAST(t as N(10,3)
? vartype(z) ****N
**** In a SQL Select
**** "cField", needs to be converted to Numeric
Select <<field1>>,<<field2>>,CAST(cField as N(10,3)) As nField from <<tablename>>

 

[alvechurchdata]

Do not remember if it was available in 8

Cast was new in VFP 9. You'd have to do something like:

[TT]Select Val(cField) + 0.000 As nField From ...[/TT]

The +0.000 forces SQL to reserve three decimal places for this field.

Geoff Franklin

http://www.alvechurchdata.co.uk