Text from Word to be split into collection

[LorenzoCapocci1]

Hi Folks,
once more I need your help..

I need to move data from Word document to Collection or Excel,
I have checked different objects but I am not sure how to get each row in separate rows in excel or collection as per example in the document...
I have tried with the String option, but some rows may not contain the relative number and this would cause only confusion...
do you have any advise on this?
Thank you

[EmersonF]

​@LorenzoCapocci1 , you can copy this value

1981 offering name 0000-PID GA 2019
2062 Order Error- Withdrawn (JPN)
2278 Mood Marbles
​

​to the clipboard and use a split text to make it look like this:

1981 offering name 0000-PID GA 2019
__________________________________
2062 Order Error- Withdrawn (JPN)
__________________________________
2278 Mood Marbles
__________________________________


​

Then you use action append field(text) and add the column "Number"

Run a loop over this collection with a multcalc in the middle with the following expressions:
Left([Coll.Title]; 4) saving to Coll.Number and the second expression is the Replace([Coll.Title];Left([Coll.Title]; 4);"") to remove the first few characters from the string and that should solve your problem.

[LorenzoCapocci1]

Thank you once again @EmersonF this is really helpfull...​

[EmersonF]

I'm happy to help you, my friend