How to split up text

Yahoo Archive
1
Thanks again Mark,

The chr(13) did the trick. Excellent answer.

Regards,

- Neil


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Saturday, 1 September 2012 1:10 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How to split up text



Good Day Neil,

> Yes the chr(10) worked for items I had uploaded with DMT, but manually entered items I am unable to split using that, "\r", "\n" or anything else that seems likely.
>
> Where can I find what characters are being used to do the line breaks? In a dashboard the first line appears but when you select the cell the whole description appears. Pasting into Excel (as opposed to Copy to Excel option) messes up, but if the Copy to Excel option is available it does not.
>

I had the same problem and now at work I was able to look at my BAQ. I
defined a new item and it looks like this:

Replace(ShipDtl.LineDesc, chr(13)," _ " )

It's from a different table but it seemed to take care of the issue. I
don't have DMT so this is stripping off characters from user input -
probably pasted in from Excel.

Cheers,

Mark W.



Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.



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

In Crystal and VB there is a Split function that allows you to split up a string.

How can I do the same thing in a BAQ? I want to split Part.Description so that I only get the first line of the description. If I copy the full description into Excel the line breaks in a multiline description mess up the paste and put the data in the wrong cells.

- Neil B
3
Hi Neil,

The ENTRY function will return a segment separated a particular character:

SLine = ENTRY(1, LIneDescription, "\r")

But you may just want to replace all of the \n or \r with a space to
preserve the rest of description.

Mark W.

On Aug 30, 2012, at 6:57 PM, "nbuckman@..." <
nbuckman@...> wrote:



Hello,

In Crystal and VB there is a Split function that allows you to split up a
string.

How can I do the same thing in a BAQ? I want to split Part.Description so
that I only get the first line of the description. If I copy the full
description into Excel the line breaks in a multiline description mess up
the paste and put the data in the wrong cells.

- Neil B




[Non-text portions of this message have been removed]
4
Much thanks Mark,

I will give it a try.

- Neil



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Friday, 31 August 2012 12:16 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How to split up text

Hi Neil,

The ENTRY function will return a segment separated a particular character:

SLine = ENTRY(1, LIneDescription, "\r")

But you may just want to replace all of the \n or \r with a space to preserve the rest of description.

Mark W.

On Aug 30, 2012, at 6:57 PM, "nbuckman@..." < nbuckman@...> wrote:



Hello,

In Crystal and VB there is a Split function that allows you to split up a string.

How can I do the same thing in a BAQ? I want to split Part.Description so that I only get the first line of the description. If I copy the full description into Excel the line breaks in a multiline description mess up the paste and put the data in the wrong cells.

- Neil B




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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links




Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.
5
Hi Mark,

I got it to work using this: Entry(1,Part.PartDescription ,chr(10))

This returned only the first line of the part description.

Thanks again,

- Neil



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Friday, 31 August 2012 12:16 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How to split up text

Hi Neil,

The ENTRY function will return a segment separated a particular character:

SLine = ENTRY(1, LIneDescription, "\r")

But you may just want to replace all of the \n or \r with a space to preserve the rest of description.

Mark W.

On Aug 30, 2012, at 6:57 PM, "nbuckman@..." < nbuckman@...> wrote:



Hello,

In Crystal and VB there is a Split function that allows you to split up a string.

How can I do the same thing in a BAQ? I want to split Part.Description so that I only get the first line of the description. If I copy the full description into Excel the line breaks in a multiline description mess up the paste and put the data in the wrong cells.

- Neil B




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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links




Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.
6
Back again,

Yes the chr(10) worked for items I had uploaded with DMT, but manually entered items I am unable to split using that, "\r", "\n" or anything else that seems likely.

Where can I find what characters are being used to do the line breaks? In a dashboard the first line appears but when you select the cell the whole description appears. Pasting into Excel (as opposed to Copy to Excel option) messes up, but if the Copy to Excel option is available it does not.

- Neil


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Neil Buckman
Sent: Friday, 31 August 2012 1:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to split up text



Hi Mark,

I got it to work using this: Entry(1,Part.PartDescription ,chr(10))

This returned only the first line of the part description.

Thanks again,

- Neil

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Mark Wonsil
Sent: Friday, 31 August 2012 12:16 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] How to split up text

Hi Neil,

The ENTRY function will return a segment separated a particular character:

SLine = ENTRY(1, LIneDescription, "\r")

But you may just want to replace all of the \n or \r with a space to preserve the rest of description.

Mark W.

On Aug 30, 2012, at 6:57 PM, "nbuckman@...<mailto:nbuckman%40ymail.com>" < nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au>> wrote:

Hello,

In Crystal and VB there is a Split function that allows you to split up a string.

How can I do the same thing in a BAQ? I want to split Part.Description so that I only get the first line of the description. If I copy the full description into Excel the line breaks in a multiline description mess up the paste and put the data in the wrong cells.

- Neil B

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.



[Non-text portions of this message have been removed]
7
Good Day Neil,

> Yes the chr(10) worked for items I had uploaded with DMT, but manually entered items I am unable to split using that, "\r", "\n" or anything else that seems likely.
>
> Where can I find what characters are being used to do the line breaks? In a dashboard the first line appears but when you select the cell the whole description appears. Pasting into Excel (as opposed to Copy to Excel option) messes up, but if the Copy to Excel option is available it does not.
>

I had the same problem and now at work I was able to look at my BAQ. I
defined a new item and it looks like this:

Replace(ShipDtl.LineDesc, chr(13)," _ " )

It's from a different table but it seemed to take care of the issue. I
don't have DMT so this is stripping off characters from user input -
probably pasted in from Excel.

Cheers,

Mark W.
8
BTW, I was giving you C# syntax, the equivalent Progress is "~r" and "~n"

Too many Lamn Danguages...

Best,

Mark W.