Import-Export CSV File-- why first element have --> i>>¿"codigo_oferta"

[javier94]

i have to export a list in archive Excel in format Csv.. and once exported.. filled with some datas and try to import...

when i export.. in the first element selected.. appears ï>>¿" codigo_oferta" --> when the element name is only codigo_oferta .. the rest of elements exported are perfect...

How can i do to delete the extra characters appears in the first element.. i have not try.. but i think that if the first element have this special character when i try to import.. will not run.. because the element in the import list and the excel element dont have the same name...

or.. i can add this extra characters to the element placed in the import list??

thanks in advance!!

Javier

 

[troester]

I can't replicate. It's looking like BOM which is needed for Excel with UTF8.

Check your export settings (CSV/ExcelCSV, file format, file encoding) and your import settings.

 

[javier94]

ok i checked in file encoding and change from default --> to UTF 8.. but the first element exported.. have same .. special characters..
should be other thing.. i'll investigate.
many thanks!

 

[troester]

Where do you see these characters: in Excel, in Notepad...?

 

[javier94]

IN EXCEL
As you can see always in 1st element.. have the same special characters

 

[troester]

Strange.
What are your export settings?
Which version of Excel, which OS?

 

[javier94]

Exports setting



excel version . 14.0.0
ios Mojave version 10.14.5

 

[troester]

So this is IOS-Excel?
Try with other file encodings (e.g. Mac Roman) and/or with CSV instead of ExcelCSV.
Excel is ... It would be to easy to support UFT8 out-of-the-box

which is thought for Windows, I don't know what is best for IOS

 

[javier94]

the special characters appears with Mac.. with pc.. is perfect!!

thanks!