How extract text as different variables

@Boopathi.M the ID format and country names always varies. The xmal file provided is only applicable for those from Singapore…any other ways that I can solve this?