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 · Accepted solution]

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

[AbhilashR]

@Ravy12 - someone in the community had posted this solution months ago (cant remember the name to give credit), but the attached solution should help you to make your text to column more dynamic.