Does Information Analyzer have equivalents of the DataStage functions StripWhiteSpace, CompactWhiteSpace, character-by-character conversion (DataStage's Convert() function), and Trim(string,stripchar,options) ?
They're certainly not documented for IA or available from the drop-down list, but may be possible using the free-form editor?
Our researches so far suggest not, but we live in hope. We prefer not to need to pre-process data before profiling.
Thank you for your time.
Removing White Space
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne