Forum Discussion

alisaleh's avatar
alisaleh
Icon for Advocate I rankAdvocate I
2 years ago
Solved

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.

 

 

2 Replies