checking alphabets in the transformer stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bhanuvlakshmi
Participant
Posts: 23
Joined: Fri Oct 22, 2010 7:08 am

checking alphabets in the transformer stage

Post by bhanuvlakshmi »

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.
Thanks & Regards,
Bhanu
vinothkumar
Participant
Posts: 342
Joined: Tue Nov 04, 2008 10:38 am
Location: Chennai, India

Post by vinothkumar »

Include null handling along with this condition
bhanuvlakshmi
Participant
Posts: 23
Joined: Fri Oct 22, 2010 7:08 am

Post by bhanuvlakshmi »

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
Thanks & Regards,
Bhanu
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply