"Jay Honeck" wrote

Unfortunately they no longer make pump-spray Pledge, and the aerosol stuff
is just not right. (It comes out in a foam, instead of liquid.)

Jay Honeck

Have you tried turning a can upside down, and spraying out all of the
propellant? Then you can stab or cut the can open and get the stuff out.
I'll bet the foaming is not there without the pressure.
--
Jim in NC