He is just the chap to strain at a gnat and swallow a camel.

他就是那种小事精明，大事糊涂的家伙。