Searching a string of chracters for a match in a configurator on

Yahoo Archive
1
This is a good reference to have.

http://communities.progress.com/pcom/docs/DOC-16296



________________________________
From: Gibby <guyguy50@...>
To: vantage@yahoogroups.com
Sent: Friday, March 16, 2012 1:09 PM
Subject: [Vantage] Re: Searching a string of chracters for a match in a configurator on leave statement

Thanks, that works beautifully for what I was trying to do.
You don't happen to know where can I get a reference for progress/ABL code that I'm able to use within the product configurator on-leave code? Currently using cookie cutter code and would like to have a reference for a function list so I don't have to.



--- In vantage@yahoogroups.com, "jckinneman" <jckinneman@...> wrote:
>
> If you are working within the product configurator you will need to use progress/ABL code in the on-leave code. To locate if a string contains another string.
>
> index(sourceString,itemtofind) This will return an integer with the location of the itemtofind. 0 if item is not found.
>
> index("ABCEDF","D") would return 5.
>
> Jim Kinneman
> Encompass Solutions, Inc
>
> --- In vantage@yahoogroups.com, "Gibby" <guyguy50@> wrote:
> >
> > I've a question to see if it is possible to search within a string for matching cases. For example say we have in our configurator a suffix box that could have multiple cases within it such as: A - for as A part B - for a B part & C for a C part etc...
> >
> > So they can enter ABC AB AC B BC... Now simple check boxes or if statments work ok until you end up with say a dozen suffixes.
> >
> > What I want to do is if their is a function I can use that would look for the "D" if they entered "ABDEF" in the field. Substring is out because what if they entered "ABCDEF"
> >
> > Any suggestions?
> >
>




------------------------------------

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/.%c2%a0
(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]
2
I've a question to see if it is possible to search within a string for matching cases. For example say we have in our configurator a suffix box that could have multiple cases within it such as: A - for as A part B - for a B part & C for a C part etc...

So they can enter ABC AB AC B BC... Now simple check boxes or if statments work ok until you end up with say a dozen suffixes.

What I want to do is if their is a function I can use that would look for the "D" if they entered "ABDEF" in the field. Substring is out because what if they entered "ABCDEF"

Any suggestions?
3
I'm not sure if I follow your question, but you can check if a string contains certain character(s) if thats what you are trying to do.


Dim str As String
 If str.Contains("D") Then
   'do something
End If



________________________________
From: Gibby <guyguy50@...>
To: vantage@yahoogroups.com
Sent: Friday, March 16, 2012 10:31 AM
Subject: [Vantage] Searching a string of chracters for a match in a configurator on leave statement

I've a question to see if it is possible to search within a string for matching cases. For example say we have in our configurator a suffix box that could have multiple cases within it such as: A - for as A part B - for a B part & C for a C part etc...

So they can enter ABC AB AC B BC... Now simple check boxes or if statments work ok until you end up with say a dozen suffixes.

What I want to do is if their is a function I can use that would look for the "D" if they entered "ABDEF" in the field. Substring is out because what if they entered "ABCDEF"

Any suggestions?



------------------------------------

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/.%c2%a0
(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
That is what I was looking for. I'll give that a try. Thanks.

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> I'm not sure if I follow your question, but you can check if a string contains certain character(s) if thats what you are trying to do.
>
>
> Dim str As String
> Â If str.Contains("D") Then
> Â Â Â 'do something
> End If
>
>
>
> ________________________________
> From: Gibby <guyguy50@...>
> To: vantage@yahoogroups.com
> Sent: Friday, March 16, 2012 10:31 AM
> Subject: [Vantage] Searching a string of chracters for a match in a configurator on leave statement
>
> I've a question to see if it is possible to search within a string for matching cases. For example say we have in our configurator a suffix box that could have multiple cases within it such as: A - for as A part B - for a B part & C for a C part etc...
>
> So they can enter ABC AB AC B BC... Now simple check boxes or if statments work ok until you end up with say a dozen suffixes.
>
> What I want to do is if their is a function I can use that would look for the "D" if they entered "ABDEF" in the field. Substring is out because what if they entered "ABCDEF"
>
> Any suggestions?
>
>
>
> ------------------------------------
>
> 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/.%c2%a0
> (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]
>
5
If you are working within the product configurator you will need to use progress/ABL code in the on-leave code. To locate if a string contains another string.

index(sourceString,itemtofind) This will return an integer with the location of the itemtofind. 0 if item is not found.

index("ABCEDF","D") would return 5.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "Gibby" <guyguy50@...> wrote:
>
> I've a question to see if it is possible to search within a string for matching cases. For example say we have in our configurator a suffix box that could have multiple cases within it such as: A - for as A part B - for a B part & C for a C part etc...
>
> So they can enter ABC AB AC B BC... Now simple check boxes or if statments work ok until you end up with say a dozen suffixes.
>
> What I want to do is if their is a function I can use that would look for the "D" if they entered "ABDEF" in the field. Substring is out because what if they entered "ABCDEF"
>
> Any suggestions?
>
6
Thanks, that works beautifully for what I was trying to do.
You don't happen to know where can I get a reference for progress/ABL code that I'm able to use within the product configurator on-leave code? Currently using cookie cutter code and would like to have a reference for a function list so I don't have to.



--- In vantage@yahoogroups.com, "jckinneman" <jckinneman@...> wrote:
>
> If you are working within the product configurator you will need to use progress/ABL code in the on-leave code. To locate if a string contains another string.
>
> index(sourceString,itemtofind) This will return an integer with the location of the itemtofind. 0 if item is not found.
>
> index("ABCEDF","D") would return 5.
>
> Jim Kinneman
> Encompass Solutions, Inc
>
> --- In vantage@yahoogroups.com, "Gibby" <guyguy50@> wrote:
> >
> > I've a question to see if it is possible to search within a string for matching cases. For example say we have in our configurator a suffix box that could have multiple cases within it such as: A - for as A part B - for a B part & C for a C part etc...
> >
> > So they can enter ABC AB AC B BC... Now simple check boxes or if statments work ok until you end up with say a dozen suffixes.
> >
> > What I want to do is if their is a function I can use that would look for the "D" if they entered "ABDEF" in the field. Substring is out because what if they entered "ABCDEF"
> >
> > Any suggestions?
> >
>