String manipulation and category building.

seanybravo · Sep 24, 2003

String manipulation and category building.

I have been working in this problem for weeks and I was determined to sort it myself however I feel I need guidance to proceed forward.

What I am trying to produce is some asp code that can split categories and group from a text string that is delimited by a "| ". (see string examples below). I have managed to find some javascript that will handle the different levels of categories without having to keep refreshing the page. So I want the asp code to split the categories in the javascript array's (see java code below) and be flexible enough to handle different numbers of sub categories as they can vary.

Any guidance or examples would be appreciated.

Thanks

Sean

String examples

Agriculture, Forestry & Fishing[1]|
Agriculture, Forestry & Fishing[1]|Growing of crops; market gardening; horticulture
Agriculture, Forestry & Fishing[1]|Farming of animals
Agriculture, Forestry & Fishing[1]|Mixed farming
Agriculture, Forestry & Fishing[1]|Agricultural and animal husbandry service activities, except veterinary activities
Agriculture, Forestry & Fishing[1]|Hunting, trapping and game propagation and related service activities
Agriculture, Forestry & Fishing[1]|Forestry, logging and related service activities
Agriculture, Forestry & Fishing[1]|Fishing, operation of fish hatcheries and fish farms; service activities incidental to fishing
Energy and manufacture of mineral products[2]|
Energy and manufacture of mineral products[2]|Extraction of minerals, oils and natural gas, and related service activities
Energy and manufacture of mineral products[2]|Glass and glass products

Java code

<script language="JavaScript" type="text/JavaScript"></script>

<body>
<p>
And this second example shows a pair of single-entry "combo" pulldowns filled
with the same data:
</p>
<form name="firstexample" onsubmit="return(False);">
<table border="1" bgcolor="beige" align="center">
<tr>Publishers Titles</tr>

<tr><td>
<select name='list1' size='1' style='width:360;' onchange='comboItemSelected(this,this.form.list2);'>
<option>Please make a selection</option>
<option value="Algodata Infosystems">Algodata Infosystems</option>
<option value="0877">Binnet & Hardley</option>
<option value="1622">Five Lakes Publishing</option>
<option value="9901">GGG&G</option>
<option value="9999">Lucerne Publishing</option>
<option value="0736">New Moon Books</option>
<option value="1756">Ramona Publishers</option>
<option value="9952">Scootney Books</option>
</select>

</td><td><p>
<select name='list2' size='1' style='width:360;'>
<option>Please select an item from the preceding list</option>
</select>

