Split data in field on character return

Jan 9, 2018
Reaction score
Hello all, new boy here.

I`ve got a field (street) in one of my tables which holds address data seperated by carriage return.
To use a new courier i need to split the data in this field into 3 address fields (addr1, addr2, addr3).

So far in a query I have:
Expr1: Left([street],InStr([street] & Chr(13) & Chr(10),Chr(13) & Chr(10)))
which returns the first line but how can I get the other 2 lines (presumably with mid and right)?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question