Reporting on what email address an incoming query was sent to

Content

Hello all,

 

I have a report to show me what email address and incoming query was sent to. 

I am using the following:

substr(to_char(threads.mail_hdr),0+ instr(to_char(threads.mail_hdr),'To:'),-1+instr(to_char(threads.mail_hdr),'MIME')-instr(to_char(threads.mail_hdr),'To:'))

The issue with this is that it is picking up the 'Delivered-To:' entry which is not what I want, I only want to see the 'To:' entry which is further down in the email header.

Is anyone able to help with this?

Thanks

Toby