I noticed that the
Contact.MailingStreet field can be accessed line-by-line in reports with the
Mailing Address Line 1,
Mailing Address Line 2, and
Mailing Address Line 3 fields.
I want to create formula fields that are the equivalent of these fields, using the
RIGHT functions to break out the street address line by line. I have tried various new line variations
(\n, \r\n, <br />) but the
FIND function doesnt seem to pick up on new lines.