Help

Delete line break

Topic Labels: Formulas
Solved
Jump to Solution
976 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Joannis_Tom
4 - Data Explorer
4 - Data Explorer

Hello community,

I have a problem that is when I scan a barcode with my tablet the following characters are displayed like this:
0096
UNIT0855
121F21

I would like it to be displayed like this:
0096UNIT0855121F21

So I would like a formula that allows me to do this task automatically.

Could someone please help me?

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

SUBSTITUTE({field name}, "\n", "")

You can see this and all the other formulas in the formula field reference.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

SUBSTITUTE({field name}, "\n", "")

You can see this and all the other formulas in the formula field reference.

Thank you it’s perfect ! Have a nice day !