Check first letter is Number or Character

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
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Check first letter is Number or Character

Post by cherry »

Hi All,

How can I check the first letter is a number or character for a value.
Is there any function in DS to achieve this, if yes please let me know.

Thanks in Advance


Best Regards
Cherry
Top
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

If your column name is Z
AlNum(Z[1,1]) - returns true or false
Alpha(Z[1,1]) - returns 1 if alphabetic
Kandy
_________________
Try and Try again…You will succeed atlast!!
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”