how the text is found?
it is validating your text with run if qual so text is actually the value you entered in field?
The search is currently in the RUNIF part of the Active Link. At the moment it just gives an error message to say it's found something but I'm trying to capture what it actually is that has been found and storing it in a field on the form
I will suggest to use the community member's built AR Filter API Plug-In to extract using the regular expression Regular Expression (Regex) AR API Filter Plug-in (v4.1) . I am using it and it is working perfectly for extracting strings and populating in other fields.
If you are on Oracle, you can use REGEXP and/or REGEXP_LIKE which are built in oracle functions. You can do a SQL set fields and use a simple select statement out to DUAL.
1 of 1 people found this helpful
Note:- FYI - Oracle REGEX will fail if the length of the field is greater then 4K characters.