Skip to main content

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.


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 !


Reply