Refine realcase data