Character " added at the beginning and at the end of my text formula cell content when copy & paste

[Eiffel_Bemorese]

Hello,

I have a formula column where I dynamically build a string of characters.

Everything is fine to build the new string.

However, when I copy and paste (Command-C) the cell, I end up with a character " added at the beginning and end of the new string but also, by consequence, in the middle of my content if it detects a " character.

It automatically doubles it! Grrr

How can I eliminate this problem?

Thanks for your help. I am getting crazy.

[TheTimeSavingCo]

If you have commas in your string it'll add a quotation when copying I believe

[Eiffel_Bemorese]

Not sure to understand sorry…

What is the connection | link between commas and " sign?

[Abi_arvi]

Could you send any screen shot. Sorry couldn't understand this issue. But looks easy fix. 

[kuovonne]

Open the cell in the larger view (as if it were a long text field). Then select the text inside the editor to copy it. 

The extra quotes get added when you select the entire cell in grid view and there is multi-line text. 

[Sho · Accepted solution]

This is the case I did not know
If you copy multi-line text (text with line break symbols)
single click and paste it into a field, the (") does not increase
edit the field and paste it, the (") is increased (when the text cursor is blinking in the field)

[Eiffel_Bemorese]

Thanks.

I saw this exactly but my topic is that doing this is longer.

I dynamically create SQL instructions and the behaviour I previously describe mix up the SQL code doubling " characters

[Eiffel_Bemorese]

You put me on the right tracks. u r the king!

Airtable, as some spreadsheets, add " character once it detects CRLF inside the content. If no CRLF is detected Airtable does not add extra " character.

In my case I dynamically create some SQL instructions and the text data manipulated by SQL is HTML. So in that case CRLF is not useful 'cause HTML new line is coded <br />

I just dynamically deleted all CRLF (\n) values in my formula and BOUM now when I copy / paste I do not have any extra " characters.

Thanks a lot Sho for your help.