| Author |
 Topic  |
|
|
scumari
Netherlands
10 Posts |
 Posted - 03/18/2019 : 13:07:52
|
Hi,
Can someone tell me, what character is used by GQEMFPro as CSV file cell separator? It seems i have issues loading saved EMF-390 data files.
Thanks in advance, Rick |
check www.scumari.nl |
|
| Reply #1
EmfDev
2250 Posts |
Posted - 03/18/2019 : 13:31:22
|
| Hi Rick, the cell separator is a comma (,). |
Edited by - EmfDev on 03/18/2019 13:31:43 |
 |
|
| Reply #2
scumari
Netherlands
10 Posts |
Posted - 03/18/2019 : 23:11:48
|
Hi, thanks for your reply.
The point is, when i leave the separator as a comma, the program locks on loading. My dutch version of excel uses a semicolon (;) as separator and a comma for decimals.
I can't get any data on the screen in GQEMFPro.
Could it be my dutch version of Windows 7? |
check www.scumari.nl |
|
|
| Reply #3
EmfDev
2250 Posts |
Posted - 03/19/2019 : 08:40:49
|
| Have you tried changing the list separator in your computer from the control panel? |
|
|
| Reply #4
scumari
Netherlands
10 Posts |
Posted - 03/19/2019 : 13:39:00
|
| Good option, just tried but no result, still nothing shown |
check www.scumari.nl |
|
|
| Reply #5
EmfDev
2250 Posts |
Posted - 03/19/2019 : 14:22:52
|
edit1: #1 probably wouldn't work. try #2 but also replace all decimal points(dots) to commas. Do this after replacing the commas with ;.
Try these two.
1. add this extra line on top(first line) the csv file.
sep=;
(make sure you press enter after the semicolon).
2. edit your csv file using a text editor like notepad or notepad++.
use ctrl+h to replace all commas to semicolon.
|
Edited by - EmfDev on 03/19/2019 14:28:07 |
|
|
| Reply #6
scumari
Netherlands
10 Posts |
Posted - 03/20/2019 : 14:08:42
|
Hi, thanks for help.
Did both solutions but still no data on screen.
The first lines of the file look like this:
sep=;
EMF-390 Data Logged History
;EMF;EF;RF Power Density
Date and Time;mG;V/m;mW/m2;mW/cm2;pW/cm2
_2019/03/18 20:01:41;13.9;9.2;0.001;0.000;60.000
;5.0;9.6;0.001;0.000;60.000
;4.0;9.9;0.001;0.000;60.000
;13.7;7.7;0.001;0.000;60.000
;11.2;8.9;0.001;0.000;60.000
;11.8;7.9;0.001;0.000;60.000
;8.4;7.2;0.001;0.000;60.000
;6.1;7.2;0.060;0.000;6000.000
Should you see the graphics right after the loading?
Rick |
check www.scumari.nl |
|
|
| Reply #7
EmfDev
2250 Posts |
Posted - 03/20/2019 : 14:45:20
|
Seems like you replaced all the commas with semicolons.
It still because the decimals point '.' characters are still there.
Remove the sep=;
then use text editor again to change all '.'s to commas.
because you said earlier that your version uses comma for decimals.
;5.0;9.6;0.001;0.000;60.000 =====>>>> ;5,0;9,6;0,001;0,000;60,000 |
Edited by - EmfDev on 03/20/2019 14:46:47 |
|
|
| Reply #8
scumari
Netherlands
10 Posts |
Posted - 03/21/2019 : 01:09:10
|
I did both senario's.
Used ; as separator and , as decimal.
Results are the same, no data in screen.
Anyway, am working on a C# program to visualize the signals for reports.
|
check www.scumari.nl |
|
|
| Reply #9
EmfDev
2250 Posts |
Posted - 03/21/2019 : 10:41:05
|
| I'm not expert with excel so sorry can't help you. Maybe because your version is different as you said. I've read online maybe you can change your region settings but I'm not sure if it works. Good luck on your C# program! Should be better than excel :) |
|
|
| Reply #10
scumari
Netherlands
10 Posts |
Posted - 03/22/2019 : 06:03:12
|
The program is in development.
Screenshots at:
members.quicknet.nl/scumari/GQ/ |
check www.scumari.nl |
|
|
| Reply #11
scumari
Netherlands
10 Posts |
|
| Reply #12
EmfDev
2250 Posts |
Posted - 03/25/2019 : 09:20:04
|
| Looks great! |
|
|
| Reply #13
tksirius
USA
6 Posts |
Posted - 10/05/2020 : 13:37:58
|
quote:
Originally posted by scumari
The program is useable and can be viewed and downloaded from
www.scumari.nl/www/pcsw/emf/main.htm
Have fun
Is there an actual emf390cli.exe file to download? I'm having trouble figuring this out.
Do I need to convert my data to dld files somehow? |
|
|
| |
Topic |
|
GQEMFPro CSV separator
