Hi,
I have an HTML page with several controls including an EDIT BOX.
EDIT box is used to search PART numbers.
User can enter multiple Part numbers using "^" delimiter.
The length of the Part number varies.
I am able to replace '^' to ' OR ' and use that in my where clause.
Here is the code I am using to convert '^' to ' OR ' .


-SET &VALS = ∂
-SET &VALS2 = &VALS.LENGTH + 1365;
-SET &VALS3 = 'A' | &VALS2;
-SET &VALSX = STRREP(&VALS.LENGTH,&VALS,1,'^',6,''' OR ''',&VALS2,'&VALS3');
-SET &VALSX = TRUNCATE(&VALSX);
-SET &PART = &VALSX;



The issue I am facing now is that the length of the Input string could be more the 4096 characters and STRREP doesn't like that.
Not sure how to get around it.

How do I work around it?

Thanks

This message has been edited. Last edited by: BM,

One question : How and Why a user would enter 4096 characters in a search string ???

According to me, if your users may enter that much of data as for a selection (filter), you should think of another way to select those many part numbers...

User may get list of parts from the customer.
The length of each Part numbers can go from 5 character to 25 characters.
If the user wants to search 400-450 parts which is quiet normal then the length of the variable string goes over 4096 character.

Hi BM,

You don't specify the OS in your signature, so am guessing, but

I was thinking, if WebFOCUS can't do it, then perhaps something else can.

Some of the options I can think of are:

• Call an OS command and pass the string. Don't know if you are on Windows, Unix, Linux, other
  
• Use SQL, assuming ANSI SQL can do it in an function call. Or if you have an SQL adapter, then a specific DB function call.
  

Thanks.
OS is Windows.

Would you be able to elaborate on the options you have suggested?

Thanks again for all your help

quote:

User may get list of parts from the customer.

How this list is provided and in which format ?

Hi BM

This is off the the top of my head but what about using substring to break the string down to 4096 chunks and creating more than one &variable to manipulate

quote:

Originally posted by MartinY:

quote:

User may get list of parts from the customer.

How this list is provided and in which format ?

Its in a text format.
User enters them in a EDIT BOX (&PART) with "^" delimiter.
I am able to add replace '^' with ' OR ' and use that in my WHERE CLAUSE.
Issue is if the the length &PART goes over 4096 then it doesn't work.
Here is the code I amusing to replace "^" to " OR ".

-SET &VALS = ∂
-SET &VALS2 = &VALS.LENGTH + 1365;
-SET &VALS3 = 'A' | &VALS2;
-SET &VALSX = STRREP(&VALS.LENGTH,&VALS,1,'^',6,''' OR ''',&VALS2,'&VALS3');
-SET &VALSX = TRUNCATE(&VALSX);
-SET &PART = &VALSX;


quote:

Originally posted by Chuck Wolff:
Hi BM

This is off the the top of my head but what about using substring to break the string down to 4096 chunks and creating more than one &variable to manipulate

Hi,
This is what I am struggling with...Since the lenght of each Partnumber in the string varies 4096 chunk could break the value of the PartNumber.

BM,

My question was to understand How does your user do receive the part list from the customer.
The way that the user actually enter the part list in a edit box was clear. This is where is your issue.
I'm wondering how do this list is provided to your users BEFORE they enter it in the edit box.

Maybe something could be done using that input list and avoid manual entry of part numbers.

Having users to type in several numbers (from 5 to 25 digit) with a "^" as delimiter can create so many entry errors that this is from where you need to take action to eliminate that manual entry.

So I repeat my question : From where, how and in which format does the part number list is given to your users BEFORE they enter it in you edit box ?

Oh now I know what you mean. sorry for the confusion.
The user may get the list from the customer in a PDF or in a spreadsheet.
Or they may create a list of "Focus" parts to track for their Business Unit.
Majority of the time the list is manageable.
Its just sometimes we do get those strange request and not sure how to tackle it.
I was thinking of maybe creating a table off of the list but not sure how.

Thanks

In situations like this in the past I have used JavaScript to do the replacement. Here is some sample code that you can try to see how it would work:

 <html>
 <script>
 function replacetext() {
    var parts = document.getElementById("edit1");
    parts.value = parts.value.replace(/\^/g,"' OR '");
 }
 </script>
 <input id=edit1 onkeyup=replacetext() size=100></input>
 </html>

You could incorporate the two lines of code in the function into your HTML Composer/Canvas page to run when your run button is clicked.

quote:

Would you be able to elaborate on the options you have suggested?

I just has a thought.

Can you -WRITE the string to a file, then -READ it or create a master file for it and TABLE FILE it ?

How about taking that list of part numbers and writing them to a file, then use "WHERE PART_NUMBER IN FILE (FileName)" (I think that the syntax, maybe?)?

quote:

The user may get the list from the customer in a PDF or in a spreadsheet.
Or they may create a list of "Focus" parts to track for their Business Unit.

Since it doesn't seems to always be the same way that the data is "received", dbeagan look like your best and simplest option

 function replacetext() {
    var parts = document.getElementById("edit1");
    parts.value = parts.value.replace(/\^/g,"' OR '");
 }

thanks all.
Will give javascript replacement a try and get back.

quote:

Originally posted by Waz:

quote:

Would you be able to elaborate on the options you have suggested?

I just has a thought.

Can you -WRITE the string to a file, then -READ it or create a master file for it and TABLE FILE it ?

Thanks .. not sure how to do that.
Do you have any example or post you can point to?

Hi BM

Since your limitation is the 4096 limit for STRREP I think the javascript is your best option.

quote:

Since your limitation is the 4096 limit for STRREP I think the javascript is your best option.

I do agree, as I already mentioned and it's much more simplest then perform -WRITE, create a master file and -READ to then perform other action on the string.

Thanks all. Javascript it is

quote:

Thanks all. Javascript it is

Let me know if you need the other option.

quote:

Originally posted by Waz:

quote:

Thanks all. Javascript it is

Let me know if you need the other option.

For now I have used the javascript and its working well but for sure I would like to learn the other option .

The Idea, I had was to -WRITE out the &Var, then -READ bit of it into new vars.

You could also use a TABLE FILE to do things as well, but this is the simple example.

-SET &BASE = '123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 ' ;
-SET &BASE1K = &BASE | &BASE | &BASE | &BASE | &BASE | &BASE | &BASE | &BASE | &BASE | &BASE ;

-SET &TEST = '' ;
-REPEAT LOAD FOR &CNTR FROM 1 TO 5 ;

-SET &BLK = DECODE &CNTR(1 'A' 2 'B' 3 'C' 4 'D' 5 'E' ELSE 'X') ;

-SET &TEST = &TEST || &BLK || &BASE1K ;

-LOAD

-*-TYPE &TEST

FILEDEF TESTFILE DISK test.ftm

-RUN

-WRITE TESTFILE &TEST

-READ TESTFILE &BLOCK1.A1000. &BLOCK2.A1000. &BLOCK3.A1000. &BLOCK4.A1000. &BLOCK5.A1000. 

-TYPE BLOCK1 = &BLOCK1
-TYPE BLOCK2 = &BLOCK2
-TYPE BLOCK3 = &BLOCK3
-TYPE BLOCK4 = &BLOCK4
-TYPE BLOCK5 = &BLOCK5

* Tested on a linux environment