Integer Validation issue

vskr72 · Post by **vskr72** » Sun Jan 08, 2012 10:35 pm

I have a column (loast column) coming from a flat file (fixed width). I am doing an integer validation for it using the below statement:

Code: Select all

If IsValid("int32", Col) then 'Valid' else 'invalid'

The values in the source file are between 0 to 5. I was expecting the output to be 'Valid'. But surprisingly its 'Invalid'. Not sure if I am doing anything wrong.

pandeesh · Post by **pandeesh** » Mon Jan 09, 2012 1:23 am

Are you sure that , the column contains a single digit only? i believe there's some non printable characters after that.
try:

Code: Select all

If IsValid("int32", trim(Col)) then 'Valid' else 'invalid'

premupdate · Post by **premupdate** » Tue Jan 10, 2012 3:48 am

The output of IsValid function is either 1 or 0.Change the derivation accordingly.

pandeesh · Post by **pandeesh** » Tue Jan 10, 2012 4:01 am

premupdate wrote:The output of IsValid function is either 1 or 0.Change the derivation accordingly.

Not necessary to change!
As you said it returns true or false.
If true then valid else invalid.

chulett · Post by **chulett** » Tue Jan 10, 2012 7:42 am

So, what was the actual resolution? Posting that information helps future searchers...