When the workspace gets an email from the server, the attachment comes in as an array/list.
"email_publisher_attachment{1}"
How do I search within the attachment list to find which is an excel file, then use that as the source attribute for the feature reader?
+13Hi @gallupnroxy,
One way to do this is with the ListSearcher transformer. This is super powerful and can pick out your excel files from the list via a simple search or even a regular expression. See the documentation here: http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/listsearcher.htm
Once it has found the matches, the Index Attribute will be populated with the spot in the list that your excel file was found.
Give it a go!
