Conversion of text to decimal

sridhar

Dear Friends,

How to convert a text into a decimal value.

N.Sridhar

Kowa

Use the EVALUATE function. A description of this can be found in the online help.

sridhar

Hi Friends,

I used the following code to convert the text into a decimal

ItemQty (DataType : Decimal)
ItemAvailability (DateType : Text)
Check (DataType : Boolean)

Check := EVALUATE(ItemQty,ItemAvailability);
MESSAGE('%1 %2',ItemQty,Check);

I am getting the output as - 0 No

Thanks & Regards,

N.Sridhar

mjrogers

Your coding seems to be correct. If the value of the text variable is however blank then the result will be negative.

For example:

ItemQty := 0;
ItemAvailability := '1';

Check := EVALUATE(ItemQty,ItemAvailability);

MESSAGE(FORMAT(Check)+' '+FORMAT(ItemQty));

Result is:

Yes 1

ItemQty := 0;
ItemAvailability := '';

Check := EVALUATE(ItemQty,ItemAvailability);

MESSAGE(FORMAT(Check)+' '+FORMAT(ItemQty));

Result is:

No 0

I've tested this and it's fine.

sridhar

Hi Friends,

How to convert the string '(-23)' to a decimal value -23.

Thanks & Regards,

N.Sridhar

Luc_VanDyck

sridhar wrote:

Hi Friends,

How to convert the string '(-23)' to a decimal value -23.

Thanks & Regards,

N.Sridhar

txtString := '(-23)';
EVALUATE(decvalue,CONVERTSTR(txtstring,'()','  '));
MESSAGE('%1',decvalue);

sridhar

Thank you very much Luc Van Dyck.

Works Fine.

Thanks & Regards,
N.Sridhar

kriki

Luc Van Dyck wrote:

txtString := '(-23)';
EVALUATE(decvalue,CONVERTSTR(txtstring,'()','  '));
MESSAGE('%1',decvalue);

Or something more general:

txtString := '(-23aBcDeF)';
txtCharactersToKeep := '1234567890.,-+';
EVALUATE(decValue,DELCHR(txtString,'=',DELCHR(txtString,'=',txtCharactersToKeep)));
MESSAGE('%1',decValue)