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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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.- MFKJB
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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.- MFKJB
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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...- MFKJB
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
