Filemaker: Rough Lists to Portals and Back
When migrating an old database to filemaker I found several lists (that were a random mixture of comma separated, return separated and semi-colon separated) that I preferred to have as bulleted lists.
More over I decided that filemaker portals would make more sense for future searching and research use.
Printing sequential records from a filemaker portal to a field as a bulleted list was easy via a calculation:
"• "& Substitute(List(portal::testlist);¶;"¶• ")
Converting a rough list that is a mix of comma and returns required a script where the list is copied into $text_string and the string processed into a return separated list and then output to portal rows via a loop:
The demo file contains a script for wipe-first, overwrite the portal and a script that allows for append to the portal.