How to do substring on a multi value parameter

[Kavya]

Hi All,

I have a report that accepts multiple values from a TEXT BOX Prompt.
For example user entered values can be like:
bhn76999654
gh67835179o
AN638672ybv

Requirement is to match only the seven characters from the third character of the above given values to a field in a table.
So, my where clause should be like:
table.field IN (substr(bhn76999654,3,7), substr(gh67835179o,3,7), substr(AN638672ybv,3,7))

I am using oracle 12c and Cognos 10.2.1

Appreciate your help!