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.
checking alphabets in the transformer stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Fri Oct 22, 2010 7:08 am
checking alphabets in the transformer stage
Thanks & Regards,
Bhanu
Bhanu
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 23
- Joined: Fri Oct 22, 2010 7:08 am
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
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
Bhanu