<script language='JavaScript' type="text/JavaScript">
//Arrays for menus
if (!assocArray) var assocArray = new Object();
assocArray["list1=0736"] = new Array(
"PS7777","Emotional Security: A New Algorithm",
"PS2091","Is Anger the Enemy?",
"PS2106","Life Without Fear",
"PS3333","Prolonged Data Deprivation: Four Case Studies",
"BU2075","You Can Combat Computer Stress!",
"EOF"
assocArray["list1=0877"] = new Array(
"PS1372","Computer Phobic AND Non-Phobic Individuals: Behavior Variations",
"TC4203","Fifty Years in Buckingham Palace Kitchens",
"TC3218","Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean",
"MC2222","Silicon Valley Gastronomic Treats",
"TC7777","Sushi, Anyone?",
"MC3021","The Gourmet Microwave",
"MC3026","The Psychology of Computer Cooking",
"EOF"
assocArray["list1=Algodata Infosystems"] = new Array(
"PC1035","But Is It User Friendly?",
"BU1111","Cooking with Computers: Surreptitious Balance Sheets",
"PC9999","Net Etiquette",
"PC8888","Secrets of Silicon Valley",
"BU7832","Straight Talk About Computers",
"BU1032","The Busy Executive's Database Guide",
"EOF"
</script>
</td>
</tr>
</table>
</form>
</body>

mwolf00 · Sep 24, 2003

Can you repost after unchecking "Process TGML" or by enclosing your code in

Code:

tags?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

seanybravo · Sep 24, 2003

as requested reposted with unchecking "Process TGML"

String manipulation and category building.

I have been working in this problem for weeks and I was determined to sort it myself however I feel I need guidance to proceed forward.

What I am trying to produce is some asp code that can split categories and group from a text string that is delimited by a "| ". (see string examples below). I have managed to find some javascript that will handle the different levels of categories without having to keep refreshing the page. So I want the asp code to split the categories in the javascript array's (see java code below) and be flexible enough to handle different numbers of sub categories as they can vary.

Any guidance or examples would be appreciated.

Thanks

Sean

String examples

Agriculture, Forestry & Fishing[1]|
Agriculture, Forestry & Fishing[1]|Growing of crops; market gardening; horticulture
Agriculture, Forestry & Fishing[1]|Farming of animals
Agriculture, Forestry & Fishing[1]|Mixed farming
Agriculture, Forestry & Fishing[1]|Agricultural and animal husbandry service activities, except veterinary activities
Agriculture, Forestry & Fishing[1]|Hunting, trapping and game propagation and related service activities
Agriculture, Forestry & Fishing[1]|Forestry, logging and related service activities
Agriculture, Forestry & Fishing[1]|Fishing, operation of fish hatcheries and fish farms; service activities incidental to fishing
Energy and manufacture of mineral products[2]|
Energy and manufacture of mineral products[2]|Extraction of minerals, oils and natural gas, and related service activities
Energy and manufacture of mineral products[2]|Glass and glass products

Java code

<script language="JavaScript" type="text/JavaScript"></script>

<body>
<p>
And this second example shows a pair of single-entry "combo" pulldowns filled
with the same data:
</p>
<form name="firstexample" onsubmit="return(False);">
<table border="1" bgcolor="beige" align="center">
<tr>Publishers Titles</tr>

<tr><td>
<select name='list1' size='1' style='width:360;' onchange='comboItemSelected(this,this.form.list2);'>
<option>Please make a selection</option>
<option value="Algodata Infosystems">Algodata Infosystems</option>
<option value="0877">Binnet & Hardley</option>
<option value="1622">Five Lakes Publishing</option>
<option value="9901">GGG&G</option>
<option value="9999">Lucerne Publishing</option>
<option value="0736">New Moon Books</option>
<option value="1756">Ramona Publishers</option>
<option value="9952">Scootney Books</option>
</select>

</td><td><p>
<select name='list2' size='1' style='width:360;'>
<option>Please select an item from the preceding list</option>
</select>

<script language='JavaScript' type="text/JavaScript">
//Arrays for menus
if (!assocArray) var assocArray = new Object();
assocArray["list1=0736"] = new Array(
"PS7777","Emotional Security: A New Algorithm",
"PS2091","Is Anger the Enemy?",
"PS2106","Life Without Fear",
"PS3333","Prolonged Data Deprivation: Four Case Studies",
"BU2075","You Can Combat Computer Stress!",
"EOF"
assocArray["list1=0877"] = new Array(
"PS1372","Computer Phobic AND Non-Phobic Individuals: Behavior Variations",
"TC4203","Fifty Years in Buckingham Palace Kitchens",
"TC3218","Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean",
"MC2222","Silicon Valley Gastronomic Treats",
"TC7777","Sushi, Anyone?",
"MC3021","The Gourmet Microwave",
"MC3026","The Psychology of Computer Cooking",
"EOF"
assocArray["list1=Algodata Infosystems"] = new Array(
"PC1035","But Is It User Friendly?",
"BU1111","Cooking with Computers: Surreptitious Balance Sheets",
"PC9999","Net Etiquette",
"PC8888","Secrets of Silicon Valley",
"BU7832","Straight Talk About Computers",
"BU1032","The Busy Executive's Database Guide",
"EOF"
</script>
</td>
</tr>
</table>
</form>
</body>

mwolf00 · Sep 24, 2003

for x = 0 to Ubound(stringArray)
thisPart = split(stringArray(x),"|&quot

if thisPart(1) = "" then
'add option to list1
list1 = list1 & "<option value='" & thisPart(0) & "'>" & thisPart(0)
else
if arrayString <> "" then
arrayString = left(arrayString, len(arrayString) - 1)
end if
arrayString = arrayString & vbcrlf & "assocArray['list1=" & thisPart(0) & "'] = new Array("
do while thisPart(1) <> ""
arrayString = arrayString & "'" & thisPart(1) & "','" & thisPart(1) & ","
if x < uBound(stringArray) then
x = x + 1
thisPart = split(stringArray(x),"|&quot

else
exit do
end if
loop
if x < uBound(stringArray) then
x = x - 1
else
exit for
end if
end if
next

arrayString = left(arrayString, len(arrayString) - 1)
alert(list1)
alert(arrayString)
</script>

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

seanybravo · Sep 24, 2003

mwolf00

Fantastic! The code seams to do what I want, I will have to play about with it a bit more first though. Just a quick question sometimes I have up to three categories ie

Agriculture, Forestry & Fishing[1]|Farming of animals|Cows

Is the code you wrote for me flexible enough to handle that or will it need modifying?

You have done wonders for my stress levels.

Many thanks for your time.

Sean

mwolf00 · Sep 24, 2003

I wrote that as a fix for the javascript functions that you ar working with, it isn't capable of another jump without some modification. Sorry that I don't have time right now to make the modification...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

seanybravo · Sep 25, 2003

mwolf00

Further Info

The category list that you wrote the code for can vary as I want to reuse the code with different category lists. They will be set out the same only that they may only be a category on its own or a category with sub categories as per the example.

The code you wrote for me is great and I am currently researching how it works.

What parts need modifying?

Thanks

Sean

mwolf00 · Sep 25, 2003

In order to add another subset, you will need to create another set of arrays. In javascript, I would normally create my arrays like this...

listArray = new Array("Field1","Field2","Field3&quot

Field1Array = new Array("subCat1","subCat2&quot

Field2Array = new Array("subCat3","subCat5&quot

Field3Array = new Array("subCat4","subCat6&quot

subCat1Array = new Array("value1","value12&quot

subCat2Array = new Array("value2","value11&quot

subCat3Array = new Array("value3","value10&quot

subCat4Array = new Array("value4","value9&quot

subCat5Array = new Array("value5","value8&quot

subCat6Array = new Array("value6","value7&quot

Then you'd need your function to eval() the array values sent. Using this scenario, you could make a very flexible program. However, you won't be able to have spaces in the value names. I usually use the primary key to identify the arrays...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

String manipulation and category building.

seanybravo

IS-IT--Management

mwolf00

Programmer

seanybravo

IS-IT--Management

mwolf00

Programmer

seanybravo

IS-IT--Management

mwolf00

Programmer

seanybravo

IS-IT--Management

mwolf00

Programmer

Similar threads

Part and Inventory Search

Sponsor