Vantage - BAQ Calculated Field to remove 'space'

Yahoo Archive
1
Good Day:



Just good procedure to see what you will get, tests logic, how many Spaces?, etc.; i.e. avoid surprises.



Can’t change data unless set up as an updateable BAQ





Sun is on E9 Verion: 9.05.700C – SQL- Unidata - Enterprise-since 4/15/2012

Went live on 9.05.600B on 11/22/2010

Previously used M2K ( Manage 2000, ver 7.0 SP5) from 7/4/2001

Previously used INMASS ( 1998 )





Len



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, May 20, 2013 12:50 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage - BAQ Calculated Field to remove 'space'





Hi

What's is the purpose of trying in test? The BAQ can't change any data can it?

Chris Thompson

On 20 May 2013, at 17:37, "Len Hartka" <len.hartka@... <mailto:len.hartka%40sunautomation.com> > wrote:

> Good Day Chris:
>
>
>
> It is a calculated field.
>
>
>
> Business Activity Query >> Setup >> Business Activity Query >>…( start new BAQ)……..>> Display Tab >> Column Select >> Calculator Icon in the center of the screen below Down-Arrow icon. >>> Add new >> Character >> Copy\ Paste in ( use [CTRL] V ) Might work, otherwise build as normal..
>
>
>
> Len
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Chris Thompson
> Sent: Monday, May 20, 2013 11:08 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Vantage - BAQ Calculated Field to remove 'space'
>
>
>
>
>
> Hi
>
> Where do I do that?
>
> In the BAQ designer?
>
> Chris Thompson
>
> On 20 May 2013, at 15:50, "Len Hartka" <len.hartka@... <mailto:len.hartka%40sunautomation.com> <mailto:len.hartka%40sunautomation.com> > wrote:
>
> > Good Day Chris:
> >
> > I do not know if this will work, but it is my guess. Do in
> > Test account first.
> >
> > Just to see how many and if any have two spaces at the end.
> >
> > First, do a query Select on calculation =
> > Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " "
> >
> > Then do a query Select on calculation =
> > Substring(Part.PartNum, (Length(Part.PartNum - 2),2) = " " ( two
> > spaces between " ")
> >
> > If Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " " Then
> > Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> > ,(Length(Part.PartNum - 1) ) ) Else If Substring(Part.PartNum,
> > (Length(Part.PartNum - 2),2 ) = " " Then
> > Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> > ,(Length(Part.PartNum - 2) ) ) Else Part.PartNum
> >
> > Code after "ELSE is to account for two spaces.
> > You could run them separately.
> >
> > I have not used this.
> >
> > May need to use "Substitute instead of Replace.
> >
> > TEST in test account. I assume Replace and Substitute do NOT
> > change the Part File - it is just a display string
> >
> > Then run yours.
> >
> > Len
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On Behalf
> > Of Chris Thompson
> > Sent: Monday, May 20, 2013 10:08 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Vantage - BAQ Calculated Field to remove 'space'
> >
> > Hi,
> >
> > I need to write a BAQ that will take the part number field and put a _
> > underscore anywhere there is a space.
> >
> > For example, P10 50-50 to become P10_50-50.
> >
> > I have used this ...
> >
> > REPLACE(PartQty.PartNum," ","_")
> >
> > ... which works well.
> >
> > However, it would appear that some part numbers (not all) had spaces
> > after them when they were created.
> >
> > We dont' spot this usually, but because it have asked it to replace all
> > spaces with underscores, it is highlighted.
> >
> > Is there any way I can make a calculated field that will do the REPLACE
> > above, but then remove and _ underscores that appear at the end of a
> > part number?
> >
> > Thanks,
> >
> > CHRIS
> >
> > [Non-text portions of this message have been removed]
> >
> > 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]
>
>
>
>
>
> 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]





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]
2
Hi,

I need to write a BAQ that will take the part number field and put a _ underscore anywhere there is a space.

For example, P10 50-50 to become P10_50-50.

I have used this ...


REPLACE(PartQty.PartNum," ","_")


... which works well.


However, it would appear that some part numbers (not all) had spaces after them when they were created.

We dont' spot this usually, but because it have asked it to replace all spaces with underscores, it is highlighted.

Is there any way I can make a calculated field that will do the REPLACE above, but then remove and _ underscores that appear at the end of a part number?

Thanks,

CHRIS

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

REPLACE(TRIM(PartQty.PartNum)," ","_")




