topic Re: How to handle Apostrophe in Subject Line in Product Forum

How to handle Apostrophe in Subject Line

sapna_soni0290 — Thu, 04 May 2023 08:47:47 GMT

Hi Team,

I have a scenario. I have 5-6 different subject lines which may come in the email. I want to store all of them into Enviornment variable via comma separated. In two of my subject lines apostrophe is coming in like - "Diner's club add". How can i pass this value of subject line with apostrophe into it as an input parameter to my email utility to extract the received emails.

I am planning to first get the value from env var into a collection. So i have a collection with 1 column & 6 rows. I will use loop to get to the rows. The problem is its not able to pass the specific row which has apostrophe. Getting Error -
Internal : Could not execute code stage because exception thrown by code stage: Cannot parse condition. Error at "@SQL=urn:schemas:httpmail:subject LIKE '...".

Re: How to handle Apostrophe in Subject Line

harish.mogulluri — Thu, 04 May 2023 14:16:15 GMT

Hi Sapna Soni,

May be try to add quotes around aphostraphes before passing to outlook VBO and see that make any difference some thing like below screenshot.

Other approach:
You can add decision stage to verify whether the aphostraphes are present and if it is present break it down as before aphostraphes, Aphostraphes and after aphostraphes as 3 different data items. before sending them to outlook combine all the three data item and see whether you are still having that issue.

Re: How to handle Apostrophe in Subject Line

sapna_soni0290 — Fri, 05 May 2023 09:00:43 GMT

Hi Harsih,
I have tried both your options but I am still getting the same error.

Re: How to handle Apostrophe in Subject Line

plnarayana777 — Fri, 05 May 2023 09:24:34 GMT

can you provide total condition, how you are passing

Regards
Lakshmi Narayana

Re: How to handle Apostrophe in Subject Line

sapna_soni0290 — Fri, 05 May 2023 11:17:54 GMT

Hi Laxmi,

I am having a collection row where the value is *Diner's club add* ,, now i am using a loop to pass this value to utility outlook email to read emails from outlook, Input parameter is [Subjectline.Value], there its throwing error.

Re: How to handle Apostrophe in Subject Line

Mukeshh_k — Fri, 05 May 2023 12:27:43 GMT

Hi @sapna soni - Just as a temporary arrangement until we find the concrete solution for these subject lines - I would use wildcards to keep it going and sort it to pick the latest ones by date or any cut off time & date , see if this works for you meanwhile until we find one ?

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------

Re: How to handle Apostrophe in Subject Line

MichealCharron — Fri, 05 May 2023 12:59:52 GMT

@sapna soni,

We don't use the MS Outlook VBO so I can't test it out but from the error message it looks like something is trying to build a SELECT. You might have to escape your single quotes by adding another single quote into your environment variables. Try putting the following:

Diner''s club add

Re: How to handle Apostrophe in Subject Line

Mukeshh_k — Fri, 05 May 2023 13:14:37 GMT

@sapna soni : Here's the solution - it was just how it was being handled : Just replace the Subject like this and you will get your entry:

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------

Re: How to handle Apostrophe in Subject Line

sapna_soni0290 — Fri, 05 May 2023 14:07:47 GMT

Hi Mukesh,

Thanks this solution works for me.

Re: How to handle Apostrophe in Subject Line

sapna_soni0290 — Mon, 08 May 2023 18:26:39 GMT

Hi,

I have another question around this situation. Is it possible to pass the subject ignoring the case ? Like in input parameter i am passing "*Diners club add*" but in my email subject its "Diners club ADD" or "Diners Club ADD", How can we ignore the case while passing the input & comparing both ? I know there is a way to read all emails coming in the duration(without any subject line) & then compare, but this looks a lengthy way. Is there any direct approach ?

Re: How to handle Apostrophe in Subject Line

harish.mogulluri — Mon, 08 May 2023 21:09:31 GMT

HI Sapna Soni,

If I understand your question you want the result collection having exact match "Diners club add"? and discard other emails?

Re: How to handle Apostrophe in Subject Line

plnarayana777 — Tue, 09 May 2023 01:25:00 GMT

Hi

The filter is already using "like" operator so basically it is like wild card and case will be ignored and i guess you no need to pass any "*" along with subject

Try passing you subject in lower case

also check in the code "@SQL=urn:schemas:httpmail:subject LIKE '%yoursubject%'" in this manner

Regards
Lakshmi Narayana

Re: How to handle Apostrophe in Subject Line

Ian_At_RoyalSurrey — Wed, 10 May 2023 07:00:29 GMT

Morning Sapna

Another option would be to use the BP provided "Utility - Strings" and remove (delete) all punctuation from your text. This way any other unusual email subjects would also be dealt with within the single process step:

These are the characters to delete (with associated quotation marks - ","".""!"":"";""'""""""-"

As with all things RPA, there is always more than one solution.

Brgds
Ian