Focal Point
iDM IsNumber() function?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/2907082016

September 26, 2011, 06:10 PM
AK
iDM IsNumber() function?
Hello,

My source table has a varchar column where the data is entered as numerics (14.2, 13 30 etc) and also as alphabets (TBD, N/A etc.). In my iDM data flow in the target transformation I would like to populate the target column if my source has only numerics and default other incoming values to zero.

In iDM is there any function which does this for me? I was expecting a boolean function like isNumber() which takes a string as input and returns true or false.

Thanks.


iSM 616
iDM 7705
iDQC 802
WF 77
Windows 2008 Server
September 27, 2011, 08:25 PM
Dan Satchell
Functions CHKFMT and PATTERN can be used to check a character string for numerics and alphas.


WebFOCUS 7.7.05