Apostrophe in subject line

[sapna_soni0290]

Hi,

I have a situation. I have 5-6 different subject lines which may come in an email. I want to store all these into env var with comma separated. In two of my subject lines i have apostrophe coming in , Ex - diner's club add. How can i pass this value into the input parameter of my email utility to extract the received email with that subject line. I will be getting all subject lines into a collection & then planning to loop.

[PvD_SE]

Hi S,

Without having tried it now, I would guess that passing the ' in a data item (or collection field) of type Text should not be a problem. What exception do you encounter?

Happy coding!
---------------
Paul
Sweden

[harish.mogulluri]

Hi Sapna Soni,

You can add all the subject line as comma seperated value 
Some thing like this ex: env1, env'2, env3, env'4, envr5

1) use CSV To Collection action ( Not recall the exact action name) - It will give your environment variables as collection

2)  loop the collection and pass the value from the coll to the utility

[sapna_soni0290]

Hi @Paul JHM van Doorn,

I tried your suggestion , but still I am getting this error - Internal : Could not execute code stage because exception thrown by code stage: Cannot parse condition. Error at "@SQL=urn:schemas:httpmail:subject LIKE '...".