Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Delete line break

Topic Labels: Formulas
Solved
Jump to Solution
355 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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 !