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:

		&LTRIM(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