There are 3 long-text fields: Author, Name and Date.
I want to combine the 3 fields into 1 field with delimiter |. Any field could be empty and I don’t want a trailing or duplicate delimiter hanging around.
Author & " | " & Name & " | "& Date
John Smith | A Book | 1998
When Author is empty:
| A book | 1998
leaves an unwanted | at the beginning. Similarly you might get a trailing | or double | |
How would you eliminate this issue? TRIM() only works with unwanted whitespaces and a nested IF() is messy and needs to take into account 8 possibilities.