topic Re: How to convert strange characters into accentuate one in a csv file in SAS Enterprise Guide

How to convert strange characters into accentuate one in a csv file

alepage — Tue, 24 Jan 2023 20:03:30 GMT

Hello,

I am trying to read a csv file which contains strange characters like below:

Pas encore inscrit mais j'espÃ¨re si tÃ´t.

j'espÃ¨re should be j'espère

si tÃ´t. should be si tôt.

Is there a way to change that when the file is unzip (see the Unix command below)

x %sysfunc(quote(unzip -jo /.../report.zip -d /.../report)));

Is it possible to use an encoding option while reading the decompressed file or does the tranwrd function is the only option?

Re: How to convert strange characters into accentuate one in a csv file

Ksharp — Wed, 25 Jan 2023 04:18:33 GMT

Try BASECHAR Function

Re: How to convert strange characters into accentuate one in a csv file

SASKiwi — Thu, 26 Jan 2023 20:24:34 GMT

How was the CSV created in the first place? Is "Pas encore inscrit mais j'espÃ¨re si tÃ´t" exactly what you see in the CSV if you open it in a text editor that doesn't change the contents? Try opening it with Notepad++ which report on the file encoding and can do encoding conversions.