Re: Eliminating unwanted quotation marks
Hi @Dani_Oliver - had this same issue the other day. In my case, my equivalent of your “Donor Account” field was a multi-select. You don’t say what field type you have but I think you might also get this behaviour for a linked field and possibly others. Here’s what I did:
I created another field “product type as string” using the formula:
SUBSTITUTE({Product Type} & '', ', ', '-')
This takes the multi-select value and turns it into a string:
{Product Type} & ''
Then I use “substitute” on this, replacing “comma-space” with "-".
Then in my other formula field I reference the “product type as string” field rather than the “product type” field (I hide the “as string” field too).
Is this the “No Quotes Formula” what you want?
A simple formula (no internal quotes)
If the original text will only have commas, and no quote marks, a simple solution is to simply remove the quote marks.
SUBSTITUTE({Linked Record}, '"', '')
A formula for linked records with internal quotes
However, if the original text might have quotes, the previous formula will remove too many quotes. Instead, use a more robust formula that will remove only the extra quotes, keeping any original quotes in place.
IF(LEFT({Linked Record}, 1) = '"',
SUBSTITUTE(
MID({Linked Record}, 2, LEN({Linked Record}) - 2),
'""',
'"'
),
{Linked Record}
)
How it Works
First the formula checks if the first characters is a quote mark. If it is not a quote marks, the formula returns the value of the linked text. However, if the first character is a quote, the formula removes the quotes from the beginning and end of the text with the MID function. The formula also converts any double quotes back to single quotes with the SUBSTITUTE function.
You can see the working demo on my website.
