BAQ Calculated field removing carriage returns 8.03.404A

I have not tried this in a BAQ but according to the progress syntax I
think you would need a set of either single or double quotes after the
last comma. I would probably replace the carriage return with a space.
For Example: Replace (OrderHed.OrderComment,Chr(13)," ").



Since this is a string replacement then you would need to specify a
string in the last parameter.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Wednesday, May 14, 2008 3:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calculated field removing carriage returns
8.03.404A



I am trying to create an expression that will truncate the order head
comment field. This expression works fine
substring(OrderHed.OrderComment,1,25) until it hits a carriage return in
the first 25 characters ( It drops the remain characters onto the next
line when exporting the dashboard out to Excel) Is it possible to remove
carriage returns using the replace function? What value would I use for
the carriage return? I tried Replace (OrderHed.OrderComment,CHR(13),)
and received a syntax error.

Thanks,

Dan Shallbetter

States Electric Mfg.

[Non-text portions of this message have been removed]



Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089


DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.



[Non-text portions of this message have been removed]
I am trying to create an expression that will truncate the order head
comment field. This expression works fine
substring(OrderHed.OrderComment,1,25) until it hits a carriage return in
the first 25 characters ( It drops the remain characters onto the next
line when exporting the dashboard out to Excel) Is it possible to remove
carriage returns using the replace function? What value would I use for
the carriage return? I tried Replace (OrderHed.OrderComment,CHR(13),)
and received a syntax error.



Thanks,



Dan Shallbetter

States Electric Mfg.





[Non-text portions of this message have been removed]