Add a backspace inside a "Insert Text Column" step

Hi,

I have a “Insert Text Column” to concatenate two value but I would like to put a backspace instead of a simple space between the two value (my field is a “long text” field on Airtable, so it acceptes backspaces).

Is there a way to do this ?

Hi @Florent_isidore,

If I’m understanding correctly, you should be able to combine the values in each column by omitting the space between your text merge values.

Alternatively, if you want to remove the last character from a cell, try using the “Extract text from column” step to find all text before the end of your text and use an Offset Length of 1.

Let me know if that helps!

Hi Daniel,

Sorry, I wanted to say a “line break” instead of a “backspace”.

For example, if I have two columns with the following values “Hello” and “Florent”, I would like create a new column with the value
“Hello
Florent”
and not “Hello Florent”.

Thanks for clarifying!

Parabola cannot enter a line break directly into a cell. Taking a look at this documentation, you should be able to insert a line break by using \n when pushing data to Airtable.

Try switching your field type to a formula to see if that works.

Thank you Daniel, I will try that.

Best,