Back to Technical Support Document Index

1. It is STRONGLY recommended that you back up your farm BEFORE attempting this global replace. A single character out of place in the expression in step 6 could ruin all the data in the LENDER field. Either copy the farm to a floppy disk (Main Menu, "Copy A Farm To / From Disk"), or view the farm and use the Misc Menu "Copy A Farm " option.
2. Select "View A Farm" from the Main Menu, and select the farm and order (which order you select at this point doesn't matter).
3. Press F5 for Misc Menu, and select Global Replace. Press any key to bypass the warning.
4. Select the LENDER field and press Enter.
5. When prompted for the expression to Replace LENDER with, type the following EXACTLY as shown (except all on one line):
6. Answer "Y" to both the "Unable To Validate Expression..." and "Is this expression O.K." prompts.

First caps Lender's field

The following will convert the first letter to upper case and the rest to lower.

• (UPPER(SUBSTR(field_name,1,1))+ LOWER(SUBSTR(field_name,2)))

Second pass

• (UPPER(SUBSTR(field_name,AT(",'',field_name)+1,1))+ SUBSTR(field_name,AT(",'',field_name)+2))

Reversing names in Lender's field

(ALLTRIM(RIGHT(lender,LEN(lender)-AT(",",lender)))+" "+ ALLTRIM(LEFT(lender,(AT(",",lender)-1))))

This assumes that ALL the records in question that you are going to replace have a comma separator. If even ONE field does not, this replace may crash and hang up your system. Either query for records that have a comma in the LENDER field (LENDER Contains ","), or manually insert a comma in the records that need it. small office, home office, soho, soho software, real estate agent software, realtor software, mortgage broker software, real estate broker, real estate tax data software, tax roll data software, property data software, real estate property software, real estate database management software, real estate listing software, real estate software, real estate management, lending software, lender software, mortgage software, contact management, listing management, cma sofware, cma report software, closing management, escrow management, escrow software, closing software, closing manager, escrow manager, campaign manager, financial calculator, financial software, refinance software, refinancing software, loan qualification software, amortization software, scheduler software, scheduling software, real estate spreadsheet, settlement sheets, bulk mailing, client management, telemarketing software, real estate database software, mls software, multiple listing service software, scheduler, spreadsheet, settlement sheets, INSTANT IMPACT! GOLD, INSTANT IMPACT!, instant impact gold, Information Products, salesimpact, sales impact, the lenders edge, lenders edge, lender's edge, INSTANT IMPACT! GOLD, INSTANT IMPACT!, instant impact gold, Information Products, salesimpact, sales impact, the lenders edge, lenders edge, lender's edge