Forum Discussion

SamW's avatar
SamW
Qrew Cadet
5 years ago

How to create lists of entries in a single field?

Currently, two of my tables include aliases for individuals and organizations. So at the top of each record I have the fields Name and Aliases. Name is just as regular text field, while Aliases is cu...
Formulas and functions
Relationships
Tables and fields
ForrestParker2's avatar
ForrestParker2
Qrew Trainee
5 years ago
One think you might do is just anticipate that they will use characters other than a semi-colon and replace them with the semi-colon.

The formula for the "Aliases (formula)" field walks through each anticipated incorrect separator and replaces it with what we want.

var text replaceCommasAndSpaces = SearchAndReplace([Aliases (separate with ";")],", ",";");
var text replaceSpacesAndCommas = SearchAndReplace($replaceCommasAndSpaces," ,",";");
var text replaceCommas = SearchAndReplace($replaceSpacesAndCommas,",",";");
var text replaceSemiColonsAndSpaces = SearchAndReplace($replaceCommas,"; ",";");
var text replaceSpaces = SearchAndReplace($replaceSemiColonsAndSpaces," ",";");
var text addBackSpacesAfterSemiColon = SearchAndReplace($replaceSpaces,";","; ");

$addBackSpacesAfterSemiColon​


------------------------------
Forrest Parker
------------------------------