One way:
This example assumes:
1) "sequence" appears in the text only as a chunk delimiter,
and never within the body of a chunk.
2) "sequence" always appears as a word
(with a space on each side of it)
If the reality is different, make adjustments accordingly.
put fld "text" into tText
replace cr with space in tText
replace " sequence " with cr in tText
repeat for each line tChunk in tText
-- parse the text chunk however you wish
end repeat
Phil
Gregory Lypny wrote:
>
> Hi List Members,
>
> I have a field with inconsistently delimited data. I want to
> extract specific data from the field, and each occurrence of this data
> follows immediately after the word "sequence", which appears many times.
>
> What's the best way to cycle through the field to pick up each
> instance of the word "sequence"?
>
> Regards,
>
> Greg
>
> _________________________________________
> Gregory Lypny
> Associate Professor of Finance
> Concordia University
>
> _________________________________________
> "Take chances, make mistakes!"
> - Ms Frizzle, The Magic School Bus
>
> Archives: http://www.mail-archive.com/metacard%40lists.best.com/
> Info: http://www.xworlds.com/metacard/mailinglist.htm
> Please send bug reports to <[EMAIL PROTECTED]>, not this list.
--
Phil Davis
--------------------
days: (503) 986-1215
eves: (503) 557-5656
Archives: http://www.mail-archive.com/metacard%40lists.best.com/
Info: http://www.xworlds.com/metacard/mailinglist.htm
Please send bug reports to <[EMAIL PROTECTED]>, not this list.
