export attribute values included in sdlxliff files

Hello,

I have Trados Studio 2022 SR2 - 17.2.12.19268 and I would like to extract some pieces of information from an sdlxliff file which are nonetheless just visibile when opening that file in a plain editor, such as Notepad++: They are not visible in Trados but I can see them when reading that sdlxliff as an XML file in an editing app.

In particular, I would like to have an overview of all entries for, say, attribute "origin-system=", in order to know which translation memory were actually used to translate the sdlxliff file at stake.

I have tried to import such an sdlxliff file into Excel but with no success.

To sum up, I would like to have all sdlxliff file values related to attribute, say,  ""origin-system=" listed in one single spreadsheet or list.

emoji
Parents
  • Probability score: 0.6  

    Question improvement suggestion: Provide specific examples of the attribute values you want to extract and clarify if you have tried any specific methods or tools for extraction.  

    In the meantime, based on the information you have provided, here is a suggested answer to your question:  

    Hello,  

    To extract attribute values like "origin-system=" from an SDLXLIFF file, you can follow these steps:

    **Step 1:** Open the SDLXLIFF file in a text editor that supports XML, such as Notepad++. This will allow you to view the raw XML structure of the file.

    **Step 2:** Use the search function to locate the specific attribute you are interested in, such as `origin-system`. You can search for `origin-system=` to find all occurrences.

    **Step 3:** If you want to compile these values into a single list or spreadsheet, you can copy the relevant lines containing the attribute values.

    **Step 4:** Paste the copied values into a spreadsheet application like Excel. You may need to clean up the data to ensure it is in a usable format.

    **Step 5:** If you are comfortable with scripting, consider writing a small script in Python or another language to automate the extraction process. This can be particularly useful if you have multiple files or need to perform this task regularly.

    **Step 6:** If you encounter issues with importing the SDLXLIFF file into Excel, ensure that the file is not corrupted and that you are using the correct import settings.

    By following these steps, you should be able to extract the desired attribute values from your SDLXLIFF file. If you have any further questions or need additional assistance, feel free to ask!  

    I hope this answer addressed your question. If not, please reject the answer, add the question improvement suggestion information, and click the RWS Community AI checkbox on the right to try again.  

    RWS Community AI

    emoji
Reply
  • Probability score: 0.6  

    Question improvement suggestion: Provide specific examples of the attribute values you want to extract and clarify if you have tried any specific methods or tools for extraction.  

    In the meantime, based on the information you have provided, here is a suggested answer to your question:  

    Hello,  

    To extract attribute values like "origin-system=" from an SDLXLIFF file, you can follow these steps:

    **Step 1:** Open the SDLXLIFF file in a text editor that supports XML, such as Notepad++. This will allow you to view the raw XML structure of the file.

    **Step 2:** Use the search function to locate the specific attribute you are interested in, such as `origin-system`. You can search for `origin-system=` to find all occurrences.

    **Step 3:** If you want to compile these values into a single list or spreadsheet, you can copy the relevant lines containing the attribute values.

    **Step 4:** Paste the copied values into a spreadsheet application like Excel. You may need to clean up the data to ensure it is in a usable format.

    **Step 5:** If you are comfortable with scripting, consider writing a small script in Python or another language to automate the extraction process. This can be particularly useful if you have multiple files or need to perform this task regularly.

    **Step 6:** If you encounter issues with importing the SDLXLIFF file into Excel, ensure that the file is not corrupted and that you are using the correct import settings.

    By following these steps, you should be able to extract the desired attribute values from your SDLXLIFF file. If you have any further questions or need additional assistance, feel free to ask!  

    I hope this answer addressed your question. If not, please reject the answer, add the question improvement suggestion information, and click the RWS Community AI checkbox on the right to try again.  

    RWS Community AI

    emoji
Children
No Data