\/[marg=5,75]


          HOW TO MOVE THE STATE FROM CITY FIELD TO STA FIELD
          ---------------------------------------------------

     If you have imported records that have the `city,state' in the City
field, you can use the following group replace to move the State into the
state field and remove the comma from the city field.  

NOTE:  Before you proceed, please make sure you have a good current
       backup of your TeleMagic data files! 

     The procedure takes two steps using the 'Replace in filtered records'
feature of TeleMagic.  The first step is to move the state from the City
field and into the State field.  

     1.  From the TeleMagic Main menu, touch 'O' for Other options.
     2.  Touch 'D' for Database utilities.
     3.  Touch 'R' for replace in filtered records.
     4.  Next type 'STA' at the 'Change this database field'
         prompt.
     5.  At the 'To look like this' prompt, type the following
         string:

          &ltrim(subs(cit,(at(",",cit)+1),2)) 
     
     6.  Press 'Y' at the "Are you sure?" prompt then press 'S' to 
         send the output to the screen.
  
     7.  When the procedure is complete, press 'ESC' to bring up
         the 'Database utilities' menu.

     The next step is to do a group replace in the City field to eliminate
the comma after the city.  From the 'Database Utilities' menu:

     1.  Press 'R' for 'Replace in filtered records.'
     2.  Next, type 'CIT' at the 'Change this database field'
         prompt.
     3.  At the 'To look like this' prompt, type the following
         string:

          &left(cit,(at(",",cit)-1))

     4.  Press 'Y' at the 'Are you sure' prompt then press 'S' to
         output to screen.

     After the procedure is complete you should do a magic rebuild.

121291-CLW/mlm
(End of 582)
Replacing groups of data
Group Replace
\/[eject]