General information
Category:
Coding, syntax & commands
Hi,
I have this program to split the address field. The program scans
a table record by record and updates certain fields. What it
really does is, it splits the value in address field into four values
namely StreetNo, StreetName, Predirectional, SecondaryAddr. It then
inserts these values into the corresponding fields for each record.
I am not altering the structure of the table. I already have the
extra fields (streetname, streetno etc.) but only that these fields
are empty and they are updated by this program.
The table has over 2 million records and I want to make sure that this
job is done in the shortest time possible. Could anyone suggest the
things that I should take care of.
Here is a snippet of the code:
SELECT MYTABLE
IF RECCOUNT() > 0
SCAN
ADDRESSVALUE=MYTABLE.ADDRESS
STANDARDIZE(ADDRESSVALUE)
REPLACE STREETNAME WITH STNAME, STREETNO WITH STNO, PREDIRECTIONAL WITH PREDIR, SECONDARYADDR WITH SECADR
ENDSCAN
ENDIF
STANDARDIZE IS A PROGRAM THAT SPLITS THE ADDRESS FIELD INTO
THE VARIABLES STNAME,STNO,PREDIR,SECADR.
ANY SUGGESTIONS WOULD BE MUCH APPRECIATED.
RIA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only