Hi

Use the QA checker in your project.

In the category Segments verification activate "Longer by (%)" beneath "Check for target segments which are:" and set the value to 0, then lower the "Ignore..." to 1 and leave "Based on characters" selected.

That does exactly what you need

Regards, Jerzy

Hello Jerzy, thank you so much for your prompt reply.

Unfortunately, the client chooses a specific character limitation per excel cell (: cell A1 : max 140 characters, cell 12 : max 150 characters...etc) Which means that each segment also has a specific limitation... :(

In such case I am afraid Studio has not (maybe yet) an easy solution. However, if the number is placed beside the corresponding cell, you could add a symbol in front of a number (via macro in Excel or Word) to make this an alphanumeric value and this be included in the file for translation. Then this value would appear beneath the segment in Studio.

From what I know Passolo should have such an option as you're looking for, but unfortunately this is all my knowledge.

Unfortunately Studio does not yet support this, so you need a workaround for the moment. Another one to what I described above would be using the QA-checker to try to keep the translation in a similar length to the source (maybe giving 10% as a limit - fist check how far the source does fit the limit) and then checking in Excel for the given limits (you can count the number of characters in the cell with quite a simple function in Excel, so it should be not a big problem to combine this with the customers limit).

I have been told, that some changes shall appear in the file types in the future, so there is hope such a function will be implemented.

Kind regards, Jerzy

In such case I am afraid Studio has not (maybe yet) an easy solution. However, if the number is placed beside the corresponding cell, you could add a symbol in front of a number (via macro in Excel or Word) to make this an alphanumeric value and this be included in the file for translation. Then this value would appear beneath the segment in Studio.

From what I know Passolo should have such an option as you're looking for, but unfortunately this is all my knowledge.

Unfortunately Studio does not yet support this, so you need a workaround for the moment. Another one to what I described above would be using the QA-checker to try to keep the translation in a similar length to the source (maybe giving 10% as a limit - fist check how far the source does fit the limit) and then checking in Excel for the given limits (you can count the number of characters in the cell with quite a simple function in Excel, so it should be not a big problem to combine this with the customers limit).

I have been told, that some changes shall appear in the file types in the future, so there is hope such a function will be implemented.

Kind regards, Jerzy

Oh, one trick more, maybe helpful for the time being.

Sort the table according to the length limit. This way you will get cells, which may have less characters first,  followed by cells with more characters and so on. But the lines will be grouped by the number of allowed characters. Now you can simply copy the parts with a certain limit to a new Excel, call the file as the other one plus "limit nnnn" and then apply the fixed limit from the QA-checker in Studio (part "Length verification").

It seems maybe a lot of work, but it must not necessarily be so much work. If your customer did define hundreds of limits, this will not be feasible, but for some ten limits or so that could be the easiest way to deal with this problem.

Unknown said:

I have been told, that some changes shall appear in the file types in the future, so there is hope such a function will be implemented.

Thanks Jerzy... just to add to this I can tell you that the development team are working on a new Excel filetype with quite a lot of additional functionality.  I can't give you any kind of timelines yet, but I'll make sure this requirement is brought to their attention.