JDBC Lookup

How to do a jdbc lookup based on a string in the Sender file name?.

For example Sender file name is NYC1010st.csv and CAL2010st.csv

I need to determne dynamically to go to different systems to get data. If NYC then call to System X , If CAL call another system to get data.

My scenario is MATMAS --> XI ---> FTP. Within XI I need to do jdbc look up based on above criteria.

Thanks for any siggestions and help and is appreciated.