remove unicode character 8206 from cells

[mkhokale]

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?

[AlB · Accepted solution]

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 

[mkhokale]

Hello @AIB,

it works, thank you!

regards