Checking for two types of records in the same column

dspxlearn · Post by **dspxlearn** » Fri May 19, 2006 6:52 am

Hi,

I have a requirement where, i have a source column from which i am getting two types of records which are numeric and alphanumeric which is defined as Varchar field in the DS job.
Now my requirement is, if a record with all numeric characters comes, the preceding zeros should be deleted.
if a record with alphanumeric characters comes, the preceding zeros should be preserved.
So, this requirement is for the records prepadded with zeros.
Can it be achieved for the same column?

kumar_s · Post by **kumar_s** » Fri May 19, 2006 7:14 am

Use alnum() function in transformer to check whether the incoming column is a Alpha numeric. If yes keep as it is else use trim to trim of the leading 0s.

ray.wurlod · Post by **ray.wurlod** » Sat May 20, 2006 1:48 am

Surely alnum("000034A3c") would return true, since every character is alphanumeric? Where does it require a leading alphabetic character?

kumar_s · Post by **kumar_s** » Sat May 20, 2006 5:53 am

Perhaps you can use this

Code: Select all

If Num(DSLink.filed) then Trim(DSLink.field,'0','L') Else DSLink.field