Carriage Return

[chewy]

Here's another question...

I have an address field that contains info that often has a carriage return (for the suite or floor #). I want to split this address field at the carraige returns into an Address1, Address2 and possibly Address3 fields. One of our mailing houses is unable to read the carraige return for some reason and they end up printing a little box on our mailing labels where the return is supposed to be. Lame huh? Or maybe our system is lame for not splitting up the address field?

Is there any way to do this within FM?

I'm praying to the FileMaker god at this very moment...

chewy

[Fitch]

In the following example, "PP" is a carriage return...

Set field [Address2, Right(Address1, Length(Address1) - Position (Address1, "PP", 1, 1)]

Set field [Address1, Left(Address1, Position (Address1, "PP", 1, 1) - 1]

Set field [Address3, Right(Address2, Length(Address2) - Position (Address2, "PP", 1, 1)]

Set field [Address2, Left(Address2, Position (Address2, "PP", 1, 1) - 1]