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

[AlteryxIan]

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. 

[binuacs]

@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.

[AlteryxIan]

@binuacs Thank you! Attached is the input data. I'm reviewing the tokenize tool now. 

Thank you very much!

[AlteryxIan]

REGEX Expression to Parse 1 Multiple Word Label and 16 Associated Numerical Values This looks great! The only issue I'm having now is parsing the category name (config screenshots below)

[binuacs]

@AlteryxIan @Use one more Regex tool to parse the category name like the sample workflow which I provided you

[binuacs · Accepted solution]

@AlteryxIan updated workflow attached

[AlteryxIan]

Thank you @binuacs!