The PrefixWith and SuffixWith Functions

June 6, 2016 Help

PrefixWith This function is particularly useful in the situation where, say, you have an address consisting of data elements AddressLine1, AddressLine2, AddressLine3, and AddressLine4, but that perhaps lines 2, 3 and 4 are empty.  Further, you want to present the address in a single line, with the different AddressLine data elements separated by commas. You could code this as: «AddressLine1»«If(AddressLine2 […]

Read the full article →