Displayng a specific line in a text field

[justine92]

Hi --

I'm fairly new to crystal report development. I have a report that requires to display line 4 of an existing text field. Is there a formula that will allow you to show a specific line from a text field? There would be no blank lines in this case.

Any help would be great!

 

[lbass]

You could try a formula like this:

stringvar array x := split({table.text},chr(13));
if ubound(x)>=4 then
x[4]

-LB

 

[justine92]

I tried the formula but it didn't work. But, I took the formula and changed it to:

stringvar array x := split({TW_V_COMMENTS.TEXT},chr(13)); ubound(x)>=4

which, this showed a 'true' 'false' display, indicating that there was data on line 4.

Is there a function that can be included in the formula that would display the actual value instead of the true/false?

 

[lbass]

What did you see when you used my formula? In what way did it not work?

Please show the values of a couple of text fields and the corresponding formula results to illustrate what is going on.

-LB

 

[justine92]

Thanks, BTW, for your reply.

When I used the formula you sent me, the report showed a blank space where I dropped the formula in the design tab. So, I changed it the formula I referenced above, and it gave me a true/false value instead (meaning, 'true' if there was value on line 4 and 'false' if there wasn't).

So, the text field I'm using has this information in it as an example:

Site Name
Department Name
Department Area
San Jose
Costa Rica

I need the report to print line 4 which will give me the city name. Is this possible to write in a formula?

I appreciate your help! Thanks!

 

[lbass]

My formula should have worked, unless the text isn't using chr(13) for line breaks.

Please add a test formula and let me know the results:

instr({table.text},chr(13))<>0

If the answer is false, then substitute chr(10) (line feed) for chr(13).

Also please verify whether the text is single-spaced. If there were two returns at the end of a line, you would get the incorrect results.

The other test that would help would be if you provide sample text and then add the formula and substitute numbers for the subscript, e.g., replace 4 with 3 in two places and then report back (repeat with other numbers):

stringvar array x := split({table.text},chr(13));
if ubound(x)>=3 then
x[3]

-LB