Thanks, this is a big help. The problem in excel I am having with the HDCase.description is not the wrapping but the fact that it is treating the first part of the line as one field and then the other part is creating a new row in excel. I'm trying to make sure that the description field stays together and comes into excel as one field
--- On Thu, 10/15/09, Steven Gotschall <sgotschall@...> wrote:
From: Steven Gotschall <sgotschall@...>
Subject: Re: [Vantage] Re: Crysta syntax for carriage return?
To: vantage@yahoogroups.com
Date: Thursday, October 15, 2009, 8:19 AM
Â
Same way:
replace(replace( HDCase.Descripti on, chr(13), " // "), chr(10), " // ")
If you want to limit the length to lets say 200 characters, then it would be:
Substring(replace( replace(HDCase. Description, chr(13), " // "), chr(10), " // "), 1, 200)
In Excel, you can format the cell or column to either wrap the text or not wrap it.
____________ _________ _________ __
From: Mark Wagner <mjfw2003@yahoo. com>
To: vantage@yahoogroups .com
Sent: Thu, October 15, 2009 8:01:18 AM
Subject: Re: [Vantage] Re: Crysta syntax for carriage return?
Â
Steve, I had a similar issue with HD Case except mine is the Description and Full Description (which are the same fields) The first line is max 60 characters and the second part of the full description seems almost unlimited (I have some descriptions where users write a book in there)
Â
Do you know how I can get the first and second part of the HD Case description so it does not wrap when brought into excel?
--- On Wed, 10/14/09, Steven Gotschall <sgotschall@ yahoo. com> wrote:
From: Steven Gotschall <sgotschall@ yahoo. com>
Subject: Re: [Vantage] Re: Crysta syntax for carriage return?
To: vantage@yahoogroups .com
Date: Wednesday, October 14, 2009, 3:09 PM
Â
What I do for BAQs that display descriptions is to create a calculated field like this:
replace(replace( HDCase.Resolutio nText, chr(13), " // "), chr(10), " // ")
I do this because if you try and copy and paste with the carriage returns in the text, it messes up Excel. Since this is 4GL it should work in a BPM.
____________ _________ _________ __
From: Kerry_Muntz <kerry_muntz@ yahoo.com>
To: vantage@yahoogroups .com
Sent: Wed, October 14, 2009 2:59:56 PM
Subject: [Vantage] Re: Crysta syntax for carriage return?
Â
Kinda the same subject: Does anyone know how a carriage return can be detected? eg in a method directive (BPM)? Part descriptions are occassionally made with a carriage return - which stuffs up some import/export stuff for us. I'd ideally like to shut the carriage return down for the description field.
--- In vantage@yahoogroups .com, "Gerry Loranger" <gloranger@. ..> wrote:
>
> The following prints "a" on one line and "b" on the next:
>
>
>
> "a" & chr(13) & "b"
>
>
>
>
>
>
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of
> advantage@.. .
> Sent: Wednesday, October 14, 2009 1:40 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Crysta syntax for carriage return?
>
>
>
>
>
> Brain fade here. What is the crystal syntax for carriage return Chr13?
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]