Remove NBSP characterAnswered
I used normalize-space function in the data mapper to remove leading and trailing spaces from text, but it is not removing the spaces before it loads the data to the table. Column data type in the table is varchar.
The spaces appended to the end of the value in the excel file are not standard whitespace characters. If you read the character in ANSI, it is shown as Â Â Â Â Â Â Â Â .
You can try using the translate function
Please sign in to leave a comment.