Count all columns in a given file

Hi,

I have a file where i have dump of a DB. it has all the columns and rows inside that. I wanted to extract the columns and number of columns from that dump.
Any suggestions will be helpful.

Thanks

Hi,

Post your sample input and expected output.