Decimal Validation

vskr72 · Post by **vskr72** » Tue Feb 07, 2012 5:42 pm

I have a column from a text file as '0000000045788999' and I need to do the following:
1. need to perform a decimal validation on it for decimal[18,2].
2. For this I am dividing it by 100 to see if its a valid decimal
3. then set T or F based on the outcome.

When I divide by 100, its becoming as 4.5789e10^5. So, its taking an exponent form and this is failing the validation. How to make it avoid taking the exponent form. Thank you.

Kryt0n · Post by **Kryt0n** » Tue Feb 07, 2012 6:09 pm

What is wrong with IsValid(decimal) which I would hope considers the example to be a decimal? Your result would imply your target field for the division is a float (I think)...

kandyshandy · Post by **kandyshandy** » Tue Feb 07, 2012 9:17 pm

So you want to validate a field from text file? What is the data type of this field in the sequential file stage?