I've used simple green full strength for stains like soda & stuff... seems to work pretty well.
Spray all over the affected area, brush in to loosen the stain, wipe off with clean rags or paper towel.
Also tried some foaming spray carpet cleaners, they work ok but leave a "chemical" smell...