Forum Discussion

Occasional Contributor

6 years ago

Format for numeric value

Hello, I am trying to specify a property checkpoint for my fild which contains numbers, to check the format, in the code of my desktop application in Delphi is specified #,##0.00, how can i do it w...

tristaanogre
6 years ago
Now it's clear... so, you're simply wanting to make sure that the contents of the property match a particular format.

So... When setting up your property checkpoint, one of the options in the "Condition" parameter is "cmpMatches". When you select that, then in the "Value" parameter, you enter the regular expression for the format you want as a "String", not a code expression.
tristaanogre
6 years ago
In the blank space in the value field I believe should be the regular expression for the format that you're wanting to check... and yes, it is a "number" techincally, but the wText field in the object is a string property.

You MAY end up not being able to use the built in property check point but might need to write a script routine that you call from within your keyword test to do the validation/check of the contents. Again, regular expressions are going to be your friend here.

trajmo

Occasional Contributor

Actually i dont have a specific value to be checked, i want to check the format for any value entered how it is displayed, i didnt make it still to find a solution, because i cannot find any particular example when only the format is checked, all the examples are for specific values. Can i do it in keyword with Code expression with aqString.Format and how to specify the format within the aqString.Format(??????)?

Here it is the original code for the Format in Delphi:

begin
FilterDFT := CompleteRound(FloatToStr(Dan));
FilterDFTPrimac := CompleteRound(FloatToStr(DanPrimac));
DFT.Text := FormatFloat('#,##0.00',StrToFloat(CompleteRound(FloatToStr(Dan))));
VKIznos.Text := FormatFloat('#,##0.00',StrToFloat(CompleteRound(FloatToStr(Dan + StrToFloat(FilterIznos) + StrToFloat(Provizija.Text)))));
end;

tristaanogre

Esteemed Contributor

6 years ago

Now it's clear... so, you're simply wanting to make sure that the contents of the property match a particular format.

So... When setting up your property checkpoint, one of the options in the "Condition" parameter is "cmpMatches". When you select that, then in the "Value" parameter, you enter the regular expression for the format you want as a "String", not a code expression.

mioani
Occasional Contributor
6 years ago
But this way compares the both properties as strings. If I enter an expression a value as a string it gives me a hard coded value, and the field I want to check is constantly changing which makes the checkpoint useless.

I have a field in my app that can have from 1 to 15 digit numbers and I want to check whether every and each of those numbers entered has the specific format of thousands separated by commas and decimals separated by a dot.

What do you suggest goes in the blank space? Is this right?

Thank you and sorry :)
- tristaanogre
  Esteemed Contributor
  6 years ago
  In the blank space in the value field I believe should be the regular expression for the format that you're wanting to check... and yes, it is a "number" techincally, but the wText field in the object is a string property.
  
  You MAY end up not being able to use the built in property check point but might need to write a script routine that you call from within your keyword test to do the validation/check of the contents. Again, regular expressions are going to be your friend here.
  - mioani
    Occasional Contributor
    6 years ago
    This was very enlightening. Thank you