Time-Resolved Soft X-Ray Absorption Spectroscopy of Molecules in the Gas and Liquid Phases