B. Rieger 

Tricky with bilingual files for two reasons:

1. the out of the box bilingual Excel will not segment at all within a cell when there is content in both the source and target already (this is deliberate)
2. the Multilingual Excel filetype should be able to handle it, although it will only segment the source, and you would have to manually address the target because the entire cell will be placed into the first target segment of the segmented source (also deliberate)

The deliberate reasons are that Studio only segments on the source anyway so doesn't know what to do with the target.  The bilingual Excel filetype says... in this case I'll never even try to segment where possible if the target is populated... the Multilingual Excel does away with that restriction but still doesn't know what to do with the target.so segments the source and not the target.

There is a third problem in case you think the Multilingual Excel is the way to go... and that is its buggy and throws an error when you try! Oana Nagy FYI.

So, I reckon the best approach might be to use the monolingual Excel filetype and align two Excel files.

You could create these rules on the Excel filetype for example and make sure they are all set to Exclude:

\s\|\s

\(\w+\)

(?<=\s)\w\)(?=\s)

\d+\.(?=\s)

Like this:

Then make sure you separate the bilingual file into two monolingual files and the alignment gets you this:

I started with the pipes as this seems a better place to segment than the semicolons.  That way I can then remove the (a), the a) and even the 4. ... for example... leaving behind only the phrases and sentences to be aligned for your TM.

Obviously this is untested on a full file where I don't know what else is in there, but perhaps it's an approach worth trying if you want a TM from these files?

Hello Paul,

Thank you so much for your quick response. I truly appreciate the detailed explanation and insights you provided about the different approaches. I'll definitely try aligning the Excel files.

One more question: Could you please guide me on how to create the segmentation rule with a pipe? I attempted something, but it didn't seem to work. Here's what I have so far:

Thank you once again for your help!

Best regards,

B. Rieger 

It won't help you with a bilingual Excel file for the reasons I already explained.  Try copying your text into a monolingual Excel, or a text file, and then test your segmentation rule.  I think you'll have more success that way.

Hi Paul,

Thank you for the suggestion regarding aligning the monolingual files. I gave it a try, but unfortunately, I did not get the same results as shown in your screenshots. Specifically, for example "| (a) |" can still be seen:

I suspect this might be because the segmentation does not start with the pipe symbol. As you mentioned in your previous comment, you "started with the pipes"—could you please clarify how I should configure the segmentation rule in the translation memory to achieve the same results you described?

This is important because the translation memory will be used to translate the points a, b, and c separately.

For your reference, I’ve also attached the monolingual files in case that helps to provide more insights.

Thanks a lot for looking into this!

Chengle

EN_1.xlsx

DE_1.xlsx

Hi Paul,

Thank you for the suggestion regarding aligning the monolingual files. I gave it a try, but unfortunately, I did not get the same results as shown in your screenshots. Specifically, for example "| (a) |" can still be seen:

I suspect this might be because the segmentation does not start with the pipe symbol. As you mentioned in your previous comment, you "started with the pipes"—could you please clarify how I should configure the segmentation rule in the translation memory to achieve the same results you described?

This is important because the translation memory will be used to translate the points a, b, and c separately.

For your reference, I’ve also attached the monolingual files in case that helps to provide more insights.

Thanks a lot for looking into this!

Chengle

EN_1.xlsx

DE_1.xlsx

B. Rieger 

As I explained, and showed, I didn't use segmentation rules at all.  I used filetype rules... it's easier!

Hello Paul ,

I did use the file type rules as you suggested and aligned two monolingual files.

However, the results are different from what you achieved (points a, b, and c are not treated as separate segments).

Your result:

My current result:

Could you please let me know what could be wrong with my filetype rules settings?

Thank you,

Chengle

 B. Rieger 

Maybe you didn't set them to exclude?  Select the rule, edit, then click on Advanced and set the segmentation rule to Exclude.  If you don't do that they will most likely be inline... which is what you're showing.

I suggest you test them in the filetype settings before you go to the lengths of aligning.  If they don't segment in the filetype settings they won't segment anywhere else :-)

Hi Paul,

“Excluding” the rules was actually the problem. Missing one bit of knowledge can lead to getting everything wrong.

Thanks a lot for your patience and great help. You really saved my day(s)!

Best regards,

Chengle