My IPeople

Yes, it is possible.  I know of two possibilities:

1. You might try the operator, CO, (rather than EQ, IG, etc.).  This will find the string entered but I think it is not restricted to looking at only the beginning of the field.

Example policy.number  CO  Enter String:

1. To restrict the search to only the beginning of the field:
1. define a field xx.string  Example:  DAT=FREE,LEN=10,VAL=c.xx.string
2. define a field xx.select Example:  DAT=FREE, LEN=1,VAL=IF{c.xx.string=(@policy.number$(L(c.xx.string))) “Y”;”N”}
3. in select add xx.string IG Enter String
4. in select add xx.select EQ “Y”

Give this a try and let me know if I made any “typos”.

Thanks.

is it possible to use string extractions on a select criteria.

I want to be able to enter a varied number of characters in a select criteria to pull specific insurance policy numbers.

For instance, I'd like to pull all patients that have insurance policy numbers that start with "TGT". Then I'd like to run report again and second time pull all patients that have insurance policy numbers that start with the letter "R" etc.

I know how to write the string extactions or operators but I dont'  know to setup using a select criteria so the report can be used for different or variable strings.

thank you

Click reply to respond directly to the list. Unsubscribe at http://myipeople.com/forums/ForumSubscriptions.aspx