Getting rid of the spaces and new line in notes field...

[cdnamm]

Hello,
I have this note field in my report but it is taking too
much space in the report since it has too many spaces in between.
Sample notes

02.01.03 cs Adj. to cl#2002112506800028 was denied as ooa.
Per Penny ipa resp. on 2002 claims.
02.01.03 cs Erd date 01/15/03 from HP Amm recv'd date 01/24/03
02.01.03 cs Erd date 01/17/03 from HP Amm recv'd date 01/24/03

The report would display exactly like that with the spaces and new lines. I want to trim the space and make the new lines continuous so it will look like a nice paragraph and
save space. Thank you!
cdnamm

 

[lyanch]

@DisplayFormula

******************
stringvar removespaces:= {table.stringfield}

while instr(removespaces," &quot > 0 do
(removespaces:= replace(removespaces," ", " &quot);

removespaces
*********************

Removes the spaces, you could do a similar loop to remove the cr's

Lisa

 

[rosemaryl]

Dear CDnamm,

You could also do a SQL Expression on the field and it wouldn't require any lools. Depending on your db the syntax is different but should be similar to:

Replace(Replace(Table.Notefield,' ',''), char(13),'')

Hope that helps,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[cdnamm]

Thanks for your help, guys!
I really appreciate it!
cdnamm