Search found 92 matches
- Fri Apr 16, 2004 12:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Strip non-numeric characters
- Replies: 4
- Views: 2116
Strip non-numeric characters
I am trying to find a good way to strip all non numeric characters from a string. This is for a phone number that I read from a flat file and this field could be formatted in different ways Eg: (xxx)xxx-xxxx xxx-xxx-xxxx xxxxxxxxxx 1-xxx-xxx-xxxx Is it possible only by examining each character in tu...
- Tue Mar 30, 2004 2:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Rowsplitter does not allow columns to pass through
- Replies: 0
- Views: 644
Rowsplitter does not allow columns to pass through
The pdf for the rowsplitter says that [Apart from the column you need to split,]You can also define additional columns if required. Any columns that are defined here [input tab] and on the Outputs page Columns tab will be passed straight through the stage. But when I try to split only part (one colu...