Hi Team I have a requirment, I want to join to files based on column which has some discrepency like Source File: ColA xyz abc lkj LookUp File: ColA post,xyz abc,deu so I want to join xyz with post,xyz & abc with abc,deu I cannot use split function because separator is not constant it is changing across the file.
