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 Reply
  • I tested the excel file based on the sample csv you provided.  This looks fine to me:

    PF_test.zip

    I can't comment on the Excel files you sent me as they are different to the example CSV you sent me.  Certainly they seem to be in the format I was getting before I changed my regional settings so perhaps you have a problem with the conversion to Excel and so started off wrong?

    Another problem I can see is that I have no idea how to get the Excel file back into the CSV format you need.  I think that if your customer can't get you proper source files (html or xml as opposed to a CSV export that looks like this) then your best bet is to work on Excel and leave it to your customer to get the files back into his system.

    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