Topic
  • 4 replies
  • Latest Post - ‏2013-10-25T15:52:40Z by OpherB
JuliusSahat
JuliusSahat
13 Posts

Pinned topic Retrun String

‏2013-10-23T06:44:54Z | cognos report studio

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
    1086 Posts

    Re: Retrun String

    ‏2013-10-23T18:38:16Z  

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

    Good luck,
    Opher

     

     

  • JuliusSahat
    JuliusSahat
    13 Posts

    Re: Retrun String

    ‏2013-10-25T06:57:04Z  
    • OpherB
    • ‏2013-10-23T18:38:16Z

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

    Good luck,
    Opher

     

     

    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
    63 Posts

    Re: Retrun String

    ‏2013-10-25T13:44:14Z  

    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

    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
    1086 Posts

    Re: Retrun String

    ‏2013-10-25T15:52:40Z  

    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

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

     

    Opher