Skip to Content
author's profile photo Former Member
Former Member

Joining Strings

I have a dlima that I am hoping someone can help me with. I am trying to join a set of strings that appear as separate sequences for a given record. These are collection notes entered by the user and are broken into multiple 'sequences' for each instance. I suppose this is done because of field length, but I want to join them so that it reads cohesively per instance. This is an example of the text fields per call date:

Call Date Sequence Text

11/17/2011 1 Called Lisa and got voice mail indicating

2 that the voice is full and can no longer leave

3 messages. I have sent an email to her to contact

4 me. HDP

As you can see, if I report on this text field, it will take up valuable space within the body of the report and does not read cohesively. I am not as savy with CR as I would like to be, but I know there must be a way to join these text fields into one long text field per call date.

Any help you can provide is greatly apprecaited.

Marlene 😊

Crystal Reports 2008

Version 12.3.0.601

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 04:49 PM

    Hi Marlene,

    A formula like:

    Field_1 & Field2 & etc ?

    Are the sequences listed numerically ?

    Is the number the first character(s) in the string ?

    Are there unlimited numbers of sequences

    where you might need a "For" statement ?

    Thanks,

    Jimmy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 04:45 PM

    Hi

    You will have to write a formula to eliminate new line character, try the following :

    REplace(, chr(13),' ')

    Place the above formula in our report.

    Thanks,

    Sastry

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.