The problem is the source excel file is formatted awkwardly. The sentences are divided among consecutive cells of columns.
The Studio shows the sentences also in split segments. First, we tried to merge segments in Studio, but I understood that the target file would be formatted differently than the source file.
What would be the way for me to tackle such an excel file?
thanks
nika
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.
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:
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
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
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?
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.
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Thanks, Paul.
Thanks, Kelly again. We have 50% done of the excel in Studio, preliminarily having merged the segments and at the end we shall do format cell wrap text. I shall follow your advice on excels like this in the future.
Thanks, Stepan for the advise of Macro.
Translate
