topic Re: Text from Word to be split into collection in Product Forum

Text from Word to be split into collection

LorenzoCapocci1 — Wed, 07 Jul 2021 18:49:43 GMT

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

Re: Text from Word to be split into collection

EmersonF — Wed, 07 Jul 2021 20:15:53 GMT

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

Re: Text from Word to be split into collection

LorenzoCapocci1 — Mon, 12 Jul 2021 23:49:40 GMT

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

Re: Text from Word to be split into collection

EmersonF — Tue, 13 Jul 2021 12:19:26 GMT

I'm happy to help you, my friend