Numeric Validation

JezT · Post by **JezT** » Wed Dec 22, 2004 9:21 am

I am wanting to do some data checking on several fields within a source file.

I need to check that 3 of the fields only contain numeric characters otherwise the row should be rejected.

Any suggestions ?

chulett · Post by **chulett** » Wed Dec 22, 2004 10:11 am

For starters, you can use the Num function. Check the online help for specifics on what it considers numeric.

chucksmith · Post by **chucksmith** » Wed Dec 22, 2004 11:32 am

Just a reminder: Num('1E2') returns @TRUE. You may want to add the Index() function to eliminate the E's.

Num('1E2') And Index('1E2','E',1) = 0 returns @FALSE.

ketfos · Post by **ketfos** » Wed Dec 22, 2004 11:37 am

Hi Smith,

Why does Num('1E2') returns True?

How is Numeric defined in datastage?

Ketfos

chulett · Post by **chulett** » Wed Dec 22, 2004 11:46 am

Scientific Notation.

ketfos · Post by **ketfos** » Wed Dec 22, 2004 1:17 pm

Thanks Chuck and Chulett

Ketfos

ray.wurlod · Post by **ray.wurlod** » Wed Dec 22, 2004 3:00 pm

"Why does Num('1E2') returns True? "

6.023E23 is "scientific" (or "exponential") notation. It means 6.023 multiplied by 10 raised to the power 23. If you remember high school chemistry you will recognise this as Avogadro's number.

ArndW · Post by **ArndW** » Wed Dec 22, 2004 3:08 pm

Ketfos,

ignore Ray, he's being a mole

chulett · Post by **chulett** » Wed Dec 22, 2004 3:17 pm

Way too many geeks here.

mhester · Post by **mhester** » Wed Dec 22, 2004 3:39 pm

And way too much useless information. I don't like feeling like I'm back in chemistry class!

ray.wurlod · Post by **ray.wurlod** » Wed Dec 22, 2004 8:38 pm

Is a molecule a small mole?

(Sorry Mike, couldn't resist.)