Passing arguments to a @script function

[ddeblomme]

Hi,

What I have to do is to decode a field value like
'1/3;999999;1/2' and returns 1/3 or 1/2 depending on the value of another field (greater or less than 999999).
I would like to do that at the universe level.
I thought to do that with a VBA script function but I can't pass an argument to that function with the @script function.

If anyone have an idea. Thank you.

Dimitri

 

[CODEBUSTER]

You can use @Prompt() to supply the parameter, I assume that the user supplies this at run time.

 

[ddeblomme]

1/3;999999;1/2 is a field value in a database.
I would like to decode this value at the universe level

 

[Subhashab]

Hi ,
when u say universe level is these fields coming from database and in yes. Then if its a Oracle database you can use the decode and substr function to achieve this.