________________________________
From: Chris Thompson <chriselectrix@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, May 20, 2013 10:07 AM
Subject: [Vantage] Vantage - BAQ Calculated Field to remove 'space'


Hi,

I need to write a BAQ that will take the part number field and put a _ underscore anywhere there is a space.

For example, P10 50-50 to become P10_50-50.

I have used this ...


REPLACE(PartQty.PartNum," ","_")


... which works well.


However, it would appear that some part numbers (not all) had spaces after them when they were created.

We dont' spot this usually, but because it have asked it to replace all spaces with underscores, it is highlighted.

Is there any way I can make a calculated field that will do the REPLACE above, but then remove and _ underscores that appear at the end of a part number?

Thanks,

CHRIS

[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



[Non-text portions of this message have been removed]
4
Good Day Chris:





I do not know if this will work, but it is my guess. Do in
Test account first.



Just to see how many and if any have two spaces at the end.

First, do a query Select on calculation =
Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " "

Then do a query Select on calculation =
Substring(Part.PartNum, (Length(Part.PartNum - 2),2) = " " ( two
spaces between " ")





If Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " " Then
Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
,(Length(Part.PartNum - 1) ) ) Else If Substring(Part.PartNum,
(Length(Part.PartNum - 2),2 ) = " " Then
Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
,(Length(Part.PartNum - 2) ) ) Else Part.PartNum

Code after "ELSE is to account for two spaces.
You could run them separately.





I have not used this.

May need to use "Substitute instead of Replace.

TEST in test account. I assume Replace and Substitute do NOT
change the Part File - it is just a display string



Then run yours.




Len



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Monday, May 20, 2013 10:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - BAQ Calculated Field to remove 'space'





Hi,

I need to write a BAQ that will take the part number field and put a _
underscore anywhere there is a space.

For example, P10 50-50 to become P10_50-50.

I have used this ...

REPLACE(PartQty.PartNum," ","_")

... which works well.

However, it would appear that some part numbers (not all) had spaces
after them when they were created.

We dont' spot this usually, but because it have asked it to replace all
spaces with underscores, it is highlighted.

Is there any way I can make a calculated field that will do the REPLACE
above, but then remove and _ underscores that appear at the end of a
part number?

Thanks,

CHRIS

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





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]
5
Hi

Where do I do that?

In the BAQ designer?

Chris Thompson

On 20 May 2013, at 15:50, "Len Hartka" <len.hartka@...> wrote:

> Good Day Chris:
>
> I do not know if this will work, but it is my guess. Do in
> Test account first.
>
> Just to see how many and if any have two spaces at the end.
>
> First, do a query Select on calculation =
> Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " "
>
> Then do a query Select on calculation =
> Substring(Part.PartNum, (Length(Part.PartNum - 2),2) = " " ( two
> spaces between " ")
>
> If Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " " Then
> Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> ,(Length(Part.PartNum - 1) ) ) Else If Substring(Part.PartNum,
> (Length(Part.PartNum - 2),2 ) = " " Then
> Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> ,(Length(Part.PartNum - 2) ) ) Else Part.PartNum
>
> Code after "ELSE is to account for two spaces.
> You could run them separately.
>
> I have not used this.
>
> May need to use "Substitute instead of Replace.
>
> TEST in test account. I assume Replace and Substitute do NOT
> change the Part File - it is just a display string
>
> Then run yours.
>
> Len
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Chris Thompson
> Sent: Monday, May 20, 2013 10:08 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vantage - BAQ Calculated Field to remove 'space'
>
> Hi,
>
> I need to write a BAQ that will take the part number field and put a _
> underscore anywhere there is a space.
>
> For example, P10 50-50 to become P10_50-50.
>
> I have used this ...
>
> REPLACE(PartQty.PartNum," ","_")
>
> ... which works well.
>
> However, it would appear that some part numbers (not all) had spaces
> after them when they were created.
>
> We dont' spot this usually, but because it have asked it to replace all
> spaces with underscores, it is highlighted.
>
> Is there any way I can make a calculated field that will do the REPLACE
> above, but then remove and _ underscores that appear at the end of a
> part number?
>
> Thanks,
>
> CHRIS
>
> [Non-text portions of this message have been removed]
>
> 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]
6
Good Day Chris:



It is a calculated field.



Business Activity Query >> Setup >> Business Activity Query >>…( start new BAQ)……..>> Display Tab >> Column Select >> Calculator Icon in the center of the screen below Down-Arrow icon. >>> Add new >> Character >> Copy\ Paste in ( use [CTRL] V ) Might work, otherwise build as normal..



