I am wondering if it is possible to remove blank lines from a text field. I have a report that has descriptions for tickets and some of those tickets are unnecessarily long due to multiple blank lines being add by the user.

This is an example of what it currently looks like.

 
This is the description field.


It has unnecessary blank lines.


Making for a longer report.

This is what I would like it to look like.

 
This is the description field.
It has unnecessary blank lines.
Making for a longer report.
 

I'm using EXL2K as the format of the report.

This message has been edited. Last edited by: Kerry,

Well, I am guessing on this one, but in my experience "extra lines" in a text field have often been just a case of the user hitting the key too often. This will leave extra CR (carriage return) and LF (line feed) characters. If this indeed the case you should be able to use the POSIT function to locate the extras and then I would try using the CTRAN / STRIP functions to strip out the extra CR (carriage return) and LF (line feed) characters by changing them to spaces.

quote:

Originally posted by rfbowley:
Well, I am guessing on this one, but in my experience "extra lines" in a text field have often been just a case of the user hitting the key too often. This will leave extra CR (carriage return) and LF (line feed) characters. If this indeed the case you should be able to use the POSIT function to locate the extras and then I would try using the CTRAN / STRIP functions to strip out the extra CR (carriage return) and LF (line feed) characters by changing them to spaces.

Thanks, I'll look in to it.