I have an Access table containing a pipe-delimited string in a single field. The string looks something like this...
Fieldname = fullText
value1|other value2|some other value3|yet another value4|and a final value5|
I need help writing an Access Expression which will take the string above and break it into separate fields like this...
value2 other value2
value3 some other value3
value4 yet another value4
value5 and a final value5
Can you help me with this? (I'm more familiar with expressions than VB but will accept a VB approach if you can walk me through how to implement.)