splitting address from one field to two

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

denise - 19 Jan 2006 20:39 GMT

In address fields I need to split the 2nd line of the address into a separate
field. The addresses (if there is a second line) are searated by carriage
return.
Any ideas for how I can get the 2nd line and put them into a separate column?
Thanks for any help.

Reply to this Message

John Nurick - 19 Jan 2006 21:38 GMT

Hi Denise,

I'd use a little custom function like this and call it from the update
query:

Public Function GetSecondLine(V As Variant) As Variant

On Error Resume Next 'to return Null if there's only one line
SafeSplit = Split(V, vbCrLf)(1)

End Function

>In address fields I need to split the 2nd line of the address into a separate
>field. The addresses (if there is a second line) are searated by carriage
>return.
>Any ideas for how I can get the 2nd line and put them into a separate column?
>Thanks for any help.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

Ozzie - 03 Feb 2006 16:10 GMT

Hi John,

I am trying to do something similar to the previous post but am struggling.

I have an odbc link to some tables, one of which has 24columns of data
entered into one and seperated by a semi-colon, eg "-125.23;-356.23;-12564.
59" etc

I need to break out these numbers and put them into their own field...... but
how ???

any help would be most welcome,

Thanks, David

>Hi Denise,
>
[quoted text clipped - 18 lines]
>
>Please respond in the newgroup and not by email.

Reply to this Message