Sum a Text Field

ricky76

Can someone tell me how i can sum a text field. I have a text variable that i pass into number values although these values are held as text within the database. I want to be able to sum the quantity. Any help would be appreciated.

kriki

Can you be a little more clear?

ricky76

Sorry,

I am creating a report which writes to a temp table. I have a text variable called Litres that i pass a text value into. This value is stored as a string in the database but is a number. After each record i want the litres variable to be a running total but as it is text i can't do this.

SteveO

If it's meant to be a number then why is it a text field and not Integer or Decimal?

Anyway...
You can use the EVALUATE function to convert from text to numeric. Check out the help for more info.

Thomas_Hviid_Thorn

How about:

// Get the chars to remove
TmpText := delchr(Litres,'=','0123456789.');
// Remove all chars, except numbers
TmpText := delchr(Litres,'=',TmpText);
evaluate(TmpNumber,TmpText);
SumNumber += TmpNumber

I haven't tried the actual code, but I use the same princippiel for another purpose.
Hope it will help.