CSV export all messed up with special characters

tec.adriano.menezes · January 4, 2021, 12:24pm

Hello everyone!

I have tried some times to use special characters in the ReachView 3 description, but i’m always got issues when exporting. The file gets scrambled after the special character, not showing the said character and jumping lines in the CSV file.

Also it only shows the standart deviation after the description line with the special character, cutting out the coordinate and also the name and description.

The workaround is obviously deleting any special character and not using them after. If possible to correct this issue it will be amazing!

Follow an image and the CSV file.

Erico.zip (4.5 KB)

TB_RTK · January 4, 2021, 1:02pm

Looks allright here. Try changing letter coding or language during import and make sure you format import data for CSV. Right now you have all data imported without using function " text to coloum"

tec.adriano.menezes · January 4, 2021, 2:07pm

I actually configured the csv file to always open in excel when executed.

If you grab this file i sent and open it as TXT you will see that the description is between “”.

Follow image below:

agrimgalina · January 4, 2021, 2:53pm

Correct !! Check the regional settings

TB_RTK · January 4, 2021, 3:04pm

Ok, I see.
Just simply not using special character would solve it but in your case it adds two enter stroke.

May i ask what your special character looks like?

tec.adriano.menezes · January 6, 2021, 2:23pm

It’s a double apostrophe, before and after the description.

I’m not generating these files, just receiving them. So i can’t see how they are inside the ReachView 3.

The issue is not deleting special characters, probably the smartphone that’s generating these files.

At the moment ReachView 3 doesn’t detect the native smartphones file manager so maybe the issue is when exporting CSV file via third party. I received this CSV via Whatsapp

tec.adriano.menezes · January 7, 2021, 11:18am

Inside the ReachView 3 it’s normal. Follow image:

TB_RTK · January 7, 2021, 11:30am

Just tested on my phone and it comes out just right. Might be issue with language or letter coding

tec.adriano.menezes · January 7, 2021, 1:13pm

I see. So could be the smartphone whne generating theses files. I will be checking the configs inside the smartphone and in the notebook that was sent to me these files.

Thanks everyone for the help!

tatiana.andreeva · January 11, 2021, 6:13am

Hi Adriano,

Thanks for the report! We’ll look into that and try to reproduce.

We’ll also keep you posted on it.

tec.adriano.menezes · January 18, 2021, 4:32pm

Ok Tatiana!

Probably is the smartphone configuration or maybe the Excel that’s changing theses configs in the transfer.

If you find anything of notice, let me know!

The smartphone used is a Motorola G7 Power with Android 10

kseniia.koliuk · January 20, 2021, 2:36pm

Hi Adriano,

I’ve tried to reproduce your issue on an Android smartphone. I’ve exported a CSV file with points that descriptions contain " character. ReachView 3 output doesn’t have excess blank lines, and the file can be imported to Excel fine.

May I ask you to clarify if you are working with the latest ReachView 3 version?