perf: use bulk-NULL semantics in split and substring, skip Vec allocation in split

perf: use bulk-NULL semantics in split and substring, skip Vec allocation in split #6822