Blank Lines Memo Field 2

[codrutza]

Hi
Maybe you can help me with this.
I have in a report a memo field which has a blank line

Aaaaa

Bbbb
Ccccc

Can I suppress the blank line somehow?
Many thanks

 

[kray4660]

Not exactly. You probably could use the replace command. I am assuming that there would be two carriage returns in a row. So something like this Replace({memofield},chr(13)+chr(13),chr(13)). I have not tried this.

 

[pmax9999]

I agree with kray4660's, in that it will work as long as the blank line arises because of consecutive chr(13) characters. The problem is it could also be due to consecutive chr(10) characters (and I think there are others that also have a similar affect), or even one of each. It could be further complicated by having 1 or more spaces between them. The only way to reliably deal with this is to first determine what is causing the blank line.

I am guessing that the data is being entered manually into the system by the users, in which case you will be dealing with wildly inconsistent approaches. Probably better to just accept the data the way it is and work on educating the users (good luck with that).

Cheers
Pete

 

[kray4660]

I suppose you might be able to do a count of Chr(10) and/or Chr(13) and delete all the extra one. It probably would be pretty nasty code.