Text to columns - Parsing tool

Ravy12

I have a below columns which I want to split. This is straightforward using text to column tool and using delimiter as ,
Step 1 : My question is how can I set number of columns dynamic (and not a static number) such that , the tool only returns non null columns.

Step 2: After splitting into columns, How can I take a sum of those multiple columns

Length

51

59,46

46,55,67,49,60

71,62

40,61,65

grossal

hey @Ravy12,

I'd add a "Record ID" and set the Text To Columns tool to split them into rows instead of columns, this make it easier to summarize them.

I have attached the sample workflow.

If this solved you problem, please consider to accept it as a solution or drop another question if it doesn't.

Alex

2020-03-13-Text-to-Columns.yxmd