Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    12

    Unanswered: splitting a string

    right now i have the street number seperate from the address but i cant get the address to print seperate.

    Left({R_Addresses.AddressLine1},(Instr({R_Addresse s.AddressLine1}," ") - 1))

    for example:

    11 Peter St
    2341 Hog Road
    11111 Slippery Ave.
    --------i need----------

    Peter St
    Hog Road
    Slippery Ave.

  2. #2
    Join Date
    Mar 2006
    Posts
    12
    nm
    mid({address},(InStr({address}," ") ))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •