Replace unicode character with actual symbol - generic

[alisaleh]

Hi,

We are pulling text information from excel files and load it into data model in sql server. The problem is all symbols used in the excel like indentation, tab, bullets ...etc. For example in once cell we are getting the following:

2.u00A0u00A0u00A0u00A0u00A0 Test Assumption 1

when researching the unicode we found that this code u00A0 corresponds to "Non Breaking Space". I can easily do replace values like this :

To replace the values with the actual representation but I would like to know if there is more generic dynamic way so that any unicode character found in the text is getting replaced woth the actual representation ? This is to avoid having to edit the report and apply the same method above for every encountered unicode.

Thanks for your help.

[Tahreem24 · Accepted solution]

@alisaleh Try this unichar table list. Copy paste this table in Power BI or via excel

Unicode Character Lookup Table (altcodeunicode.com)

[rajendraongole1]

Hi @alisaleh - can you please share some sample data in drive with what is expected that helps to understand

Thank you

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!