Skip to Content
0
Former Member
Jul 05, 2011 at 08:08 AM

Problem in files from UNIX Server

11 Views

Dear All,

We are facing a problem in loading Excel files when we are trying to load from Excel File Format.

Here is a sample input which we are giving.

1327334

65767502

66674783

This is going through excel files. I have about 100 excel files to be loaded everyday. And this was working fine when my DS was installed on WINDOWS environment.

But when we shift to UNIX. The output of this file format comes as :

1327334.0

6.5767502E7

6.6674783E7

I have no clue currently why is it happening and how to correct it.

I cant change for everyfile so a standard solution is what i am looking for. If i change to .csv , this works fine, but i cant change my 100 files to CSV as there are some complications in it.

I am on Data Services 3.2.

Kindly suggest.