Forum Discussion
Replace unicode character with actual symbol - generic
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.
alisaleh Try this unichar table list. Copy paste this table in Power BI or via excel
Unicode Character Lookup Table (altcodeunicode.com)
2 Replies
- Tahreem24
Super User
alisaleh Try this unichar table list. Copy paste this table in Power BI or via excel
Unicode Character Lookup Table (altcodeunicode.com)
- rajendraongole1
Super User
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!!