Search found 92 matches

by vinnz
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...
by vinnz
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...