Len



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, May 20, 2013 11:08 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage - BAQ Calculated Field to remove 'space'





Hi

Where do I do that?

In the BAQ designer?

Chris Thompson

On 20 May 2013, at 15:50, "Len Hartka" <len.hartka@... <mailto:len.hartka%40sunautomation.com> > wrote:

> Good Day Chris:
>
> I do not know if this will work, but it is my guess. Do in
> Test account first.
>
> Just to see how many and if any have two spaces at the end.
>
> First, do a query Select on calculation =
> Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " "
>
> Then do a query Select on calculation =
> Substring(Part.PartNum, (Length(Part.PartNum - 2),2) = " " ( two
> spaces between " ")
>
> If Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " " Then
> Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> ,(Length(Part.PartNum - 1) ) ) Else If Substring(Part.PartNum,
> (Length(Part.PartNum - 2),2 ) = " " Then
> Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> ,(Length(Part.PartNum - 2) ) ) Else Part.PartNum
>
> Code after "ELSE is to account for two spaces.
> You could run them separately.
>
> I have not used this.
>
> May need to use "Substitute instead of Replace.
>
> TEST in test account. I assume Replace and Substitute do NOT
> change the Part File - it is just a display string
>
> Then run yours.
>
> Len
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
> Of Chris Thompson
> Sent: Monday, May 20, 2013 10:08 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Vantage - BAQ Calculated Field to remove 'space'
>
> Hi,
>
> I need to write a BAQ that will take the part number field and put a _
> underscore anywhere there is a space.
>
> For example, P10 50-50 to become P10_50-50.
>
> I have used this ...
>
> REPLACE(PartQty.PartNum," ","_")
>
> ... which works well.
>
> However, it would appear that some part numbers (not all) had spaces
> after them when they were created.
>
> We dont' spot this usually, but because it have asked it to replace all
> spaces with underscores, it is highlighted.
>
> Is there any way I can make a calculated field that will do the REPLACE
> above, but then remove and _ underscores that appear at the end of a
> part number?
>
> Thanks,
>
> CHRIS
>
> [Non-text portions of this message have been removed]
>
> 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]





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]
7
Hi

What's is the purpose of trying in test? The BAQ can't change any data can it?

Chris Thompson

On 20 May 2013, at 17:37, "Len Hartka" <len.hartka@...> wrote:

