Remove NBSP character

Answered

David Paras

• May 11, 2016 16:25

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.

 

Ex: 1000000457       

0

• Official comment

  

  David Paras

  • May 11, 2016 16:25

  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

  translate($Input_test7430/Root/Record/Loan,'Â', '')

  • https://docs.adeptia.com/display/AS/Using+Mapping+Functions

Please sign in to leave a comment.