GQ Electronics Technical Support Forum


GQ Electronics Technical Support Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 GQ Electronics Forums
 3. GQ EMF EF Meter RF Spectrum Power Analyzer
 GQEMFPro CSV separator
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

scumari

Netherlands
9 Posts

Posted - 03/18/2019 :  13:07:52  Show Profile  Reply with Quote
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

855 Posts

Posted - 03/18/2019 :  13:31:22  Show Profile  Reply with Quote
Hi Rick, the cell separator is a comma (,).

Edited by - EmfDev on 03/18/2019 13:31:43
Go to Top of Page
Reply #2

scumari

Netherlands
9 Posts

Posted - 03/18/2019 :  23:11:48  Show Profile  Reply with Quote
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
Go to Top of Page
Reply #3

EmfDev

855 Posts

Posted - 03/19/2019 :  08:40:49  Show Profile  Reply with Quote
Have you tried changing the list separator in your computer from the control panel?
Go to Top of Page
Reply #4

scumari

Netherlands
9 Posts

Posted - 03/19/2019 :  13:39:00  Show Profile  Reply with Quote
Good option, just tried but no result, still nothing shown

check www.scumari.nl
Go to Top of Page
Reply #5

EmfDev

855 Posts

Posted - 03/19/2019 :  14:22:52  Show Profile  Reply with Quote
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
Go to Top of Page
Reply #6

scumari

Netherlands
9 Posts

Posted - 03/20/2019 :  14:08:42  Show Profile  Reply with Quote
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
Go to Top of Page
Reply #7

EmfDev

855 Posts

Posted - 03/20/2019 :  14:45:20  Show Profile  Reply with Quote
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
Go to Top of Page
Reply #8

scumari

Netherlands
9 Posts

Posted - 03/21/2019 :  01:09:10  Show Profile  Reply with Quote
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
Go to Top of Page
Reply #9

EmfDev

855 Posts

Posted - 03/21/2019 :  10:41:05  Show Profile  Reply with Quote
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 :)
Go to Top of Page
Reply #10

scumari

Netherlands
9 Posts

Posted - 03/22/2019 :  06:03:12  Show Profile  Reply with Quote
The program is in development.
Screenshots at:
members.quicknet.nl/scumari/GQ/

check www.scumari.nl
Go to Top of Page
Reply #11

scumari

Netherlands
9 Posts

Posted - 03/25/2019 :  00:27:26  Show Profile  Reply with Quote
The program is useable and can be viewed and downloaded from
www.scumari.nl/www/pcsw/emf/main.htm

Have fun

check www.scumari.nl
Go to Top of Page
Reply #12

EmfDev

855 Posts

Posted - 03/25/2019 :  09:20:04  Show Profile  Reply with Quote
Looks great!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
GQ Electronics Technical Support Forum © Copyright since 2011 Go To Top Of Page
Generated in 0.2 sec. Snitz Forums 2000