Function to Dynamically Parse Text

[avandalay]

I have several thousand lines of text in a form:

Company >> Group >> Project >> etc.



I'd like to break these lines up into separate fields for each (company, group, project, etc.). Is there a function (or suggestions to write a function) that can scan each line for the ">>" break and remove just the relevant part?

Any alternate strategies also appreciated. Thanks.

[rpeare]

you have thousands of lines of text on a form, a database form? or a you have text in a text file that you want to break up and/or import into a table? is it a text file of some sort that is delimited by a single > mark or by double >> marks? I'm not really following your use of terminology. In in access a table is an object that contains data that is broken up into fields, a field is an individual piece of data. A form is a visual representation of what is held in a table. But the way you are using the term I don't think we're speaking the same language.

[boblarson]

Hmm, this is marked solved but it has no solution posted. Is it really solved (if so, please post your solution) or is it just marked that way by accident?