IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only

  • 1.  count chars in field with wtx

    Posted 07/26/11 02:47 PM

    Originally posted by: SystemAdmin


    Hi my problem is the following, I have to count the chars in a string from field that takes strings from 7 to 27 chars, and reject them if they are greater than 27
    I have tried using

    IF(count(FIELD)<28,doSomething,NONE) but is not working.
    IF(count(texttonumber(FIELD))<28,doSomething,NONE) but is not working.

    Any help or pointers you can give me will be highly appreciated.
    Thank you very much
    Best Regards
    Ignacio
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: count chars in field with wtx

    Posted 07/26/11 02:52 PM

    Originally posted by: JGibby


    
=IF(SIZE(FIELD)<28,doSomething)


    FYI, you don't need the "NONE" for the third argument to the IF function.

    John
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: count chars in field with wtx

    Posted 07/26/11 03:08 PM

    Originally posted by: SystemAdmin


    Thank you very much John Size did the work!!
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


Related Content