FORMULA LANGUAGE


Examples: @Explode
Given a semicolon (;) as the default display separator:

1. This example returns a, b, and c in a list.


2. This example returns a, b, c, d, and e in a list.
3. This example returns a list containing "Weekly," "Status," and "Report" if the content of the Topic field is "Weekly Status Report"; "Weekly,Status,Report"; "Weekly;Status;Report"; or "Weekly," "Status," and "Report" separated by newlines.
4. This example returns a list containing "Weekly," "Status," and "Report" if the content of the Topic field is "Weekly+Status+Report"; or "Weekly," "Status," and "Report" separated by newlines.
5. This example specifies the default separators but inserts empty elements for leading, trailing, and consecutive separators.
6. This example specifies the defaults for parameters 2 and 3, but does not treat newlines as separators.
7. This example returns "Please send resume + references" if the content of the entry field is: "Please send resume & references".
8. This example returns "Attendance grows at UCLA; Pomona Colleges; and USC" if the content of the Headline field is "Attendance grows at UCLA, Pomona Colleges, and USC".
9. This example returns 4 if the content of the Country field is "Mexico, Guatemala, Costa Rica, El Salvador".
10. This example returns 07/02/96; 07/03/96; 07/04/96; 07/05/96.
11. This example returns 07/01/94; 05/01/94; 10/01/94; 10/02/94; 10/03/94; 04/01/94; 04/02/94; 04/03/94. Note the order in which the dates are returned: single date-time values are returned first, followed by exploded date-time ranges. The return value is a text list.
12. You might want users to be able to enter a range of dates into an editable, multi-value, time-date field called Duration and display them in a computed, multi-value, text field called Days. Give the Duration field the following input-translation formula: @Date(Duration). Give the Days field the following formula: @Explode(Duration). Users can enter dates into the Duration field in this format: 04/16/71-04/18/71.

See Also