Help

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

Topic Labels: Formulas
Solved
Jump to Solution
908 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Eiffel_Bemorese
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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)

See Solution in Thread

7 Replies 7

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

Not sure to understand sorry…

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

Abi_arvi
4 - Data Explorer
4 - Data Explorer

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

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
11 - Venus
11 - Venus

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)

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

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.