DSXchange

Hi

My Requirement is to remove the special characters and check if any alphabets are there and any numbers are there in a column.
i have used the following logic
If Alpha(Convert("~!@#$%^&*()_-+=|\}]{['':;?/>.<,`", "", Column1)) Or
Num(Convert("~!@#$%^&*()_-+=|\}]{['':;?/>.<,`", "", Column1)) Then 1 Else 2

if i use only convert function it is working fine but the alpha is giving a number of warnings like "APT_CombinedOperatorController,1: Null string argument.
it is comming in transformer stage

Could any body please help me in finding it out.

please consider it as priority.

Include null handling along with this condition

My job is like sequential file -->sort-->filter--> T/F-->-->sort--> sequential file.

I am getting the problem i the T/F stage.The column1 is comming form the i/p sequential file in which the column has nullable NO as while creating the i/p file itself NULL values has handled.
still i am getting the warning in hundreds as " APT_CombinedOperatorController,1: Null string argument. "


Please suggest me how to proceed

Suggest you do an exact search for "Null string argument", this has already been asked and answered here.