Avatar

Level 4

Hi @Indra123 ,

Using shell script, you could read a csv file from SFTP and check the number of empty columns as 

cat file.csv | head -n 2 | tail -n 1 | grep -c ',,'

As the number of columns would be static, you could calculate the non empty columns.