Export Numeric Field 3

[kpeak]

I need help exporting a numeric field, length of 11 with 5 decimals to a text file and have it appear with leading spaces, 4 decimals and show the decimal point. The field contains hours worked (i.e. 40.00000)
Can anyone help me with the formula to do this export?
Thanks!

 

[lbass]

What is the length of the field you want to export? Since you want to eliminate one decimal, do you want a field length = 10?

-LB

 

[lupins46]

You cannot export it in a different format to the way it appears in the report(AFAIK).

You need to create a formula field which formats it the way you want.
For examplethere are 11 spaces between the first pair of quotes)

right(" " & trim(ToText ({Orders.Order Amount},4,"")),11)

 

[goesnowhere]

Give this a try...

WhilePrintingRecords;
Stringvar x;
Numbervar y;
Stringvar z;
// Creates text string to 5 decimal spaces and omits the thousands separator
x := totext({TLORDER.CHARGES},5,'');
y := 15-len(x);
z := space + x;

Hope this helps...

D

 

[goesnowhere]

Oops... TLORDER.CHARGES should be the numeric field that you are exporting. Sorry.

D.

 

[goesnowhere]

Note correction to y variable, should be 11.

WhilePrintingRecords;
Stringvar x;
Numbervar y;
Stringvar z;
// Creates text string to 5 decimal spaces and omits the thousands separator
x := totext({table.field},5,'');
y := 11-len(x);
z := space + x;

 

[synapsevampire]

If you're saying that you want the field padded with spaces to the left, and always have a 4 digit precision, try:

space(11-len(totext({table.number},4,"")))+totext({table.number},4,"")

-k