home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
TM12_TIP.ZIP
/
527.TXT
< prev
next >
Wrap
Text File
|
1991-12-18
|
839b
|
20 lines
Q: I just imported a list and there is nothing in the "Dear" field.
How can I take just the first name of each contact and place it into
the Dear field?
A. You can do this with a replace of filtered records. First, use a filter
to select just those records you would like changed (000 for all
records) then from the "Replace in filtered records" option of the
"Database Utilities":
Replace this field: US7 ; "Dear" field
To look like this : &SUBS(CON,1,(AT(" ",CON)-1)) ; 1st name of CON
This command takes the first word from the CONtact field and copies it
into the US7 field. If you use another field for your DEAR field,
please substitute the correct TeleMagic field name like US3 or US5.
END 527
02/22/91 DRM
indexed on: dear/replace/import