grep records from text files

[unixwhoopie]

We have records in a text file in the file format:

I only want to grep records where the last but one field is not null. How do I grep these records?

C~234~AS~~~~~~~~~40003~~ (I want to grep this line)
C~234~AS~~~~~~~~~~~~ (I dont want to grep this)
A~234~AS~~~~~~~~~40003~~ (I dont want to grep this line - It should always start with a 'C'))

How do I specify the grep comand? I appreciate your help.

Thanks.

 

[vgersh99]

sed -n -e '/^C.*[^~]~~$/p' myFile.txt

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+