sample file ?

hi Kelly,

attached is theQuantity Survey GTC Carrefour 18 Nov 2020.xls one

"Macro" is.. quite complex one (I prefer the term "dirty one" though..)

Your'd better improve your code a little bit more, before you use it in real world.

I got this one from your code, it is.. dangerous in some cases.

So, I prefer to stand behind RWS dev team.
Should you handle ".sdlxliff" stuffs, things getting easier than this Macro and the result will be better.

Good Luck To You.

and in RWS project.. Your code is still "formatted awkwardly"

It should have done like this "formatted naturally"

OR like this..

This is a real world "Macro"...

Try it out.
I guess, it will take several days for you to write this kind of low level completness.

That's is why, I recommend you to pay me USD 50.-
That's quite fare Price.

Regards 

Kelly Edward said:

I guess, it will take several days for you to write this kind of low level completness.

That's is why, I recommend you to pay me USD 50.-

Hahaha Nice joke

I did not make any joke with You.

Kelly Edward

Just a question because you said this earlier:

Kelly Edward said:

Finally, I do not like the idea to change Original text.

When you save the target file after running your tool is the content split back into the different rows it was originally written into?  So does this:

Get saved back as this?

exactly

detailed steps

Ah, I just understand what is your point of question.

I have three tools in a single group. Like this.

Tip: shows "Complete sentence projection" suggestion automatically - indicates How many segs you have to merge using HighlightColors.
Merge: after you drag several segs, you click this one then it gives you combined single seg. Now ready to translation.
Split: after you finish translation, click it then it splits active seg into several little ones on the basis of "Locked status(and empty)" underneath it.

So, you are wondering the role of 3rd "Split" tool. Right ?
- it divids a long sentence into several shorter ones and distributes them Evenly & AutomatiKelly.

Ah, I just understand what is your point of question.

I have three tools in a single group. Like this.

Tip: shows "Complete sentence projection" suggestion automatically - indicates How many segs you have to merge using HighlightColors.
Merge: after you drag several segs, you click this one then it gives you combined single seg. Now ready to translation.
Split: after you finish translation, click it then it splits active seg into several little ones on the basis of "Locked status(and empty)" underneath it.

So, you are wondering the role of 3rd "Split" tool. Right ?
- it divids a long sentence into several shorter ones and distributes them Evenly & AutomatiKelly.

Kelly Edward

That's pretty nice.  So with something like this:

You'd be able to split back into the correct cells?  I put the file here for you in case you wanted to use it:

mergensplit.xlsx

not much..

Because, this is Toooo Easy
this is not a real World, real world is much dirtier than this one. 

I have done this testing with ALL AutomatiKelly (I have made "batch" version of it, too)

.

hmmm..

in some cases "Even" is not the best, I guess.
"Even" could be looked silly. (reminds "Seven Dwarfs")

"Evenly" with the big picture, this should be the better answer, I guess. 
-or "Align" with the longest possible, or something ("Six Ordinaries and an extreme dwarf")..

OR not.. ("Per original ratio")..? sucks..

Can you show me again your style to solve this RWS (Real World Scenario) problem ?

It is your file but modifed a little bit.
mergensplit BACK_To_PAUL.zip

Regards

Kelly Edward

I actually like your solution to this problem.  It's clever and will return the file in the same format.  It is a little bit different to the source, but I don't think this matters at all.  I'd be interested to see how that would look if the text was translated... especially into something like Chinese for example where there are no spaces between the words?

Kelly Edward said:

Can you show me again your style to solve this RWS (Real World Scenario) problem ?

I wouldn't call it my style.  It was a suggestion.  I know full well what the Bill of Quantities will be used for in practice and in these circumstances I don't think it matters that the source is reformatted to merge the text.  Only the description is merged and the quantity, units, rate and amount will all be aligned correctly.  So for this particular problem I would change the source.  Particularly in a multilingual project because then I only need to do this once.

But it might not always be appropriate if you have files like this.  So would I develop a plugin to solve this problem?  Probably not since the solution I would use here is less money and offers a lot more features for other things.

But for other usecases your solution might be more appropriate.  An interesting discussion and the tool you created is certainly innovative so I am not pushing one or the other.