Unexpected behaviour of CSV file type in Trados Studio 2024

Question

Hi RWS team, 
 I am using the CSV filetype in Studio 2024 to translate a comma-seperated file exported by Premiere Pro. When I select the checkbox "Exclude: First line is column headings" in the "Format" tab ot the filetype settings, I can't p&uuml;review the file anymore. I get a warning saying "Cannot find file type setting for the preview file". When I deselect that option, I can preview the file as expected. Is this intended bahaviour or a bug? 
 Here is a screenshot of my file: 
 
 Thanks, Daniel

RWS Community AI · Accepted Answer

Hello Daniel, 
 I understand you're having trouble with the CSV file type in Trados Studio 2024. The issue you're experiencing seems unusual. When you select the "Exclude: First line is column headings" option, it should not affect your ability to preview the file. 
 Here are a few steps you can try to resolve this issue: 
 Step 1: Ensure that your Trados Studio 2024 is up to date. You can check for updates within the application. 
 Step 2: Try resetting your CSV file type settings to default and then reapply your desired settings. 
 Step 3: If the issue persists, you might want to try reinstalling Trados Studio 2024. 
 If none of these steps resolve your issue, it might be a bug. In that case, you should report it to the RWS Support Team through the Gateway. They will be able to investigate further and provide a solution. 
 Please note that the ability to preview certain file types, like HTML, requires an additional benefit to be added to your account. If you're having trouble previewing other file types, you might need to request this additional benefit. 
 I hope this helps! If you have any other questions, feel free to ask. 
 Best regards, 
 RWS Community AI

Paul · Answer

Daniel Hug 
 I had a go with a sample file I made up and don't have this problem (see video). But perhaps you can: 
 
 provide a sample file? 
 check if you're doing this in a project template (maybe it's an old one?) 
 
 To be honest I don't know why this is causing a problem, but I think we&rsquo;d need more info to validate it:

Paul · Answer

Daniel Hug 
 Thank you. I actually cannot preview the file at all, with or without the exclude button checked. I believe the problem is that your file has control characters in it that break the format of the file. I see you're using EPP so if you "Visualize line breaks" you'll see this: 
 
 I tried to reproduce your file staying consistent with the controls and this actually worked. You can test this here - Sample_orig_fix_4.zip 
 I zipped it to try and avoid any problems in transit. If you use a compare tool it gets a little more clear: 
 
 The file on the left (Sample_orig.csv - your file) has control characters visible as OD (Carriage Return ) and OA (Line Feed 
). These are typical end-of-line characters in text files. The presence of OD and OA indicates that the multiline text fields contain explicit new line characters, which may cause issues. 
 The file on the right (Sample_orig_fix_4.csv) that I edited has these control characters handled differently in that I tried to take a consistent approach with the OA following OD which is a Windows-style line break (
). 
 I'm going to guess that the file originated in a MAC or maybe a Linux system and somehow handling the file in a different environment along its life has broken it. Or maybe it was just created this odd way. 
 Anyway... I'm not sure whether this is a bug or the result of a file problem that only an editor dedicated to working with CSV files could be expected to avoid. What do you think?

Trados Studio > 1. Trados Studio

Unexpected behaviour of CSV file type in Trados Studio 2024