cancel
Showing results for 
Search instead for 
Did you mean: 

Importing from excel with blank spaces after value

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Ravi,

Thanks for your quick answer. Yes it is possible to do it in excel but I want as less manual work as possible. So it is not an option for me.

I am sorry I did not mention that it is a numeric field so I cant use replace function (it is only possible for text fields).

Regards

Erik