Hello Everyone,
i am trying to import cvs files into framework manager , after creating the odbc connection and getting the file in framework manager as a new data source , the fileds that i am getting are not well seperated . All the fileds are in one field seperated by a '';''
how can i solve this issue?
Thanks a lot
Nagham
Quote from: naghamaj on 11 Mar 2015 05:49:50 AM
Hello Everyone,
i am trying to import cvs files into framework manager , after creating the odbc connection and getting the file in framework manager as a new data source , the fileds that i am getting are not well seperated . All the fileds are in one field seperated by a '';''
how can i solve this issue?
Thanks a lot
Nagham
It sounds to me like your csv doesn't have values that are comma-separated? Is there a config option in your ODBC connection to specify the separator?
MF.
The initial file was in excel format I have saved it as csv (seperato: ';') . In the odbc connection there's no option to specify the seperator
Quote from: naghamaj on 12 Mar 2015 12:56:18 AM
The initial file was in excel format I have saved it as csv (seperato: ';') . In the odbc connection there's no option to specify the seperator
Try saving it as comma separator ','
MF.