delete line 1

[cbsm]

hello,
I have a .csv file (created by 'users'). I need to load this file in a database.
I'd like to 'prepare' the file, to avoid any problem during the load.
This is why I need to delete every line where there is nothing else than ; or spaces.
Example

a;b;c;d
;;;
; ;
;
e;f;g;h

should become :
a;b;c;d
e;f;g;h


Thank you !

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cbsm]

Basically, I do not know much about unix.
I usually use the sed command.
I know for example how to delete a line containing a pattern.
But this case is a bit different and I have no idea how to start.

 

[PHV]

what about this ?
sed -n '/[^ ;]/p'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886