Hi Marius,

In addition to the suggestion type definition file sent by Paul, I have copied your text and I have created a plain text file, assuming that the file you are working on is a plain text file (*.txt).

If your file has a different extension, but if actually it is a text file, just create a copy of your original file and add to it a second extension “.txt” (e.g. TEXT.[your extension].txt) and open/check it in a simple text editor (say Notepad or Notepad++; I suggest to avoid MS Word, when possible).

As you want to extract just text between starting ' and closing ', ignoring all other text of the pertinent string, before loading the file to create your project, you should define the Project Options “Options > File Type > Text > Document structure” window inserting a ' in “Opening pattern” field and a ' in the “Closing pattern” field, check the “Multiline” if required, and click on “Add” to obtain:

Now click on the existing default pattern (opening pattern ^ and closing pattern $) to select it and click on “Delete” to discard this rule and maintaining just your ' and ' opening and closing patterns.

At this point, to preview the result of this setting, click on “Browse” and select the file with double extension (*.[your extension].txt) and then on “Preview” and you should obtain:

that is what you needed. Am I right?

Now go on loading your file in SDL Studio as usual and complete the Project routine and start translating your file that should appear as follows in the Editor view:

When completed the translation, save the target final file as usual (SHIFT + F12), go to the folder containing your translated (double extension) file and delete from it the second added extension (.txt) to obtain a final translated file *.[your extension].

I hope this may help you.

Claudio

ADDENDUM: To avoid problems regarding the presence of possible internal presence of ' inside the text to extract/translate, the above opening/closing patterns may be, respectively. =\s' and ';$.

Dear Claudio,

I am so happy to find this answer too.

But I also have a similar problem. I have a tab delimited (.txt) document and the text is separated by tab, not by (') and (') as the example above. How to process it? Example:

40    350    1    <korean characters>    This text should be translated1    <another character>

41    351    1    <korean characters>    This text should be translated2    <another character>

42    352    1    <korean characters>    This text should be translated3    <another character>

How to translate the yellow parts only? What "character" to be used as the opening and closing pattern? The file was OK on Excel, and I wish it is an Excel file or <.csv> file. But unfortunately, the text is in <.txt> format.

Thank you.

Sarah

Hi Sarah - 

Perhaps the easiest solution is to just import the txt into excel then just hide the columns you don't want? If it's tab delimited as you suggest then they should nicely split like this:

Save the file as excel and then just hide columns A, B, C, D and F.  When you're done translating just save the target file, open in Excel and save as a TXT again.

Regards

Paul