code syntax remove comma from decimal in RecRef

TomSL

need to convert 11,375.75 to 11375.75 in Recref

can someone give me guidance.

serdarulutas

I am not 100% sure but does it not depend on your OS regional settings by default?

https://resrequest.helpspot.com/index.php?pg=kb.page&id=279

AlexDen

Hi,

EVALUATE(DecimalValue, DELCHR('11,375.75','=',','),9);
FieldRef.Value := DecimalValue;

But be aware that for 11375,75 this code returns 1137575 as a result.
For 11 375,75 a conversion error will occur.

Tryzub

Decimal C/AL type variable/field can be easily formatted without thousand separator which depend on the OS Regional Settings.

I would use the Format function with XML settings (last parameter is 9).

String := FORMAT(Value [, Length] [, FormatStr/FormatNumber])


// Sample
T17_Temp.INIT;
T17_Temp.Amount := 11375.75;
RecRef.GETTABLE(T17_Temp);
FldRef := RecRef.FIELD(17);
testDecimal := FldRef.VALUE;

// by default is formatted with <Integer Thousand> i.e. Format 0
MESSAGE(FORMAT(testDecimal));

// comma or any other thousand separator is removed - Format 9
MESSAGE(FORMAT(testDecimal,0,9));


More elaborated formatting could be achieved by composing the relevant FormatStr

TomSL

my code is this.

IF (TableID = 271) AND (BankMapRec."Field No." = 17) THEN
IF EVALUATE(testDecimal,FORMAT(RecField)) THEN BEGIN
RecField.VALUE(FORMAT(ABS(testDecimal),0,9));

But this is not going correctly. Still appear thosusand thousand separator. what should I do?

AlexDen

You have to format string during conversion to decimal:

IF EVALUATE(testDecimal,FORMAT(RecField,0,9)) THEN BEGIN
  RecField.VALUE(FORMAT(ABS(testDecimal),0,9));

TomSL

Alex,

Still appearing for thousand separator this too.