IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only
Back to discussions
Expand all | Collapse all

Replacing the char with space.

  • 1.  Replacing the char with space.

    Posted Wed September 09, 2009 05:31 AM

    Originally posted by: SystemAdmin


    Hi,

    In our project, we have requirement like our system should check that if the Debit account short name contains characters other than the one mentioned below then they should be replaced by spaces;

    A to Z, a- z, 0-9, plus the following
    + Space # = ! ” % & * ; { @
    / - ? : ( ) . , ‘

    So, I would like to know is there any built-in function to meet the above requirement?
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: Replacing the char with space.

    Posted Wed September 09, 2009 11:54 AM

    Originally posted by: SystemAdmin


    Consider using the SUBSTITUTE funtion or the CONVERT function. You can learn more about these functions from the Functions and Expressions book in the online library or by reading the documentation that is built into the Desgin Studio's Insert Function view.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


Related Content