Extract data from PDF - Split column

[Brain]

Hi
I use this workflow from @mwiegand : Extract data from a PDF.
Extract data from PDF TRACKING.knwf (138.2 KB)

I want to do 2 things
1/ split the full name : sometimes name is 2 words
2/ I want to create a column by data in the row. Example :
1 65,05 00:11.67 00:37.93 4 00:53.36 4 => Colum 1 = 1 Column 2 = 65.05 Column 3 = 11.67 ECT…
Thanks for your help
Br

[Brain]

Cell splitter is a good solution.
My only problem now is to keep all the name when there are spaces in the name.

[thor_landstrom]

Hello @Brain,

If I am understanding, you want to take one row and split it into its respective column so that say column 1 will have 1,2,3,4… and column 2 will have 65.05,65.70,… and so on.

So looking at the workflow, I think you first need to extract any of names (which is i assume what you are asking for in step 1) first before you try to split them into columns so we can use regex to extract any words, then split them later:

Then we can use cell splitter on the spaces for your step 2:

Here is the updated workflow with my additions:
Extract data from PDF TRACKING.knwf (143.7 KB)

Hope this helps,
TL

[Brain]

Many thanks
Regex is to difficult for me
Br