PX Functions

simonaco · Post by **simonaco** » Tue May 24, 2005 2:36 am

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.

blewip · Post by **blewip** » Tue May 24, 2005 5:51 am

Well this should work

Code: Select all

StringToDecimal(DSLink2.VarCharField)/1000

simonaco · Post by **simonaco** » Tue May 24, 2005 7:36 am

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.