handles mixed case data inputs