Import documents with embedded HTML content

This is how the XML file looks like:

1.Create an empty local project: after specifying the project name and the language pair in the New memoQ project wizard, click Finish.

2.In the Translations pane of Project home, click Import with options... In the Open dialog box, specify your XML file.

3.The Document import settings dialog appears. The XML file in the example can be imported with default settings (memoQ will automatically detect and import CDATA content). However if your XML document is more complicated, you might want to tweak the settings in the XML settings dialog.

1.At the top of the Document import settings dialog, click Add cascading filter. In the Add cascading filter dialog, choose the Regex tagger:
 

2.Click OK. The Document import settings dialog now displays the options for the Regex tagger:
 

3.Add three rules to this dialog. First, we add a rule to replace opening XML tags that look like this: <tag_text>. Fill in the Regular expression, Tag type, and Display text fields as follows, and then click Add after each rule:

Regular expression: <[^/]*?>

We need to find the shortest possible character sequences that start with <, end with >, and have no forward slashes inside. The [^/] pattern matches any character  but the forward slashes, and the *? pattern tells memoQ that we need this repeated, but we need as few as possible. This way memoQ will stop matching at the first > character.

Note: If we used the more standard * character to look for repetitions instead of *?, memoQ would look for the longest possible match, and stop matching at the last > character in the text, possibly incorporating multiple XML tags and a good deal of text as well.

Tag type: Open

Display text: $0

This will copy the tag text into the inline tag that memoQ displays.

4.Next, we need to replace closing tags that look like this: </tag_text>:

Regular expression: </[^/]*?>

This is very similar to the previous one, but we look for character sequences that start with </ instead of <. Inside the tag text, we still prohibit forward slashes.

Tag type: Close

Display text: $0

5.Third and last, we need to cover empty tags that look like this: <tag_text/>

Regular expression: <[^/]*?/>

Tag type: Empty

Display text: $0
 

When the rules are set up, the Document import settings dialog should look like this:

After you set up the regular expression rules in the Document import settings dialog, it is strongly recommended to save them in a filter configuration.

1.Click the Save icon next to the Filter configuration drop-down box.

2.The Create new filter configuration dialog appears. Type a name for the new filter configuration, and click OK:
 

3.The Document import settings dialog returns. Click OK to import the XML file.

4.The Translations pane of Project home returns. Double-click the name of the document to open it in the translation editor. The example looks like this:
 

In the second example, we import an Excel workbook that looks like this:

1.On the Documents ribbon tab, choose Import > Import with options. In the Open dialog, select your Excel workbook.

2.The Document import settings dialog appears. As far as the Excel filter is concerned, we'll import the Excel file with default settings.

3.Click Add cascading filter.... In the Add cascading filter dialog, select the Regex tagger in the Filter drop-down box. In the Filter configuration drop-down box, select the filter configuration that you saved in Step 3:
 

4.Click OK to return to the Document import settings dialog.

5.Check if the rules were loaded. If you see the same as at the end of Step 2, click OK to import the document.

6.Open the imported document from the Translations pane of Project home. This is how it will look like: