import files column separator

Question

Good afternoon.
When I try to import a file xls with a coma. Odoo takes it as a column separator. For example:
There is value in odoo for default: 402.01 Devoluciones, descuentos o bonificaciones sobre ventas y/o servicios a la tasa general.
So, for odoo my text ends where is that coma and returns me this message:
No se han encontrado registros coincidentes para nombre '402.01 Devoluciones' en el campo 'Tags' en la fila 2
Thank you very much.

Regards

Enrique Torres · Answer

Thank you very much Ermin.

But thats the trouble, how could I change the column separator?

Ithink it´s on odoo but I didn´t find the option.

My partner show me in his computer and the option appears under the import buttom but, with my user doesn´t.
Maybe some permission is missing.
And thanks again.

Ermin Trevisan · Answer

You can use a different field separator or use a text delimiter for columns containing such texts.

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!