topic Re: Apostrophe in subject line in Product Forum

Apostrophe in subject line

sapna_soni0290 — Wed, 26 Apr 2023 08:23:39 GMT

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.

Re: Apostrophe in subject line

PvD_SE — Wed, 26 Apr 2023 12:40:31 GMT

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

Re: Apostrophe in subject line

harish.mogulluri — Thu, 27 Apr 2023 00:34:21 GMT

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

Re: Apostrophe in subject line

sapna_soni0290 — Fri, 05 May 2023 09:05:53 GMT

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