Cannot Convert Text to Number

HCL Domino Domino Forum
1

Hi,

After searching in the forum, I could not draw relevant info for the above said error.

I had a number field with decimal and user setting format,

the field has to accept values with more than one decimal.

eg - 1.2.3 or 5.6.7

It accepts the values with one decimal, is there any alternate to over come this limitation.

suggestions will helps me a lot.

TIA…Gov.

2

Subject: List Operations

1.2.3 is not a typical numeric format, so Notes sees it as text. You can get a numeric result – though not necessarily the one you’re looking for – by using @Explode to turn your original text into a decimal-separated list, then manipulating the pieces.

This example illustrates the principle:

NumResult := 0;

NumAsText := “3.9.72”;

SplitNum := @TextToNumber(@Explode(NumAsText;“.”));

@For( n :=1; n<=@Elements(SplitNum); n := n+1; NumResult := NumResult + SplitNum [n]*@Power(10;1-n-@Integer(@Log(SplitNum[n]))));

NumResult;

3

Subject: On Second Thought

Now that the caffeine has almost reached my brain, here’s an alternative that’s nearly as useless as the first, but faster and simpler:

DecimalPart := “.”;

NumAsText := “3.9.72”;

SplitNum := @Explode(NumAsText;“.”);

@For( n :=2; n<=@Elements(SplitNum); n := n+1; DecimalPart := DecimalPart + SplitNum [n]);

@TextToNumber(SplitNum [1] + DecimalPart);

4

Subject: Cannot Convert Text to Number

Make it a text field.You can convert it to a number when it’s needed to be a number, on the fly… and at that time, you can define how notes will handle it appropriately.

5

Subject: RE: Cannot Convert Text to Number

Hi Stan,

thank you so much for your prompt information. I will change it to simple text field.

Gov.

6

Subject: Cannot Convert Text to Number