Showing results for 
Search instead for 
Did you mean: 

Apostrophe in subject line

Level 5


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.


Level 12

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!

Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)

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

If I answered your query. Please mark it as the Best Answer

Harish Mogulluri

Level 5

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 '...".