Page 1 of 1

PX Functions

Posted: Tue May 24, 2005 2:36 am
by simonaco
Hi.

If I want to put a string into decimal field. Which function (parallel jobs) is corrected to use?

For example:
The string is +000000000533719920
The decimal field has formed (18,3)
The final result must be +533719,920
:?
Thanks in advance.

Posted: Tue May 24, 2005 5:51 am
by blewip
Well this should work

Code: Select all

StringToDecimal(DSLink2.VarCharField)/1000

Posted: Tue May 24, 2005 7:36 am
by simonaco
blewip wrote:Well this should work

Code: Select all

StringToDecimal(DSLink2.VarCharField)/1000
I've tested the job with the function. The result is ok.

Thanks for the aid.