Update - I fully support Rob’s response, below; ask why, before how.
The only other way I can think of, is to set | (single pipe) as the delimiter and then validate/ignore/remove the blank/null fields.
Note - I can’t recall if there was an option to treat consecutive delimiters as one (never mind, this was on Excel)
KM