home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
TM12_TIP.ZIP
/
537.TXT
< prev
next >
Wrap
Text File
|
1991-12-18
|
1KB
|
48 lines
I did a User Defined Import and my city and state are both in the city
field. How do I move the state to the state field?
When you touch 'C' for Change, is there a comma between the city and state?
And the state field is empty?
YES
---
We will be able to perform two Group Replaces to correct this,
but first I need to make sure that you have a current backup.
Also, if you only need to change some records, you will need to
write a filter to select those (such as CIT CN , ).
[If they have not performed a TeleMagic Backup, show them
how to do it, and have them write down the Group Replace
commands].
Have your filter in use, if applicable. Then from the TeleMagic
Main Menu, touch 'O' for Other Options and D for Database Utilities.
Touch 'R' for Group Replace Option. First replace the STA field
with:
<RIM(SUBS(CIT,(AT(",",CIT+1),3))
This command will move everything after the comma into the state
field.
Then replace CIT with:
&LEFT(CIT,(AT(",",CIT)-1))
This will replace city with everything up to the character before
the comma.
NO
--
[Note: If there is a space instead of a comma separating the
city and state, use the expressions above, but substitute the
AT(",",CIT)-1 with AT("space",CIT)-1 ].
End 537
05-02-91 (new) VGK
Index:Mass Replace