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
![Confused :?](./images/smilies/icon_confused.gif)
Thanks in advance.
Moderators: chulett, rschirm, roy
Code: Select all
StringToDecimal(DSLink2.VarCharField)/1000
I've tested the job with the function. The result is ok.blewip wrote:Well this should work
Code: Select all
StringToDecimal(DSLink2.VarCharField)/1000