Sep-26-2020, 11:14 PM
It seems that "value per column" rule doesn't always true for your data (e.g. first row: "listen music" (2 words); third row: "Game" (1 word)). You will probably need to define a set of allowed addresses (in advance) to parse such semi-structured data. "Sex" value could be a delimiter (only "F", "M" are allowed).