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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Carriage return generating formula

Status
Not open for further replies.

JasonKaufman

Programmer
Apr 13, 2006
46
US
I am using Crystal XI
and I have the following quandary.

I have a field called 'Remark' which for a particular customer will have a maximum of 5 subsections where the separator is '[.]'
For Example:
You can check the status of your entire order in the My Account section of our Website.[.]This order will be processed promptly[.]Thank you for your order[.]Have a nice day.

The customer wants each instance of the '[.]' to stimulate a carriage return so that instead of wrapping, there will be 5 lines (subsections) within the Remark section of the document.

Question is...how should I write such a formula?

Thanks in advance for the help!


 
Perfect!
thanks Charliy, that did it!

Now i just gotta figure out why if i have the same data for each subsection, why the 3rd one has the last 5 characters on the next line...
weird...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top