CSV file a WordPress export problem when setting up for a translation

Question

I have a problem with working my way around starting a translation of a CSV 2.0.0.0 file (Wordpress export). 
 Excell shows me 12k lines of code + text and SDL Trados Studio 2017 SR1 seems to only be able to get some 1000 words. 
 In editor mode I get both source and target full of text with source consisting only of numbers of lines and target consisting of some of the code+text 
 Please advise how to proceed with this one.

PS I should mention that had also problems with XLIFF exports .

Paul · Answer

In fact the default does a fairly good job, but you'd probably want to create your own rules to get the segmentation better organised:

Paul · Answer

Hi Martin Čáp , 
 
Apologies, you sounded as though you were more more familiar with Studio. This is a feature of the filetype which you can enable so that it uses regular expression rules to protect text with tags. In this case the code you don't wish to translate. The screenshot I showed used the defaults, so all I did was enable it before creating my project, but you sould create more specific rules to be smarter than this and actually create proper tag pairs, and show formatting etc. all of which makes it easier for the translator. 
 
This article might help you: 
 
 multifarious.filkin.com/.../

Paul · Answer

Hi Martin Čáp 
 Many apologies for not getting back to you on this one... I thought it might be better to create a video for you and explain a few different ways to handle your file. It ran on longer than I intended as I thought I'd extend the recording a bit to show you how to create a custom XML filetype as well with a crazy CDATA hack for your file.

Trados Studio > 1. Trados Studio

CSV file a WordPress export problem when setting up for a translation