Todd,
This worked just fine!!! I just checked it with the bar code reader.
Thank you.
Mike Tonoyan
This worked just fine!!! I just checked it with the bar code reader.
Thank you.
Mike Tonoyan
----- Original Message -----
From: "Todd Caughey" <caugheyt@...>
To: <vantage@yahoogroups.com>
Sent: Monday, April 11, 2005 10:11 AM
Subject: RE: [Vantage] Report Builder LOOP
>
> Like BC-PartNum = REPLACE(PartNum,'#','/C') which replaces all occurances
> of single # with /C ? One caution - be sure to size BC-PartNum larger
> than PartNum accordgin to he max number of # expected since you are
> replacing 2 characters for 1.
> -Todd C.
>
> -----Original Message-----
> From: Mike Tonoyan [mailto:miket@...]
> Sent: Monday, April 11, 2005 1:48 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Report Builder LOOP
>
>
> This is what I want to do:
> Add a Bar-Coded Part Number in the report and substitute the "#" (hash)
> character with "/C" if applicable, if not leave the same character.
>
> Mike T.
>
>
>
> ----- Original Message -----
> From: "Todd Caughey" <caugheyt@...>
> To: <vantage@yahoogroups.com>
> Sent: Monday, April 11, 2005 9:04 AM
> Subject: RE: [Vantage] Report Builder LOOP
>
>
>>
>> Do you have a closer example of the source string and what you are trying
>> to end up with? Between the SUBSTRING, INDEX, REPLACE and REPLACE-INDEX
>> functions I have never had a need for a loop mechanism.
>> -Todd C.
>>
>> -----Original Message-----
>> From: miket91326 [mailto:miket@...]
>> Sent: Monday, April 11, 2005 12:02 PM
>> To: vantage@yahoogroups.com
>> Subject: [Vantage] Report Builder LOOP
>>
>>
>>
>> Is there a way to create a LOOP in a RB report to go through a part
>> number and substitute some characters with something else?
>> I tried:
>> DO i=1 to PN_Length
>> IIF(ASC(SUBSTRING(.......)))
>> END
>> which gave me an error.
>> Thank you in advance.
>>
>> Mike Tonoyan / Sales Manager
>> All American Products Co.
>> miket@...
>>
>>
>>
>>
>>
>>
>> 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
>>
>>
>>
>> _____
>>
>> Yahoo! Groups Links
>>
>>
>> * To visit your group on the web, go to:
>> http://groups.yahoo.com/group/vantage/
>>
>>
>> * To unsubscribe from this group, send an email to:
>> vantage-unsubscribe@yahoogroups.com
>> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>>
>>
>> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
>> < http://docs.yahoo.com/info/terms/> .
>>
>>
>>
>>
>> [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/links
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>
>
>
> 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
>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [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/links
> Yahoo! Groups Links
>
>
>
>
>
>