managing a .csv file exported from a website

Hi everyone, 

I have to translate a .CVS file exported from a website (i asked for other formats and the owener told me that is not possible for them), below an example of the file:

31,377,it,NASTRO MONOADESIVO RIFLETTENTE PER INTERNO,"**ALU BAND** è il nastro **monoadesivo acrilico** sviluppato specificamente per la **sigillatura ermetica di barriere vapore alluminizzate**, come le membrane della serie **BARRIER ALU**.

How can I manage the ** and special symbol? the same for the number at the beggining?

I Attached a screen with more context.

Thanks in advance

Screenshot of a .CSV file opened in a spreadsheet program showing a row with product description in Italian, including special characters and asterisks.



Generated Image Alt-Text
[edited by: Trados AI at 12:55 AM (GMT 0) on 29 Feb 2024]
emoji
Parents
  • Thanks for screenshot... although you seem to handling this as an Excel file as opposed to CSV.  At least this is what it looks like since you have everything in one column.  Is this how it's supposed to be handled, so not like this... or something like this?

    Screenshot of a CSV file incorrectly opened in Excel with all data in one column, causing formatting issues.

    It seems to me you may be corrupting the intended formatting of this file because of the way you are looking at it and this is making it difficult for you to understand how it should be handled.  Excel could also be responsible for corrupting some of the characters due to encoding issues and this could be the cause of your "special chars" problem.

    Can you open the CSV you were sent, before you open it in Excel and mess it up, in a decent text editor and then add a BOM (byte order mark... a good text editor can do this, something like Notepad++ or EditPad).  Then import the CSV into Excel as opposed to opening it in Excel.  Select the comma as the delimiter and then you'll be able to see what it should look like.

    Then you'll also be able to see how best to handle it... if you get it Excel ready you can probably handle it easily with the Excel filetype in Studio, just adding a couple of embedded content rules for the ** symbols.  The numbers will be on segments of their own and so easy to handle.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 12:55 AM (GMT 0) on 29 Feb 2024]
  •   Is this how it's supposed to be handled, so not like this... or something like this?

    Screenshot of an Excel file showing a table with columns labeled 'id', 'title', 'type', 'description', 'meta_description', 'video', and 'body'. The 'description' column contains HTML tags and Italian text.

    this is the CSV source file and as this the target file should be.

    I sent you the CSV file like this and the excel file after conversion like this

    is is your source file... at least this is the one you gave me:

    Screenshot of Trados Studio software with a warning message indicating a file type definition problem. The message suggests that the CSV file format is not supported or not properly defined.

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 12:56 AM (GMT 0) on 29 Feb 2024]
  • The CSV you sent me was exactly as I showed in that screenshot.  the excel you sent me is this... more than three lines!

    Screenshot of a CSV file opened in Trados Studio with multiple lines of data exceeding three lines, indicating a discrepancy from the expected format.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 12:56 AM (GMT 0) on 29 Feb 2024]
  • I think you need to have a proper discussion with your client about their requirements.  This looks as though they have done some sort of unnecessary extraction and it's a mess.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

  • this was the source file I sent you in the folder and opened like this

    Screenshot of Trados Studio source file in a folder with multiple files, highlighted to show selection.

    after the conversion to excel, as you explained me, it was transformed in more that 3 lines

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 12:56 AM (GMT 0) on 29 Feb 2024]
  • I can assure you that the file you sent me does not look like that.  See this video below. If you can send me the one source file that looks like the one you have on three lines I'd still be happy to take a look.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

Reply
  • I can assure you that the file you sent me does not look like that.  See this video below. If you can send me the one source file that looks like the one you have on three lines I'd still be happy to take a look.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

Children