[AccessD] How to Split a Text Field into Smaller Segments

[Brad Marks]

All,


In order to analyze the data that is contained in a text field, I need to break the data in the field into smaller segments. 

There is a vertical bar "|" separating each smaller segment.

Example -

AA |  BBB | CDFDFF |  XFEDD  

I would like to extract each smaller segment of the string and end up with four fields (for this example)


AA
BBB
CDFDFF
XFEDD  

If there an easy way to do this with VBA?

Thanks,
Brad