How to check if value in field is decimal and not string (DATASTAGE)?

Question

How to check if value in field is decimal and not string (DATASTAGE) ? I am using with Datastage Version 8.

score 0 · Answer 1 · edited Dec 24 '18 at 10:36

0

Try using IsValid() with the 'decimal' sub-type on the incoming string.

If IsValid("decimal" , in.value_string ) Then in.value_tring Else SetNull()

edited Dec 24 '18 at 10:36

Unheilig

16,196
193
68
98

answered Dec 24 '18 at 10:16

chamnt

1
1

score 0 · Answer 2 · answered May 05 '20 at 15:49

You can use Alpha & num function inside transformer which gives you whether the given value contains only alphabets. If alpha(column) is 1 then its purely alphabetical. Else check if Num(column) is 1, if this true then it is purely a number.

Reference to official doc-https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ft.usage.doc/topics/r_deeref_String_Functions.html

How to check if value in field is decimal and not string (DATASTAGE)?

2 Answers2