How to remove Blank rows in a csv file

Shell Programming and Scripting
1

Hi,
I need help to remove blank rows at the end of file.

Sample data:

"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"T�nsberg, Brygga Kino SF",T�nsberg,202-1,T�nsberg SF 4,202-1-4
,,,,
,,,,
,,,,
,,,,

Expected data:

"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"T�nsberg, Brygga Kino SF",T�nsberg,202-1,T�nsberg SF 4,202-1-4
2 
awk -F, 'length>NF+1' file
3 
grep -vx ,,,, file
4 
 awk '!/^,,,,/' file
5

That needs a $ sign too, no?

awk '!/^,,,,$/' file

---
One more:

awk -F[^,] NF-1 file

awk NF-4 FS= file

grep '[^,]' file

grep ..... file

awk /[^,]/ file
6

you forgot to add sed :slight_smile:

sed -n '/[^,]/p' file
7

Hi Experts,
solution from Franklin works for me
awk -F, 'length>NF+1' file

Thanks to everyone