Hi aiwalia,

You can divide single invalid_rules_explanation colun into two (one containing only rules names and the other containing only explanation codes) with a regular expression.
 

For rule names:

substituteAll(@"(?<=,|^)(.*?):\(?.*?\)\(??0-9a-f-]+\)\:((A-Z0-9_]+)(?=,|$)", "$1", invalid_rules_explanation)

For explanations:

substituteAll(@"(?<=,|^)(.*?):\(?.*?\)\(??0-9a-f-]+\)\:((A-Z0-9_]+)(?=,|$)", "$2", invalid_rules_explanation)

The expression in both cases is the same, we just take different capturing groups as a result. Here are details on the expression itself.

(?<=,|^)            # positive lookbehind to match a comma or start of the string
(.*?)               # non-greedy capture group to match rule name
:\(.*?\)            # match a colon, followed by an opening parenthesis, column 
                      names, and a closing parenthesis
\(p0-9a-f-]+\):     # match a hexadecimal UUID wrapped in parentheses
(iA-Z0-9_]+)        # capture group to match an explanation code consisting 
                      of uppercase letters, digits, or underscores
(?=,|$)             # positive lookahead to match a comma or end of the string

Thanks a lot @AKislyakov . This has helped me to get to the end solution for Export Report format. This was extremely helpful.