Search Results

Hello RJG,

Could you please try following and let me know if this helps you.

awk -F"|" '$2==""{N++} END{print N}' Input_file
In your code it will consider NULL $2 values as well as 0 values...