Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
4 replies Latest Post - ‏2013-10-25T15:52:40Z by OpherB
JuliusSahat
JuliusSahat
13 Posts
ACCEPTED ANSWER

Pinned topic Retrun String

‏2013-10-23T06:44:54Z |

hi All,

 

i have requirement to like  following data:

 

| NAME                     |     TO BE VALUE     |

MARKO STEP                 MARKO

LOVE MARKO                 MARKO

PRODUCT PRO             PRODUCT

REG PRODUCT             PRODUCT

 

anyone can help me to return  'TO BE VALUE' ?

 

 

Thank u

  • OpherB
    OpherB
    677 Posts
    ACCEPTED ANSWER

    Re: Retrun String

    ‏2013-10-23T18:38:16Z  in response to JuliusSahat

    I suggest you look at using the CASE statement in Report Studio.

    Good luck,
    Opher

     

     

    • JuliusSahat
      JuliusSahat
      13 Posts
      ACCEPTED ANSWER

      Re: Retrun String

      ‏2013-10-25T06:57:04Z  in response to OpherB

      Hi Opher

       

      Thank u for response

      if i using Case statement the 'TO BE VALUE' is static

      i need 'TO BE VALUE' is returned dynamically

       

      anyone can help me?

       

      Thank u

      • DPotterSQL
        DPotterSQL
        57 Posts
        ACCEPTED ANSWER

        Re: Retrun String

        ‏2013-10-25T13:44:14Z  in response to JuliusSahat

        Julius,

        I would need more information about what you are trying to do in order to solve this problem.

        What are you looking to take out of the string? There has to be some similarity about the strings and what you need from them. 
        Example: Any time a word is longer than 4 characters you need to get rid of it and keep the other.

        Thanks,

        Dave

      • OpherB
        OpherB
        677 Posts
        ACCEPTED ANSWER

        Re: Retrun String

        ‏2013-10-25T15:52:40Z  in response to JuliusSahat

        I don't know what you mean by "dynamic". Are there rules for how to edit the original string?

         

        Opher