Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

asp classic Split data and transfer it to another table ...

Avatar of BOB KUSPE
BOB KUSPE asked on
Microsoft AccessASP* split
2 Comments1 Solution175 ViewsLast Modified:
Dear all Experts in ASP Classic

I am working with asp classic and msaccess db

I need a bit help for this script to be executed according my needs.

<%
set conn=server.CreateObject("adodb.connection")
conn.open "Provider=Microsoft.jet.oledb.4.0;data source="& server.MapPath("db\bd1.mdb")
set rs_main=server.CreateObject("adodb.recordset")

rs_main.open "select fileid,title,texts from add0",conn,1,2

do while not rs_main.eof
    d=rs_main("texts")
	title=RS_MAIN("title")
	dim p
    p=1
    for x=1 to len(d)
    if mid(d,x,1)="," or mid(d,x,1)="." or mid(d,x,1)="!" then
    texts=mid(d,p,x-p)
    p=x+1
    conn.execute("insert into table2 values ("&rs_main("fileid")&",'"&title&"','"&texts&"')")
    end if
next
rs_main.movenext
loop
rs_main.close
set rs_main=nothing
%>


Where:

Table name = Add0
fields
fileid (autonumerical)
title (text=100)
texts (Memo)

Table name = table2
fileid (autonumerical with  duplicates)
title (text = 100 with duplicates)
texts (text = 100 with duplicates)


GOAL:

The script splits a long memo field into substrings splitted by "." or "," or "!", but not works adequately because sometimes a substring are larger than the width of the table2.texts

Do you know a way to change this script to split (1) the substrings in 10 words or (2) length (=100) avoiding to cut words or (3) each capital letter?

I would be grateful for any help..
ASKER CERTIFIED SOLUTION
Avatar of Fabrice Lambert
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answers