Hi,
I am passing a text and seperating fields based on location as shown below. But as my string consists of decimal values, I am trying to convert these by using stringtodecimal function. Its resulting 00000.00 as output for that field. Let me give more details as below.
StringToDecimal(DSLink3.INPUT[58,64])
This resulting " 00000.00" as output. Where as my input looks like 0002.39
Please tell me what I can do to have appropriate results. Any sort of help is appreciated.
Thanks
Kavuri
string to decimal
Moderators: chulett, rschirm, roy
Re: string to decimal
Why have you got ? Are you trying to use SubString?
I have come across similar issues and mostly it is because your output column may still be String and not changed to Decimal? Is that SubString causing issues?[/code]
Code: Select all
[58,64]
I have come across similar issues and mostly it is because your output column may still be String and not changed to Decimal? Is that SubString causing issues?[/code]