StringtoDecimal Issue

pavankvk · Post by **pavankvk** » Thu Mar 19, 2009 10:01 am

Hi

I am reading a file with decimal vales in a column. Reading the column as vachar.

Record 1 : col: 70.4582
Record 2 : col : 1.234 etc

Using StringToDecimal with trunc_zero. and writing to peek as 10,7

I see the output always as 000.0000000

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 19, 2009 10:56 am

StringToDecimal with trunc_zero ?

pavankvk · Post by **pavankvk** » Thu Mar 19, 2009 11:24 am

Sainath.Srinivasan wrote:StringToDecimal with trunc_zero ?

I guess thats the default.

Even i specify it or not, i don't see any difference.

When i hard code some string like "1234.456" in the StringtoDecimal, it works fine,but it doesn't work with my input

pavankvk · Post by **pavankvk** » Thu Mar 19, 2009 11:45 am

found the issue. its due to 0d hex in the column, took left(col,length(col)-1) and used that as input to stringtodecimal function.

chulett · Post by **chulett** » Thu Mar 19, 2009 12:39 pm

Is that because you're reading a 'DOS' file and not handling the record delimiter properly?

dipanzan · Post by **dipanzan** » Thu Mar 19, 2009 12:45 pm

Reading the file as a DOS fomatted file might have solved the problem..

pavankvk · Post by **pavankvk** » Thu Mar 19, 2009 12:51 pm

dipanzan wrote:Reading the file as a DOS fomatted file might have solved the problem..

Thanks for reminding, I completely forgot about that.been a while i handled dos files :D

pavankvk · Post by **pavankvk** » Thu Mar 19, 2009 12:53 pm

dipanzan wrote:Reading the file as a DOS fomatted file might have solved the problem..

Thanks for reminding, I completely forgot about that.been a while i handled dos files :D