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]
Reply
  • 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]
Children