Search found 1 match

Go to advanced search

by nhyatt
Fri Jun 04, 2004 5:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Removing (,/ -) from the phone column
Replies: 24
Views: 8271

I did have a requirement for returning alphanumeric before and the method I used was Convert(Oconv(Oconv(FieldIn,"MC/A"),"MC/N"),"",FieldIn) If you did need to keep some non alphanumeric characters you could use Convert(Convert("#$%","",Oconv(Oconv(F...

Go to advanced search