OT-Crystal Question

system · October 14, 2002, 7:04pm

No, that title's reserved for Thad Jacobs. But thanks!

Troy Funte
Liberty Electronics

----- Original Message -----
From: David M Gartner
To: vantage@yahoogroups.com
Sent: Monday, October 14, 2002 6:36 PM
Subject: RE: [Vantage] OT-Crystal Question

Normally more reserved but....
YOU THE MAN!
David Gartner
EPG Companies Inc.
Vantage 5.20.210, Progress 9.1D
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, October 14, 2002 5:11 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] OT-Crystal Question

Try this...

IF {Part.TypeCode} = "P"
THEN Right({Part.PartNum},Length({Part.PartNum})-4)
ELSE {Part.PartNum}

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

Yahoo! Groups Sponsor
ADVERTISEMENT

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

system · October 14, 2002, 4:55pm

Crystal gurus....

I am guessing/hoping that a string field can be "trimmed" when displaying.
All I want is:

IF {Part.TypeCode} = "P"
THEN
({Part.PartNum} start displaying at the 5 character)
ELSE
{Part.PartNum}
If it helps the 4th character is a hyphen.

Thanks for any help you all can give.

David Gartner
EPG Companies Inc.
Vantage 5.20.210, Progress 9.1D

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

system · October 14, 2002, 5:19pm

David,
If you created a formula like this:

IF {Part.TypeCode} = "P"
THEN Left({Part.PartNum},5)
ELSE {Part.PartNum}

Troy

----- Original Message -----
From: David M Gartner
To: Vantage@Yahoogroups. Com
Sent: Monday, October 14, 2002 4:55 PM
Subject: [Vantage] OT-Crystal Question

Crystal gurus....

I am guessing/hoping that a string field can be "trimmed" when displaying.
All I want is:

IF {Part.TypeCode} = "P"
THEN
({Part.PartNum} start displaying at the 5 character)
ELSE
{Part.PartNum}
If it helps the 4th character is a hyphen.

Thanks for any help you all can give.

David Gartner
EPG Companies Inc.
Vantage 5.20.210, Progress 9.1D

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

Yahoo! Groups Sponsor
ADVERTISEMENT

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

system · October 14, 2002, 5:57pm

Thanks Troy,

This formula would only give me the first five characters, right? To be a
little clearer, I'm looking for everything after the fourth character, (5th
and on).

Ex. Part.PartNum = ABC-123456789
Display only = 123456789
David Gartner
EPG Companies Inc.
Vantage 5.20.210, Progress 9.1D

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, October 14, 2002 4:20 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] OT-Crystal Question

David,
If you created a formula like this:

IF {Part.TypeCode} = "P"
THEN Left({Part.PartNum},5)
ELSE {Part.PartNum}

Troy

----- Original Message -----
From: David M Gartner
To: Vantage@Yahoogroups. Com
Sent: Monday, October 14, 2002 4:55 PM
Subject: [Vantage] OT-Crystal Question

Crystal gurus....

I am guessing/hoping that a string field can be "trimmed" when
displaying.
All I want is:

IF {Part.TypeCode} = "P"
THEN
({Part.PartNum} start displaying at the 5 character)
ELSE
{Part.PartNum}
If it helps the 4th character is a hyphen.

Thanks for any help you all can give.

David Gartner
EPG Companies Inc.
Vantage 5.20.210, Progress 9.1D

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

system · October 14, 2002, 6:10pm

Try this...

IF {Part.TypeCode} = "P"
THEN Right({Part.PartNum},Length({Part.PartNum})-4)
ELSE {Part.PartNum}

----- Original Message -----
From: David M Gartner
To: vantage@yahoogroups.com
Sent: Monday, October 14, 2002 5:57 PM
Subject: RE: [Vantage] OT-Crystal Question

Thanks Troy,

This formula would only give me the first five characters, right? To be a
little clearer, I'm looking for everything after the fourth character, (5th
and on).

Ex. Part.PartNum = ABC-123456789
Display only = 123456789
David Gartner
EPG Companies Inc.
Vantage 5.20.210, Progress 9.1D

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, October 14, 2002 4:20 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] OT-Crystal Question

David,
If you created a formula like this:

IF {Part.TypeCode} = "P"
THEN Left({Part.PartNum},5)
ELSE {Part.PartNum}

Troy

----- Original Message -----
From: David M Gartner
To: Vantage@Yahoogroups. Com
Sent: Monday, October 14, 2002 4:55 PM
Subject: [Vantage] OT-Crystal Question

Crystal gurus....

I am guessing/hoping that a string field can be "trimmed" when
displaying.
All I want is:

IF {Part.TypeCode} = "P"
THEN
({Part.PartNum} start displaying at the 5 character)
ELSE
{Part.PartNum}
If it helps the 4th character is a hyphen.

Thanks for any help you all can give.

David Gartner
EPG Companies Inc.
Vantage 5.20.210, Progress 9.1D

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

Yahoo! Groups Sponsor
ADVERTISEMENT

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

system · October 14, 2002, 6:36pm

Normally more reserved but....
YOU THE MAN!
David Gartner
EPG Companies Inc.
Vantage 5.20.210, Progress 9.1D
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, October 14, 2002 5:11 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] OT-Crystal Question

Try this...

IF {Part.TypeCode} = "P"
THEN Right({Part.PartNum},Length({Part.PartNum})-4)
ELSE {Part.PartNum}

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