Remove last string from last line in a file

Hi,

I have a file like :

I want to remove last string in last line (here total string is "05550"~). And last line end with ~ character.
Output should be :

Please help me

Thanks in advance

sed '$s|\(.*~\)\".*\"~|\1|' inputfile
sed '$s/[^~]*~$//'

@Scruti : this time you were quicker than me