Report Builder: How do you search for specific text in a strin

system · September 29, 2006, 4:02pm

I tried this fix first and it worked perfectly. Thanks so much!!!!

--- In vantage@yahoogroups.com, "Shirley Graver" <shirleyg@...>
wrote:

>
> Theresa,
> I use the following to count "CURE" in comments of the RMA

module

>
> IIF(INDEX(Note,'CURE') >0 , 1 ,0)
>
> to break it down, Index(Note,'Cure') will return a value

if "CURE" is

> found in the field "NOTE". Since I only want to count the

occurance of

> "CURE" once if the value is greater than "0" then it generates

a "1". I

> then count up all the One's to give me how many times "CURE" was

an issue.

> Then I use FILL(">",CNTCUREyr) to generate a horizontal bar

chart. You have

> to create a formula for each specific item you're looking for.
>
> Shirley Graver
> Systems Administrator
> Rubber Associates Inc.
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> rfc822 Compliance issue From: added by system POTENTIAL SPAM
> Sent: Friday, September 29, 2006 9:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder: How do you search for specific

text in a

> string field
>
>
>
> I am writing a Report Builder report that needs to filter on the
> ChgLog LogText field. What I want to do is identify any Log Text
> field that contains the phrase "New Record". It does not appear at
> any particular startpoint in the field, so I can't really specify

what

> character to start at. I just want it to search the whole string

for

> the substring. Does anyone know how to do this?
>
> Thanks,
> Theresa Pancoast
> FS-Elliott Co., LLC
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · September 29, 2006, 9:54am

I am writing a Report Builder report that needs to filter on the
ChgLog LogText field. What I want to do is identify any Log Text
field that contains the phrase "New Record". It does not appear at
any particular startpoint in the field, so I can't really specify what
character to start at. I just want it to search the whole string for
the substring. Does anyone know how to do this?

Thanks,
Theresa Pancoast
FS-Elliott Co., LLC

system · September 29, 2006, 10:09am

Theresa,
I use the following to count "CURE" in comments of the RMA module

IIF(INDEX(Note,'CURE') >0 , 1 ,0)

to break it down, Index(Note,'Cure') will return a value if "CURE" is
found in the field "NOTE". Since I only want to count the occurance of
"CURE" once if the value is greater than "0" then it generates a "1". I
then count up all the One's to give me how many times "CURE" was an issue.
Then I use FILL(">",CNTCUREyr) to generate a horizontal bar chart. You have
to create a formula for each specific item you're looking for.

Shirley Graver
Systems Administrator
Rubber Associates Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
rfc822 Compliance issue From: added by system POTENTIAL SPAM
Sent: Friday, September 29, 2006 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder: How do you search for specific text in a
string field

I am writing a Report Builder report that needs to filter on the
ChgLog LogText field. What I want to do is identify any Log Text
field that contains the phrase "New Record". It does not appear at
any particular startpoint in the field, so I can't really specify what
character to start at. I just want it to search the whole string for
the substring. Does anyone know how to do this?

Thanks,
Theresa Pancoast
FS-Elliott Co., LLC

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

system · September 29, 2006, 10:26am

Performance will suffer a tiny bit but you can set a formula field to find the Index position of the search phrase in the string and if > 0 you can set a true/false value. Then in the filter select for "True" on that field. Because the text field is not part of a key anyway you are not giving up a lot performance wise.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of tlp2120
Sent: Friday, September 29, 2006 8:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder: How do you search for specific text in a string field

I am writing a Report Builder report that needs to filter on the
ChgLog LogText field. What I want to do is identify any Log Text
field that contains the phrase "New Record". It does not appear at
any particular startpoint in the field, so I can't really specify what
character to start at. I just want it to search the whole string for
the substring. Does anyone know how to do this?

Thanks,
Theresa Pancoast
FS-Elliott Co., LLC

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

system · September 29, 2006, 3:46pm

Thanks for the suggestion. I will try this.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> Performance will suffer a tiny bit but you can set a formula field
to find the Index position of the search phrase in the string and if
> 0 you can set a true/false value. Then in the filter select
for "True" on that field. Because the text field is not part of a
key anyway you are not giving up a lot performance wise.
> -Todd C.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of tlp2120
> Sent: Friday, September 29, 2006 8:52 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder: How do you search for specific
text in a string field
>
>
>
> I am writing a Report Builder report that needs to filter on the
> ChgLog LogText field. What I want to do is identify any Log Text
> field that contains the phrase "New Record". It does not appear at
> any particular startpoint in the field, so I can't really specify
what
> character to start at. I just want it to search the whole string
for
> the substring. Does anyone know how to do this?
>
> Thanks,
> Theresa Pancoast
> FS-Elliott Co., LLC
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · September 29, 2006, 3:47pm

Thanks, I will try this!

--- In vantage@yahoogroups.com, "Shirley Graver" <shirleyg@...>
wrote: