| T O P I C R E V I E W |
| scumari |
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 |
| 13 L A T E S T R E P L I E S (Newest First) |
| tksirius |
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? |
| EmfDev |
Posted - 03/25/2019 : 09:20:04
Looks great! |
| scumari |
Posted - 03/25/2019 : 00:27:26
The program is useable and can be viewed and downloaded from
www.scumari.nl/www/pcsw/emf/main.htm
Have fun |
| scumari |
Posted - 03/22/2019 : 06:03:12
The program is in development.
Screenshots at:
members.quicknet.nl/scumari/GQ/ |
| EmfDev |
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 :) |
| scumari |
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.
|
| EmfDev |
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 |
| scumari |
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 |
| EmfDev |
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.
|
| scumari |
Posted - 03/19/2019 : 13:39:00
Good option, just tried but no result, still nothing shown |
| EmfDev |
Posted - 03/19/2019 : 08:40:49
Have you tried changing the list separator in your computer from the control panel? |
| scumari |
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? |
| EmfDev |
Posted - 03/18/2019 : 13:31:22
Hi Rick, the cell separator is a comma (,). |
