Search for <CR> in Description

Most Windows based systems will us CR LF (Carriage Return, Line Feed).

As Jose suggested, using the Chr() function can help find them. Chr(13) is Carriage Return, Chr(10) is Line Feed.

I've had success pasting in to Notepad++ and using the "Show Symbols" selections under View to determine exactly what characters I'm looking for whenever there's a question.

--- In vantage@yahoogroups.com, "Len Hartka" <len.hartka@...> wrote:
>
> Good Day:
>
> RE: Search for <CR> in Description
>
> We have some carriage returns, <CR>, in some of our
> Part:Descriptions.
>
> Using a BAQ, I was able to find other 'special characters" with a
> simple *[spec character]* search on a BAQ, but that did not work for
> a <CR>.
>
> The <CR> just shows up as a little box when the description is shown
> on the screen.
>
> I could export to Excell and search there. I seem to recall you can
> use the ASCII number somehow.
>
> So, does anyone know how to do it in E9 or Excell - or WORD for that
> matter.
>
>
> len.hartka@...
> <blocked::blocked::mailto:len.hartka@...>
> Leonard C. Hartka, IS Project Manager\ERP Specialist
> Sun Automation Group
> 66 Loveton Circle
> Sparks, Md. 21152
> 410-329-3560 ext. 120
> 410-329-3564 FAX
> 443-255-7192 Work Cell
> len.hartka@...
> <blocked::blocked::mailto:len.hartka@...>
>
> www.Sunautomation.com <blocked::blocked::http://www.sunautomation.com/>
>
>
>
>
> **************************************************************
>
> Sun Automation Group
>
> Celebrating
>
> 25 Years of Service
>
> to the Corrugated Industry
>
> **************************************************************
>
>
>
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
>
> [Non-text portions of this message have been removed]
>
Good Day:

RE: Search for <CR> in Description

We have some carriage returns, <CR>, in some of our
Part:Descriptions.

Using a BAQ, I was able to find other 'special characters" with a
simple *[spec character]* search on a BAQ, but that did not work for
a <CR>.

The <CR> just shows up as a little box when the description is shown
on the screen.

I could export to Excell and search there. I seem to recall you can
use the ASCII number somehow.

So, does anyone know how to do it in E9 or Excell - or WORD for that
matter.


len.hartka@...
<blocked::blocked::mailto:len.hartka@...>
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...
<blocked::blocked::mailto:len.hartka@...>

www.Sunautomation.com <blocked::blocked::http://www.sunautomation.com/>




**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************




This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
~r will match a carriage return in ABL. That should do the trick.

On Fri, May 20, 2011 at 2:14 PM, Len Hartka <len.hartka@...>wrote:

>
>
> Good Day:
>
> RE: Search for <CR> in Description
>
> We have some carriage returns, <CR>, in some of our
> Part:Descriptions.
>
> Using a BAQ, I was able to find other 'special characters" with a
> simple *[spec character]* search on a BAQ, but that did not work for
> a <CR>.
>
> The <CR> just shows up as a little box when the description is shown
> on the screen.
>
> I could export to Excell and search there. I seem to recall you can
> use the ASCII number somehow.
>
> So, does anyone know how to do it in E9 or Excell - or WORD for that
> matter.
>
>
> len.hartka@...
> <blocked::blocked::mailto:len.hartka@...>
> Leonard C. Hartka, IS Project Manager\ERP Specialist
> Sun Automation Group
> 66 Loveton Circle
> Sparks, Md. 21152
> 410-329-3560 ext. 120
> 410-329-3564 FAX
> 443-255-7192 Work Cell
> len.hartka@...
> <blocked::blocked::mailto:len.hartka@...>
>
> www.Sunautomation.com <blocked::blocked::http://www.sunautomation.com/>
>
> **************************************************************
>
> Sun Automation Group
>
> Celebrating
>
> 25 Years of Service
>
> to the Corrugated Industry
>
> **************************************************************
>
> This e-mail and any attachments may contain proprietary and/or confidential
> information. If you are not the intended recipient, please notify the sender
> immediately by reply e-mail or at 410-472-2900 and then delete the message
> without using, disseminating, or copying this message or any portion
> thereof. With e-mail communications you are urged to protect against
> viruses.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
In excel is Chr(##)

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Fri, May 20, 2011 at 2:14 PM, Len Hartka <len.hartka@...>wrote:

>
>
> Good Day:
>
> RE: Search for <CR> in Description
>
> We have some carriage returns, <CR>, in some of our
> Part:Descriptions.
>
> Using a BAQ, I was able to find other 'special characters" with a
> simple *[spec character]* search on a BAQ, but that did not work for
> a <CR>.
>
> The <CR> just shows up as a little box when the description is shown
> on the screen.
>
> I could export to Excell and search there. I seem to recall you can
> use the ASCII number somehow.
>
> So, does anyone know how to do it in E9 or Excell - or WORD for that
> matter.
>
>
> len.hartka@...
> <blocked::blocked::mailto:len.hartka@...>
> Leonard C. Hartka, IS Project Manager\ERP Specialist
> Sun Automation Group
> 66 Loveton Circle
> Sparks, Md. 21152
> 410-329-3560 ext. 120
> 410-329-3564 FAX
> 443-255-7192 Work Cell
> len.hartka@...
> <blocked::blocked::mailto:len.hartka@...>
>
> www.Sunautomation.com <blocked::blocked::http://www.sunautomation.com/>
>
> **************************************************************
>
> Sun Automation Group
>
> Celebrating
>
> 25 Years of Service
>
> to the Corrugated Industry
>
> **************************************************************
>
> This e-mail and any attachments may contain proprietary and/or confidential
> information. If you are not the intended recipient, please notify the sender
> immediately by reply e-mail or at 410-472-2900 and then delete the message
> without using, disseminating, or copying this message or any portion
> thereof. With e-mail communications you are urged to protect against
> viruses.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
^p is the paragraph mark in Word, you can find other special characters in Word using the Find option, press the MORE button and then the SPECIAL button...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Friday, May 20, 2011 1:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Search for <CR> in Description



Good Day:

RE: Search for <CR> in Description

We have some carriage returns, <CR>, in some of our
Part:Descriptions.

Using a BAQ, I was able to find other 'special characters" with a
simple *[spec character]* search on a BAQ, but that did not work for
a <CR>.

The <CR> just shows up as a little box when the description is shown
on the screen.

I could export to Excell and search there. I seem to recall you can
use the ASCII number somehow.

So, does anyone know how to do it in E9 or Excell - or WORD for that
matter.


len.hartka@...<mailto:len.hartka%40sunautomation.com>
<blocked::blocked::mailto:len.hartka@...<mailto:len.hartka%40sunautomation.com>>
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...<mailto:len.hartka%40sunautomation.com>
<blocked::blocked::mailto:len.hartka@...<mailto:len.hartka%40sunautomation.com>>

www.Sunautomation.com<http://www.Sunautomation.com> <blocked::blocked::http://www.sunautomation.com/>

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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



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