My CSV file will look like this (pipe separated):
apple|banana|pear||grapefruit lemon|lime|damson|jackfruit |tangerine|nectarine|plum apricot|orange|pineapple|coconut|
(Assume that any sort of whitespace or special characters may be in the individual fields.)
I have to check if any value in any column is null, including the first and last columns.
apple|banana|pear||grapefruit |tangerine|nectarine|plum apricot|orange|pineapple|coconut|
How can I do this?