Split data in field on character return


Joined
Jan 9, 2018
Messages
1
Reaction score
0
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)?
 
Ad

Advertisements


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

Similar Threads

Splitting a data field 2
split field data 3
splitting field data 3
split field data to 3 fields 5
splitting data into different fields 1
split a data field in access 1
Splitting data in 1 field 6
Split Fields 3

Top