Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MFKJB
  • Order by date
  1. MFKJB

    Using Split to break up an address field with multiple lines?

    No, there is a single CR. If you export the data into excel you can see a small box which indicates the single CR. Trying your suggestion gives the following error : A Subscript must be between 1 and the size of the array.
  2. MFKJB

    Using Split to break up an address field with multiple lines?

    Chr(13) is a carriage return. Basically our field has 4 lines, each seperated by a carriage return, so using chr(13) I can detect each end of line and therefore distinguish between address lines.
  3. MFKJB

    Using Split to break up an address field with multiple lines?

    Hi, I have a field I wish to break up into individual formula fields so each address line is stored seperately. I'm attempting to use the split function to break up the field as follows : Split({MainOrder.DeliveryAddress},Chr(013))[1] This gives me the first line of the address field...

Part and Inventory Search

Back
Top