Delete line break

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?

Welcome to the Airtable community!

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

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

2 Likes

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

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.