Forum Discussion

mkhokale's avatar
mkhokale
New Member
5 years ago
Solved

remove unicode character 8206 from cells

My power query is failing to sync while transforming a column to Int64 type. I see it is because of the presence of invisible character (unicode 8206) in some of the cells.
To remove this character I am trying to use hex code (200E) of unicode 8206 as below but it doesn't seem to be working.

 

#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value","#(200E)","",Replacer.ReplaceText,{"Case length years"}),

 

Can you please advise how to use replace value to remove this character?

Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi mkhokale 

    #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value", Character.FromNumber(8206), "", Replacer.ReplaceText,{"Case length years"})

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    Hi mkhokale 

    #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value", Character.FromNumber(8206), "", Replacer.ReplaceText,{"Case length years"})

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers