How to deal with this file?

Hello there,

My apologies for asking the following questions which might sound silly to all knowledgeable people.

We received a file like the one attached in order to update our TMs. 

2 issues: 1 a lof of tags

2 the next file we are receiving will contain yet other tags.

What is the best way to proceed? To eliminate the tags from the Excel file and create a tag-free TM?

 In this case how can we handle the following text which will contain tags as well?6355.test file.xlsx

Or shall we use REGEXx (which I have never used, but hey there is always a first time)?

I hope it is clear. We use SDL 2017.

Thanks in advance for your help.

Debora

emoji
Parents
  • It looks like Excel with HTML inside. You can use the Excel Bilingual file type and define all the tags within the file type. It is not so much work as it seems, but then you will have a perfectly filled TM.

    Most probably the even better way will be saving the Excel as XML and using the brand new Multilingual XML file type. Unfortunately I did not yet manage to learn it, but I'm certain can explain more.

    _________________________________________________________

    When asking for help here, please be as accurate as possible. Please always remember to give the exact version of product used and all possible error messages received. The better you describe your problem, the better help you will get.

    Want to learn more about Trados Studio? Visit the Community Hub. Have a good idea to make Trados Studio better? Publish it here.

    emoji
Reply
  • It looks like Excel with HTML inside. You can use the Excel Bilingual file type and define all the tags within the file type. It is not so much work as it seems, but then you will have a perfectly filled TM.

    Most probably the even better way will be saving the Excel as XML and using the brand new Multilingual XML file type. Unfortunately I did not yet manage to learn it, but I'm certain can explain more.

    _________________________________________________________

    When asking for help here, please be as accurate as possible. Please always remember to give the exact version of product used and all possible error messages received. The better you describe your problem, the better help you will get.

    Want to learn more about Trados Studio? Visit the Community Hub. Have a good idea to make Trados Studio better? Publish it here.

    emoji
Children