
4.10 Flash Card Reader (continued)
Figure 4.40 Recorded Data File Directory
Figure 4.41
Example of data recorded on the
SD card, standard text (.txt) file format
4.10.1 Opening .txt Data Files
1. Right-click on the data file and select Open with Wordpad. This will display the ASCII
data in WordPad.
2. From the Edit menu select the Replace option to replace all the
;
(semicolons)
with
,
(commas).
3. From the File menu select Save As and save the file with an extension
.csv
(Comma
Separated Value).
4. This
.csv
file can now be opened in Excel with the correct format.
Alternatively, you can do the following--
1 Open Excel. Go to File, Open, select Files of Type: Choose Text files (*.prn, *.txt,
*.csv), and then select the data file you wish to open.
2. A Text Import Wizard should pop-up.
Select Delimited type of file, then Next.
Click on
semicolon
as the Delimiter type, then Next.
The screen should show how the file is being divided into columns, click on Finish.
3 From the File menu select Save As and save the file with an extension
.csv.
The next time you open this file it will open in Excel automatically.
You may remove the letters C or F and D from the recorded values (using the
Replace option of Excel or Wordpad). This will enable you to create charts of the data.
E:\
2010
Events
S20100401.txt
15,598KB
File Folder
File Folder
Text Document
4/01/2010 8:08AM
4/01/2010 8:08AM
5/02/2010 1:08PM
Name
File Edit View Favorites Tools Help
Type
Date Modified
Size
E:\2010
04
05
File Folder
File Folder
4/01/2010 8:08AM
5/02/2010 1:08PM
Name
File Edit View Favorites Tools Help
Type
Date Modified
Size
E:\2010\04
20100401.txt
20100402.txt
20100403.txt
20100404.txt
20100405.txt
20100406.txt
20100407.txt
598 KB
598 KB
598 KB
598 KB
598 KB
598 KB
598 KB
Text Document
Text Document
Text Document
Text Document
Text Document
Text Document
Text Document
4/02/2010 12:00AM
4/03/2010 12:00AM
4/04/2010 12:00AM
4/05/2010 12:00AM
4/06/2010 12:00AM
4/07/2010 12:00AM
4/08/2010 12:00AM
Name
File Edit View Favorites Tools Help
Type
Date Modified
Size
#2010/04/02;09:00:00;23.3C;35.6%;D6.7C;
#2010/04/02;09:00:10;23.3C;35.6%;D6.7C;
#2010/04/02;09:00:20;23.3C;35.6%;D6.7C;
#2010/04/02;09:00:30;23.3C;35.7%;D6.7C;
#2010/04/02;09:00:40;23.3C;35.7%;D6.7C;
52