Dan, >From the table name am I correct in implying that this is a temporary table. >If so why not try the following: revise the temp table Leftzip TEXT (3) Rightzip TEXT (3) ZipCode = (Leftzip & RightZip) text (7) -- or what ever size you need you split import the zipcode into its left and right parts putting it back together with a computed column. Several things to pay attention to: you may need to have two different temp tables definitions depending on the imported zipcode content. depending on how you further process the temp table be care full about having zipcode defined as computed and not computed
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ----- Original Message ---- From: Dan Goldberg <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Friday, July 24, 2009 1:04:10 PM Subject: [RBASE-L] - canadian zipcodes We import canadian zipcodes from time to time but we get them like: A0A1A0 But they want them with a space like: A0A 1A0 I tried the update command: UPDATE tmpimport SET zipcode = ((SGET(zipcode,3,1)) + ' ' + (SGET(zipcode, + 3,4))) WHERE zipcode IS NOT NULL It works but takes a long time to run. The canadian zipcodes are over 820000 rows. Does anybody know of a command that might run quicker?? TIA Dan Goldberg --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
