3 ms·
At least you don't need these values in your data, unlike the comma, which shows up in human-written text. If you do need these values in your data, then don't
by immibis 2y ago
At least you don't need these values in your data, unlike the comma, which shows up in human-written text.
If you do need these values in your data, then don't use them as delimiters.
Something the industry has stopped doing, but maybe should do again, is restricting characters that can appear in data. "The first name must not contain a record separator" is a quite reasonable restriction. Even Elon Musk's next kid won't be able to violate that restriction.