I used to do this thing that Chuck is advocating, but found that for very long strings, the LEN(..) function was expensive. So I always use 32200 for "until the end" and ensure that strings never go over this artificial 32K. (Of course, there are variations were such a thing to happen, but it doesn't happen at least in anything that I've designed.)
Some platforms (Reality, maybe?) had the -1 option on substring extractions; I thought that was clever. Too bad it never caught on, or if it did, I didn't notice. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Key Ally Sent: Thursday, July 28, 2005 2:53 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Text extraction. Mark, I usually split the difference and use: NEW="ABC":REC[15,LEN(REC)] It will always exceed (NEW="ABC":REC[15,1000000] could theoretically truncate) but it rarely exceeds by a ridiculous amount. - Chuck "Nothing Exceeds Like Excess" Barouch ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/