Kbase 20889: CorVu: Splitting Values in a Column with Token Function
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/29/2008 |
|
Status: Verified
GOAL:
How to extract a value from a position in a column in CorVu.
FIX:
You must use the token function. You can combine the function with an "extra" prompt or "filter query" prompt to allow the user to select the position to be extracted.
To extract a value from an example column "Array" that contains comma-separated values, follow these steps:
1) Make a user prompt with the text 'Enter Pos'.
2) Execute.
3) Add a character column wide enough for the longest value, with
the formula:
pos = to_integer(getprompt("Enter Pos"));
token((@[Array]),",",pos)