REGEX Expression to Parse 1 Multiple Word Label and 16 Associated Numerical Values

Hi Team,

New to RegEx and the expression tool, and greatful for any assistance you can provide.

Use Case: Input data contains a category represented by multiple words (ex: "Data Access") and 16 unique numerical values (ex: 2.7) associated with each category, in a single column (see below).

Output from RegEx must reformat so that category and each numerical value given their own column (17 columns in total, desired output format sample below)

Again, thanks in advance for any assistance you can provide.

Workflow

Regex

Expression

Accepted answers

binu_acs

@AlteryxIan updated workflow attached

DataPrep_GartnerData.yxmd

All comments

binu_acs

@AlteryxIan one way of doing this with the Regex Tokenize tool. I used some sample data, if you can provide your input data we can try it out with that.