refine craw data