Crystal Reports Character Field

Yahoo Archive
1
Very, very cool! Thank you so much!
Â
Dustin Biniek




________________________________
From: Linda Lowney <llowney@...>
To: vantage@yahoogroups.com
Sent: Wed, January 6, 2010 1:07:53 PM
Subject: RE: [Vantage] Crystal Reports Character Field

Â
Hi Dustin,

Try :

mid({FieldName} ,instr({FieldNam e},"StartDate" ,1)+9,10) ;

Replace the two occurrences of {FieldName} with your field name

Regards,

Linda

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of melissa hietala
Sent: Wednesday, January 06, 2010 1:48 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Crystal Reports Character Field

Hello all,

I have a character field pulled into a crystal report. What I need to
do is create a formula that will seach for a particular string of text
within the character field. For example, it would need to locate the
string "StartDate" within the character field. I would then need the
formula to return the following 10 characters that are displayed after
the string "StartDate". Hope this makes sense. Any thoughts on how
this can be accomplished?

Thanks,

Dustin Biniek
DustinB@ultramc. com <mailto:DustinB% 40ultramc. com>

[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]
2
Hello all,

I have a character field pulled into a crystal report. What I need to do is create a formula that will seach for a particular string of text within the character field. For example, it would need to locate the string "StartDate" within the character field. I would then need the formula to return the following 10 characters that are displayed after the string "StartDate". Hope this makes sense. Any thoughts on how this can be accomplished?

Thanks,

Dustin Biniek
DustinB@...




[Non-text portions of this message have been removed]
3
First I am using instr command to find where is the search character then I am using mid command to show characters from position x and length y.




________________________________
From: melissa hietala <kevmel822@...>
To: vantage@yahoogroups.com
Sent: Wed, January 6, 2010 12:47:45 PM
Subject: [Vantage] Crystal Reports Character Field

Â
Hello all,

I have a character field pulled into a crystal report. What I need to do is create a formula that will seach for a particular string of text within the character field. For example, it would need to locate the string "StartDate" within the character field. I would then need the formula to return the following 10 characters that are displayed after the string "StartDate". Hope this makes sense. Any thoughts on how this can be accomplished?

Thanks,

Dustin Biniek
DustinB@ultramc. com

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







[Non-text portions of this message have been removed]
4
First I am using instr command to find where is the search character then I am using mid command to show characters from position x and length y.




________________________________
From: melissa hietala <kevmel822@...>
To: vantage@yahoogroups.com
Sent: Wed, January 6, 2010 12:47:45 PM
Subject: [Vantage] Crystal Reports Character Field

Â
Hello all,

I have a character field pulled into a crystal report. What I need to do is create a formula that will seach for a particular string of text within the character field. For example, it would need to locate the string "StartDate" within the character field. I would then need the formula to return the following 10 characters that are displayed after the string "StartDate". Hope this makes sense. Any thoughts on how this can be accomplished?

Thanks,

Dustin Biniek
DustinB@ultramc. com

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







[Non-text portions of this message have been removed]
5
First I am using instr command to find where is the search character then I am using mid command to show characters from position x and length y.




________________________________
From: melissa hietala <kevmel822@...>
To: vantage@yahoogroups.com
Sent: Wed, January 6, 2010 12:47:45 PM
Subject: [Vantage] Crystal Reports Character Field

Â
Hello all,

I have a character field pulled into a crystal report. What I need to do is create a formula that will seach for a particular string of text within the character field. For example, it would need to locate the string "StartDate" within the character field. I would then need the formula to return the following 10 characters that are displayed after the string "StartDate". Hope this makes sense. Any thoughts on how this can be accomplished?

Thanks,

Dustin Biniek
DustinB@ultramc. com

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







[Non-text portions of this message have been removed]
6
First I am using instr command to find where is the search character then I am using mid command to show characters from position x and length y.




________________________________
From: melissa hietala <kevmel822@...>
To: vantage@yahoogroups.com
Sent: Wed, January 6, 2010 12:47:45 PM
Subject: [Vantage] Crystal Reports Character Field

Â
Hello all,

I have a character field pulled into a crystal report. What I need to do is create a formula that will seach for a particular string of text within the character field. For example, it would need to locate the string "StartDate" within the character field. I would then need the formula to return the following 10 characters that are displayed after the string "StartDate". Hope this makes sense. Any thoughts on how this can be accomplished?

Thanks,

Dustin Biniek
DustinB@ultramc. com

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







[Non-text portions of this message have been removed]
7
First I am using instr command to find where is the search character then I am using mid command to show characters from position x and length y.




________________________________
From: melissa hietala <kevmel822@...>
To: vantage@yahoogroups.com
Sent: Wed, January 6, 2010 12:47:45 PM
Subject: [Vantage] Crystal Reports Character Field

Â
Hello all,

I have a character field pulled into a crystal report. What I need to do is create a formula that will seach for a particular string of text within the character field. For example, it would need to locate the string "StartDate" within the character field. I would then need the formula to return the following 10 characters that are displayed after the string "StartDate". Hope this makes sense. Any thoughts on how this can be accomplished?

Thanks,

Dustin Biniek
DustinB@ultramc. com

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







[Non-text portions of this message have been removed]
8
Hi Dustin,



Try :



mid({FieldName},instr({FieldName},"StartDate",1)+9,10);



Replace the two occurrences of {FieldName} with your field name



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of melissa hietala
Sent: Wednesday, January 06, 2010 1:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Character Field





Hello all,

I have a character field pulled into a crystal report. What I need to
do is create a formula that will seach for a particular string of text
within the character field. For example, it would need to locate the
string "StartDate" within the character field. I would then need the
formula to return the following 10 characters that are displayed after
the string "StartDate". Hope this makes sense. Any thoughts on how
this can be accomplished?

Thanks,

Dustin Biniek
DustinB@... <mailto:DustinB%40ultramc.com>

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





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