Use Macro Express to Process an ASCII Text file

Macro Express automates repetitive tasks on the computer. See how the program may be used to process the contents of an ASCII text file.

---

Closed Caption:

this video demonstrates how to use macro
Express to read the contents of a text
file
and insert the data into another
application the ASCII text file command
is a much quicker and more reliable way
to transfer data than a strict copy and
paste routine
in this case the macro reads directly
from the file
instantly in search results into the
receiving application
there's no need to switch back and forth
between programs
hopping from one PC to another
beforehand we created a sample CSV file
for use with this macro
it contains some zip code data from the
state
top there are seven records on each line
file
each records separated by a comma okay
let's get started by clicking on macros
at macro
macro window hockey is already selected
in the blinking cursor is located in the
end
box next hold down the Control key the
Shift key and
Zekey all at the same time and then
release them control shift Z is now
listed in the ad box
this is the hockey will use when playing
back the macro
click on the script her button to start
building the macro
first click on the properties happen
enter process zip code data in the
nickname feel
nickname helps to remind us later with a
macro does
next click on the scope have and make
sure global is checked
global was a default option and means
that the matter will start
any program hockey is pressed now or
click on the script abs right
first find the files folders category
and double-click
ASCII file begin process command click
on browse and find
CSV file to be process select the file
and click
open to see it listed in the file name
box since we're processing a comma
delimited
text file we will see slept this file
type which also happens to be the
default
for leave the start processing on record
by
set the one this instructs Mac or the
star processing the first line
the CSV file make sure the process all
records options
like to ensure that all lines file
process or use variable t want to begin
storing the values from the text file
this means that the first field or
record online wanna save
31 second record on the line 32
third variable t3 and so on click OK to
save changes and return to the scripting
editor now let's open the texts category
double click on the text commando yet
when we want the macro to type the first
six records
each line into Word the seventh record
will
will be ignored to do this type percent
you 1 percent in the inner keystrokes
and box
to construct a macro to playback by
saved very
41 copy per cent to one per cent and
paste it so that way
have six entries one for each the six
records
we all want use from the text at each
other pace in entry so that the second
one shows
t2 third 93 and so on type
safety variables click OK to say
returned to the script return to the
files/folders category
double click on the ASCII file in
process command
place Union the end
the script this step closer to sleep
all commands list between the ASCII file
begin process command
ASCII file process repeated
each line text file has been processed
click on File Save to save the Mac
comeback rocks for to view the list them
rooms now we'll see how the macro works
first open WordPad press control ship Z
to run the macro it is not necessary to
first
open the text file in order to read the
data from as you can see the Texans
entered in the word
processed each line text file place
records word this macros a simple
example of what can be done using the
process
ASCII text file command for example when
entering records into a database choose
which variables to answer
and order or at helps move field
feel update a record in the database
wait for the window to refresh insert
the second line
the text file database saw
possibilities are limitless not to
mention improved accuracy
tremendous times
this concludes our process in ASCII text
file video
we hope that is provided you with ideas
for using this feature to
increase your own productivity