UltraEdit, UltraCompare, UEStudio forums

Hi Mofi  thank you very much for your help! Really appreciate it! Below is the sample of my code, found got one different format type (first row) 786579734497:768796678888747:Nana:Le-Roy:laki-laki:Kumasi:Cape:Lajang::"1/1/0001 12:00:00 AM"03/17/1996 879899834569:940239023808243:Adelaide:Chloe::::::1...

I have data which look something like this: 879899834569:940239023808243:Adelaide:Chloe::::::1/1/0001 12:00:00 AM:: 667755634560:635298544373715:Godsway:Amedome::::Lajang::1/1/0001 12:00:00 AM:: 787888664559:935534723298821:Nnan:Qwame Abrantepa:laki-laki:Kumasi:::Student:1/1/0001 12:00:00 AM:: 65776...