home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
TM12_TIP.ZIP
/
569.TXT
< prev
next >
Wrap
Text File
|
1991-12-18
|
1KB
|
42 lines
REPLACEING THE "DEAR" FIELD WITH THE LAST NAME FROM CONTACT FIELD
-----------------------------------------------------------------
If a database contains doctors/dentists as customers, you
may want to place the last name from the CONTACT field to the
DEAR field. For example:
Dr. Robert Jones
Dr. Roberta Williams
Before performing Group Replaces, it is always a good idea
to have a current backup of your data in the event that something
goes wrong. You may want to set up a filter based on one record
to test the Group Replace before changing a group of records.
To perform the Group Replace, from the TeleMagic Main Menu Touch:
1. "O" for Other Options
2. "D" for Database Utilities,
3. "R" for Replace in Filtered records
4. In the "Replace this Field" enter the Dear field (US5 or the
appropriate field in your database) by pressing F-2 to bring
up the Fields List Box. Highlight the Dear field and press
<ENTER>.
5. At the "To look like this" enter the following command:
&right(con,(30-rat(" ",trim(con))))
6. Select "Screen" when prompted.
After TeleMagic has finished the Replace, go to the filtered
record and verify that the Replace was successful!
100991CLW
Indexed under R Rat Command to grab Last Name from the CON Field