+4Hello,
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.
Best answer by Sho
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)
+31If you have commas in your string it'll add a quotation when copying I believe
+4If 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?
+29Open 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.
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)
+4Open 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.
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
+4This 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)
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.