FieldStream$

Takes two parameter: FieldName, Delimiter

Description:

Creates a single string of the data from a single field in the current Work Query, or a specific named Query, and assigns it to a Top Query field. If the second optional parameter is not provided or is blank, CSV rules will be used. Specifying "," as the Delimiter will not use the full CSV rules but instead use a single comma as the delimiter without inspecting the data for commas, double quotes, tabs, or CrLf.

Examples:

[New] MyList | FieldStream$ "Contact.Location"

ForeignWith "Contact"
    [New] MyList | FieldStream$ "Location"
End ForeignWith

[New] MyList | "Me.Contact" | FieldStream$ "Contact.Location"

[New] MyList | FieldStream$ "Contact.Location", $CrLf

[New] MyList | FieldStream$ "Contact.Location", ","