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?
Best answer by kuovonne
Welcome to the Airtable community!
SUBSTITUTE({field name}, "\n", "")
You can see this and all the other formulas in the formula field reference.
+29Welcome 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 !
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.