@Replace in a Number Field

HCL Domino Domino Forum
1

HiI have got a problem with a numeric field in a form.

In France we use the , character for decimals.

Everything is Ok when users enter this character in a Numeric Field. But some of them sometimes use the . character and I get an error with documents which are show in my view

ERROR : Unrecognized characters found after number

I tried to add this in Input Validation to replace any . by a ,

FIELD Montant:=@Replace(Montant; “.”; “,”) ;

@All

No error in my code, but this does seems to do anything and error is still there when I save a document

Any idea?

2

Subject: probally because it is a number

@replace is working with a string, and you field is numeric. You may want to do something like

field myValue := @textToNumber(@replace( @text( myValue);“.”,“,”))

did not try this, but it is a start

Cheers,

John