Creating a TM from a Single Bilingual File

Question

Hi all! I'm new here. So stupid question time! 
 I need to translate a massive file. But I'm in luck! It's version 2.0, and I have the following: a txt file for the 1.5 ST, a txt file for the 1.5 TT, and an bilingual HTML file that has the entire thing with the English on top and Japanese right underneath. 
 I tried to align the TXT files, but it's... just too big. It's around 20,000 segments, things go off in the middle, several parts aren't parsing right... it would take me two weeks to align it manually. 
 But wait, I already have an "aligned" version! The bilingual HTML file! It's already separated line by line. Is there any way to leverage this into a TM? I found a question like this in the archives, but it was around five years old and the answer seemed to be a big "nope". I've got my fingers crossed that there's a workaround here... otherwise I will just end up having to CTRL+F every single line of this huge thing from scratch.

Kelly Edward · Answer

Benjamin Listen 
 ..for instance 
 Step 1. use Regular expressions to extract what you wanted 
 Step 2. Import into TM

Paul · Answer

Benjamin Listen 
 Please note that you are not missing anything and it's not surprising you'll be confused with the "instructions" from Kelly. He doesn't do instructions, he just likes to show off how he was able to do something but doesn't explain anything. 
 He essentially did this: 
 
 extracted the source and target text for each language using regular expressions 
 put this extracted text into a delimited file and converted that into a TMX file (or some process like this) 
 from there you can either import the TMX into a new Trados translation memory, or convert it directly (the Glossary Converter on the appstore can do this for you... but importing is easy enough with out of the box features) 
 He also shows a UI for Studio full of all his little tools as he does know how to develop a little, so it won't look familiar to you and he hasn't explained any of that 
 
 So your task would be to learn the following: 
 
 how to use regular expressions to identify the translatable text from your file 
 how to use that expression in a tool (like Notepad++) so it's copied to a new file in a structured way 
 
 I said "new file" because it doesn't have to be a TMX 
 You could simply separate the results of your regular expressions by a tab and then use the Glossary Converter to convert the tab delimited file directly to an SDLTM (translation memory)

Kelly has essentially forgotten that everyone has to start somewhere and I can still remember the sort of questions we used to get from him... and if other users had been like Kelly today he would have learned nothing! This is nothing to do with a free lunch as he hasn't even given you a biscuit! I think it's fine to offer to do work for someone at a price as everyone's time is valuable. So if you do have technical skills that go above those of the average user then contact them off forum through the chat and agree a price for the work. But don't keep posting like this. It's rude, grandiose and frankly unhelpful. 
 We do have a forum here for regular expressions: 
 https://community.rws.com/product-groups/trados-portfolio/trados-studio/f/regex_and_xpath 
 You can feel safe having a go, sharing examples of what you are trying to achieve and getting some help along the way. The example reference from Daniel is a good one and there are also some good tools out there that help to use regular expressions with explanation... some free and some at a cost. So use the forum and ask as you go. Once you get your head around them you'll never go back... they are very useful!

Paul · Answer

Benjamin Listen 
 Can you provide a small sample of the html file? Just the header of the file and a couple of lines showing how the source and target is laid out in the file. I'm imagining a workaround using the Multilingual XML filetype from the appstore but if your file is html it'll be helpful to see what this looks like so we can suggest a small change to support it being processed by this filetype. 
 https://appstore.sdl.com/language/app/multilingual-xml-filetype/1261/ 
 Another possibility would be to use a different solution to align your txt files. So it would also be interesting to see a small sample of what this txt file looks like. Just because it's txt doesn't necessarily mean it only contains the text. If it does then using something like LF Aligner could be useful as this is light and pretty good with txt files. 
 https://sourceforge.net/projects/aligner/

Paul · Answer

Benjamin Listen A small snippet of the file would have been more helpful. You said it was an HTML file but this looks like something that has been copy pasted out of a word file, or something you just made up? If you insert it as code in here: Then we can do something with it. On the basis of this bit:

0. はじめに

Introduction

1. ゲームの考え方

1. Game Concepts

100. 原則

100. General

101. マジックの黄金律

I'd say it might be possible. But I can't give a confident answer without seeing how this file is structured from start to finish (but only containing your small sample of the translatable parts). Like this perhaps?