Forum Discussion
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 ...
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
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
Hello @AIB,
it works, thank you!
regards
