on 10-06-2009 1:47 PM
Hi experts,
I am using MDM 7.1.03.45.
I have a problem when importing from excel-file if there are blank spaces in the cell after the value. It seems like Import Manager then interprets this as text and then it cannot convert it to a number.
So my questions is, how do I get rid of trailing blank spaces?
Regards
Erik
Edited by: Erik Bothelius on Oct 6, 2009 2:48 PM
Hi Erik
The blank spaces can be removed in the excel sheet using a formaula.
Otherwise in the import manager after maping the field use a REPLACE operator to replace all spaces with NULL.
best regards
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.