I’m working on something that would allow users to view a record history within table data, both to allow for querying historical values and to have a sense of “audit trail” for a specific column value without having to delve into the entire audit trail for the record.
To do this, I would need to append new commentary to a variable value using some delimiter so the entries can be broken up later for easier viewing (i.e. splitting to an array).
For cases where the commentary could be any free text, perhaps including timedate, and normal punctuation, and perhaps even pasted text that could include other special characters…
Is there a best practice for defining a custom delimiter to avoid the comment entry being split at the wrong location?
I have been thinking of perhaps using a double character as the delimiter, in such a way that should “never” occur during normal editing, such as “;;”.