Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Delete line break

Topic Labels: Formulas
Solved
Jump to Solution
1761 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 !