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 […]
Use Google to find help fast. For example, search on "xpressdox choosefromlist".