Trim For Carriage Returns In A Field

[Jredeemer14]

Hello,

We use a barcode scanner in our filemaker solution, but it inputs a carriage return at the end of the number on certain barcodes. Unless we manually delete that carriage return, it says there. I'm looking for anything that would automatically take that carriage return out. I've tried the trim function, but that only seems to work with spaces and not carriage returns. A Calculation? Script trigger? Custom function? Any ideas?

[Lee Smith]

Hello,

We use a barcode scanner in our filemaker solution, but it inputs a carriage return at the end of the number on certain barcodes. Unless we manually delete that carriage return, it says there. I'm looking for anything that would automatically take that carriage return out. I've tried the trim function, but that only seems to work with spaces and not carriage returns. A Calculation? Script trigger? Custom function? Any ideas?

Try this Custom Function by Ray Cologon

Trim4

Since your Profile reflects the Standard Edition and not the Advance, you could also use

Substitute ( barcode ; "¶" ; "" )

HTH

Lee

[comment]

Or =

GetValue ( Barcode ; 1 )