Forum Discussion

datajjw's avatar
datajjw
New Member
4 years ago

Special characters not displaying. Looks corrct in Power Query but not in Data or Report views.

Hi

 

I have a problem with displaying macrons in New Zaland place names

 

I have folloowed advice in other posts. I am getting data form a CSV encoded as UTF-8.

 

in Power Query, macrons disply fine 

 

But when I close and apply, the data does not display correctly 

 

 

Help please

 

Need Help

2 Replies

  • datajjw's avatar
    datajjw
    New Member
    4 years ago

    Have managed to solve it by doing a manual replace in the power query

    = Table.ReplaceValue(#"Replaced Value","ō#(008D)","ō",Replacer.ReplaceText,{"Teritorial Authority / Local Board"})

     

    Does anyone have an automatic solution rather than having to do it every time I load a file with macrons?

    • v-jingzhang's avatar
      v-jingzhang
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi datajjw 

       

      I cannot reproduce this. Can you please provide a sample csv file with some dummy data that can reproduce this problem? 

       

      Best Regards,
      Community Support Team _ Jing