> Good Day Chris:
>
>
>
> It is a calculated field.
>
>
>
> Business Activity Query >> Setup >> Business Activity Query >>…( start new BAQ)……..>> Display Tab >> Column Select >> Calculator Icon in the center of the screen below Down-Arrow icon. >>> Add new >> Character >> Copy\ Paste in ( use [CTRL] V ) Might work, otherwise build as normal..
>
>
>
> Len
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
> Sent: Monday, May 20, 2013 11:08 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Vantage - BAQ Calculated Field to remove 'space'
>
>
>
>
>
> Hi
>
> Where do I do that?
>
> In the BAQ designer?
>
> Chris Thompson
>
> On 20 May 2013, at 15:50, "Len Hartka" <len.hartka@... <mailto:len.hartka%40sunautomation.com> > wrote:
>
> > Good Day Chris:
> >
> > I do not know if this will work, but it is my guess. Do in
> > Test account first.
> >
> > Just to see how many and if any have two spaces at the end.
> >
> > First, do a query Select on calculation =
> > Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " "
> >
> > Then do a query Select on calculation =
> > Substring(Part.PartNum, (Length(Part.PartNum - 2),2) = " " ( two
> > spaces between " ")
> >
> > If Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " " Then
> > Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> > ,(Length(Part.PartNum - 1) ) ) Else If Substring(Part.PartNum,
> > (Length(Part.PartNum - 2),2 ) = " " Then
> > Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> > ,(Length(Part.PartNum - 2) ) ) Else Part.PartNum
> >
> > Code after "ELSE is to account for two spaces.
> > You could run them separately.
> >
> > I have not used this.
> >
> > May need to use "Substitute instead of Replace.
> >
> > TEST in test account. I assume Replace and Substitute do NOT
> > change the Part File - it is just a display string
> >
> > Then run yours.
> >
> > Len
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
> > Of Chris Thompson
> > Sent: Monday, May 20, 2013 10:08 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Vantage - BAQ Calculated Field to remove 'space'
> >
> > Hi,
> >
> > I need to write a BAQ that will take the part number field and put a _
> > underscore anywhere there is a space.
> >
> > For example, P10 50-50 to become P10_50-50.
> >
> > I have used this ...
> >
> > REPLACE(PartQty.PartNum," ","_")
> >
> > ... which works well.
> >
> > However, it would appear that some part numbers (not all) had spaces
> > after them when they were created.
> >
> > We dont' spot this usually, but because it have asked it to replace all
> > spaces with underscores, it is highlighted.
> >
> > Is there any way I can make a calculated field that will do the REPLACE
> > above, but then remove and _ underscores that appear at the end of a
> > part number?
> >
> > Thanks,
> >
> > CHRIS
> >
> > [Non-text portions of this message have been removed]
> >
> > 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]
>
>
>
>
>
> 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]
8
>>What's is the purpose of trying in test?
>>The BAQ can't change any data can it?
PMJI... even though they don't change data, I will often work on BAQs in test. I find it easier to keep production cleaned up.

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi
>
> What's is the purpose of trying in test? The BAQ can't change any data can it?
>
> Chris Thompson
>
> On 20 May 2013, at 17:37, "Len Hartka" <len.hartka@...> wrote:
>
> > Good Day Chris:
> >
> >
> >
> > It is a calculated field.
> >
> >
> >
> > Business Activity Query >> Setup >> Business Activity Query >>…( start new BAQ)……..>> Display Tab >> Column Select >> Calculator Icon in the center of the screen below Down-Arrow icon. >>> Add new >> Character >> Copy\ Paste in ( use [CTRL] V ) Might work, otherwise build as normal..
> >
> >
> >
> > Len
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
> > Sent: Monday, May 20, 2013 11:08 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Vantage - BAQ Calculated Field to remove 'space'
> >
> >
> >
> >
> >
> > Hi
> >
> > Where do I do that?
> >
> > In the BAQ designer?
> >
> > Chris Thompson
> >
> > On 20 May 2013, at 15:50, "Len Hartka" <len.hartka@... <mailto:len.hartka%40sunautomation.com> > wrote:
> >
> > > Good Day Chris:
> > >
> > > I do not know if this will work, but it is my guess. Do in
> > > Test account first.
> > >
> > > Just to see how many and if any have two spaces at the end.
> > >
> > > First, do a query Select on calculation =
> > > Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " "
> > >
> > > Then do a query Select on calculation =
> > > Substring(Part.PartNum, (Length(Part.PartNum - 2),2) = " " ( two
> > > spaces between " ")
> > >
> > > If Substring(Part.PartNum, (Length(Part.PartNum - 1),1 ) = " " Then
> > > Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> > > ,(Length(Part.PartNum - 1) ) ) Else If Substring(Part.PartNum,
> > > (Length(Part.PartNum - 2),2 ) = " " Then
> > > Replace(Part.PartNum,Part.PartNum , Substring(Part.PartNum,1
> > > ,(Length(Part.PartNum - 2) ) ) Else Part.PartNum
> > >
> > > Code after "ELSE is to account for two spaces.
> > > You could run them separately.
> > >
> > > I have not used this.
> > >
> > > May need to use "Substitute instead of Replace.
> > >
> > > TEST in test account. I assume Replace and Substitute do NOT
> > > change the Part File - it is just a display string
> > >
> > > Then run yours.
> > >
> > > Len
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
> > > Of Chris Thompson
> > > Sent: Monday, May 20, 2013 10:08 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Vantage - BAQ Calculated Field to remove 'space'
> > >
> > > Hi,
> > >
> > > I need to write a BAQ that will take the part number field and put a _
> > > underscore anywhere there is a space.
> > >
> > > For example, P10 50-50 to become P10_50-50.
> > >
> > > I have used this ...
> > >
> > > REPLACE(PartQty.PartNum," ","_")
> > >
> > > ... which works well.
> > >
> > > However, it would appear that some part numbers (not all) had spaces
> > > after them when they were created.
> > >
> > > We dont' spot this usually, but because it have asked it to replace all
> > > spaces with underscores, it is highlighted.
> > >
> > > Is there any way I can make a calculated field that will do the REPLACE
> > > above, but then remove and _ underscores that appear at the end of a
> > > part number?
> > >
> > > Thanks,
> > >
> > > CHRIS
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > 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]
> >
> >
> >
> >
> >
> > 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]
>