question about file language and it's coding.

108914
108914 Newcomer
in Screening

we download the premium-world-check-day.csv file and find some character can not show correctly, Ex:UID=267447,name=GORAN Mugosa, one the aliases=MUGO¦A,Goran; but it should be Mugoša,Goran. could you tell us how to fix this issue?

Tagged:

Best Answer

  • Prabhjyot
    Prabhjyot LSEG
    Answer ✓

    @108914

    Thank you for you query.

    ISO 8859-15 character set is used by datafile except the native aliases, which uses UTF-8 encoding.

    If you process the file in ANSI you get '|' these characters. To process the file correctly, you will have to use ISO 8859-15. Please refer to this link for more information.

    Please raise you further queries via MyRefinitiv support channel.

Answers

  • Irfan.Khan
    Irfan.Khan LSEG

    @108914 From where do you download the premium-world-check-day.csv file?

  • 108914
    108914 Newcomer

    I use WINSCP.exe by sftp to download the csv file. the native file do not have this coding issue by default on notepad.exe, but the premium-world-check-day.csv file have this issue by default on notepad.exe, why is that the native file is in UTF-8 by default but the premium-world-check-day.csv file is in ANSI by default?

    So I need to convert the premium-world-check-day.csv file's coding to ISO 8859-15 manually?

  • Irfan.Khan
    Irfan.Khan LSEG

    @108914 The issue you are facing is related to World Check Data File and not the WC1 API.

    As this is a WC1 API specific Q&A, this question cannot be answered on this portal.


    Please raise your questions via MyRefinitiv support channel. Here is the link to raise a support ticket. They will help you out with your query.

    https://my.refinitiv.com/content/mytr/en/productsupport.html?productName=Thomson%20Reuters%20World-Check%20One%20API


Categories