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)?
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)?