importing csv files to framework manager

[naghamaj]

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

[MFGF]

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.

[naghamaj]

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

[MFGF]

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.