on 09-29-2008 4:36 PM
how to use the command like in time to create variables on Web intelligence? or any command that has the same function. because i have the following demand ... i have to take "1.1. 1.2%" someone has done something like this?
P.S: BO XI R2
Windows server 2003 SP4
java 1.5
Hi,
Could you explain with more clarity on what you are trying to achieve?
Jacques
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can use the Match function.
Match([Country];"F*") returns True if [Country} is "France"
Match([Country];"?S?") returns True if [Country] is "USA"
Match("New York";"P*") returns False
The pattern can contain the wildcards "*" (replaces any set of characters) or "?" (replaces any single character)
You also need to note that the data type needs to be of type "string".
Further you can use the IF statement as the match function just returns a True or False... i.e IF MATCH is true THEN x ELSE y..
Hope this helps
Jacques
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.