If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Definition File - csv

Started by tamise, 19 Apr 2014 12:40:19 PM

Previous topic - Next topic

tamise

Hello,

I want to load a table with CSV  file so i used a definition (.def) file.
In my csv file, I have a column AMOUNT ( -1 256 895).
And in my def file a put AMOUNT NUMBER 33.5 . I got a error message invalid number.

Can you please help me ?

Thanks.

rih9000

I would (in the CSV file) change the spaces to the null character.
rih9000
8)

tamise

Si do you mean that i have to put -1256895 instread of  -1 256 895.
It is working but is there another solution?

rih9000

Hi, I can't think of another solution,
rih9000