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

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List Spell Checker
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

   Insert an Image File
Check here to include your profile signature.
    

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 (,).

GQ Electronics Technical Support Forum © Copyright since 2011 Go To Top Of Page
Generated in 0.2 sec. Snitz's Forums 2000