If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Extract From session parameter

Started by cogboy, 16 Oct 2007 01:51:46 PM

Previous topic - Next topic

cogboy

Hi Everyone

I am having problem in using substring on the session parameter.
for example:

  session parameter:   account.personalinfo.userid
    value:                   FGT12345

I need only first three letters.

question: can i use substring / sould i create a custom session parameter?

Please help me.

Thanks

Cog Boy

rockytopmark

Syntax for SQL Server:

substring(#sq($account.defaultName)# ,1,3)

Syntax for Oracle:

substr(#sq($account.defaultName)# ,1,3)


sq() is a macro function to add single quotes around the string paramter, which is required by the subtring functions.  Because it is a macro function, it must be inside the # delimiters.

jouleskelvin