substring on promptmany

[JACOBGO]

Hi,

I need to create a report that prompts the user to insert many 10 letter chars and then I need to find if the table has these values or the last 5 letters of these values so I tried to do substring on the promptmany but it doesn't work because it is not a string but an array. Does anyone have a work around?

 

[drlex]

Which Cognos product are you using for reporting?

soi là, soi carré

 

[JACOBGO]

ibm cognos report studio version 10.1.1

 

[blom0344]

I think you need the King of Java code, PaulM, who moderates on cognoise.com. Or perhaps his blog:

http://cognospaul.wordpress.com/category/javascript/

Ties Blom