Split Large Text Field into several smaller fields
Fairlight
fairlite at fairlite.com
Thu Jan 3 14:40:32 PST 2008
On Thu, Jan 03, 2008 at 04:12:00PM -0600, after drawing runes in goat's blood,
Mike Schwartz cast forth these immortal, mystical words:
> Parsing routines are fairly simple to write in only a few lines. Build
> a loop and use the "mid" function with some variable counters like LE and LF
> in the sample below, using "INSTR" to search for spaces. Loop through the
> "mid" 200 times and capture the characters.
That works as long as the original variable/field will contain all the
data. If it's greater than 32767 bytes worth of data, you'll have to use a
FIFO ring buffer and process the data in chunks, reading in more of the
original each time you run out of original data. That gets more complex
when you -need- to ensure all of an atomic operation is present in a parse,
and it falls smack across a chunk boundary.
mark->
More information about the Filepro-list
mailing list