Split Function, Check If There Is A Space

I'm using the split function to split forename and surname, but sometimes there is no second name, is there any way of doing a check to see if there is a second part in the array?

this is the split:-
WordArray = Split(strUsername, " ")

View Replies


ADVERTISEMENT

Split Function To Split First Letters

I have a variable which holds college names

strcollege="University of California"

i want a variable to save UoC

what i meant was there are 3 words University of California

so i want the first letter in each word to be stored in a variable ....

View Replies View Related

Split Function

I want to take a server variable and split it. It would look something like this:

varServerVariable = fistname.lastname

I want it to look something like:

first = firstname
last = lastname

I know that I need to use the Split Function, but I'm not sure of the syntax.

View Replies View Related

Split A Function

I have a textbox that will have this kind of value.
eg. 1+1, 1+2, 1 +2, 1 + 2.....

So now i need to get the 1 and 2 to add it up. This textbox is for add function.

Before this i using the Mid Function. But this is only work if they entered btwn 1 - 9. If 10 then unable to find it.

I remember there is a function where it will find the value then stop at there. then i only grab the bfore the value. I try to lookup but i can't find the function. I need to get the value bfore + and after + to add it up.

View Replies View Related

How To Split Tables By Using Sub Function?

What I am doing is:

If Term = Spring2005 then display everything belongs to Spring2005

If Term = Fall2005 then display everything belongs to Fall2005

And so on.

I used Sub function to do that, but it doesn’t split it? How can we do that?

Code:

View Replies View Related

Split Function Problem

User enters a string of words and it's stored in txtHAR.

I then do this,
txtArray = split(txtHAR," ")

After this step i'm lost. Because user can enter as many words as they want how am i to track the number of words txtHAR has split into?

View Replies View Related

Split And Ubound Function

this code gives me one short of the ubound function, what is wrong?

e.g if i have 353425432,325423,2542354
it gives me 2 instead of 3

jumvar = request.QueryString("one")
jumvarsplt = split(jumvar,",")
valnum = CInt(ubound(jumvarsplt))

View Replies View Related

Split Function & Loop

I am trying to loop around a split and the code I have is below:

response.Write("<tr>")
    response.Write("<td class=""tableHeader"" valign=""top"">Keywords</td>")
    keywordsSplits = Split (keywords, ", ")
    For each keywordsSplit in keywordsSplits
        response.Write("<td>")
        response.Write(keywordsSplit)
        response.Write("</td>")
    Next
response.Write("</tr>")

The problem is that it does actually put the seperate keywords into seperate cells (td's)
I get the following:

<tr>
    <td class="tableHeader" valign="top">Keywords</td>
    <td>test test1 test2 test3</td>
</tr>

I actually want

<tr>
    <td class="tableHeader" valign="top">Keywords</td>
    <td>test</td>
    <td>test 1</td>
    <td>test 2</td>
    <td>test 3</td>
</tr>

Can anyone help?

View Replies View Related

How To Use Split Function In SQL Line?

i want to use split function in sql line ....

View Replies View Related

How Do I Highlight A Split Function Text?

How do I highlight a split function text?

code ....

View Replies View Related

Split Function To Use XMLHTTP To HTML

Basically I am using XMLHTTP to pull a file ( template ) then I am using replace to replace tags i.e. [code] with a HTML equiv.

So now I need to know how I can split [Menu|http://localhost/root3/cgi-bin/templates/menu.asp?Top] so that I can use XMLHTTP to pull that file and output it as HTML.

I know how to split a string, but I can't call this [Menu|http://localhost/root3/cgi-bin/templates/menu.asp?Top] as a variable as it can change at any time.

p.s I mean how Sitepoint does the url replacement, it will have a replace function that will first search for URL and then convert what ever is after the = into a url, then what ever is after that as the name.

[-URL=http://]test[/-URL] ( I put -'s in to stop the replacement )

View Replies View Related

Split Function And Multiple Select Drop Down

I have a multiple select drop down. It will load into it the following information: Student ID, Last Name, First Name

There will be another drop down box that loads with classes, only this is not a multiple select.

I need the user to be able to select all students they need from the first drop down and then select the class they want to insert them into. Then, when they hit the button, it will break up the data from the first, Student ID, Last Name, First Name and insert those three things into the database under those respective column names.

Does anybody know how I can split these up properly when there will be multiple students selected, or does anybody have a better way of doing this?

View Replies View Related

Array Not Created Properly With Split Function

I am having trouble loading the result of a VBscript split function into an array. The script is supposed to take the user's login name (the form for this is name separated by underscores such as john_foo or lisa_wilson), split it at the underscores, and load first, middle and last name into an array. The problem I keep getting though, is that I am getting a type mismatch error. Here is the code:

<%dim LogName, NameArray(), FirstName, LastName, MiddleName, LastPage
'Get NT authorized login info
LogName = request.servervariables("logon_user")
NameArray = Split(LogName, "_")
for x = 0 to UBound(NameArray)
response.write NameArray(x) & "<br>"
next
%>

The FirstName, MiddleName, LastName vars are supposed to take the array values later.

View Replies View Related

I Wan't Any Function To Update The Db Field When Checking A Check Box

is there any one know how to make function to update db field and to be called on checking a check books.

View Replies View Related

Function To Check The User Input From A Form

write a simple function to check the user input from a form. I need to check that the string contains only numbers, has a maximum leght of say 15 and that the first number is zero.

View Replies View Related

Using Vbscript "SPLIT" Function On Multi-select Field

I am trying to split a mgrgroup field to extract the MD codes. It correctly grabs the MD codes if all records in a mass update are updated, but if only one record in the loop is updated then it puts the last 5 digits of the mgr name in the MD field.

THIS IS THE CODE: ....

View Replies View Related

Using Vbscript "SPLIT" Function On Multi-select Field

I am using the following code to split/join values in a multi-select field. It is combining all the values in All the records into one long string in each record in recordset.

Example: I have a recordset with 2 records. The 1st contains the split/joined values: Alan Smir, Jeff Karl The 2nd contains the value: Keith Robb

When it updates database, it will put Alan Smir, Jeff Karl, Keith Robb into each record in the recordset. Instead it should be putting Alan Smir, Jeff Karl into the 1st record
and Keith Robb into the 2nd record in the recordset.

Does anyone see what is wrong with the code ....

View Replies View Related

Split Array But On Every Second Split?

I have a string

212334||327362737||437437||47347837||8347834||

etc

but i want to enter them into a databse

but it must be as 1356235 then field 2 is 125662

dont know if this makes sense

each number is a team in a match so team 1 plays team 2, enters into databse
then move on to the next 2, in that array.

i cant seem to get it to do 2 at a time, without ending up with an endless loop or team 2 being team 1 on the second entry.

View Replies View Related

Do Not Allow Space

i have a form where a user will enter their information.... i know how to check if the user didn't enter a value so that they are not redirected to the next page but how to check if the user pressed space and not allow that space character to be a valid character?

View Replies View Related

Add Space

I have a webpage with some hyperlink within a button. The problem is that some of my hyperlink is shorter that others and therefore the user must navigate to the hyperlink to click on the link

The thing I want is to make the button more user-friendly user can click anywhere on the button and not only on the hyperlink within the button

Here is my code ....

View Replies View Related

URL With A Space

In an ASP Page is there a way to have a link that calls another page whose name includes a space? For example, I'd like to be able to call "My Page.asp" by building a href type link the user can click on. The equivalent of:

<a href="My Page.asp"> Open </a> the page

I've tried URLEncode but that didn't work.

View Replies View Related

Space

I’m reading a list of values from a database table a creating a dropdown list on a web page. These are used as search criteria to search on a second table. The user selects and item from a list and then clicks a button to submit the search. All of that works.

Most search words in the list are a single word with no spaces. Some are two words. When that is passed, anything passed second space gets lopped off. Here is the line of code that creates the dropdown box

sDataSet = rs1("Dataset")
response.write "<OPTION selected value=" & sDataSet & ">" & sDataSet

I tried this, but it didn’t work
response.write "<OPTION selected value=" & Replace(sDataSet, “ “, “%20”) & ">" & sDataSet

It replaced the space with %20, and the entire search phrase was passed, but the search failed because the %20 was not converted to a space on the other end. So now I doing the conversion myself after I do the Request.Form. Is there a better way though, to deal with spaces.

View Replies View Related

Replace <br> With Space

My form gets populated from an access database. Now in the database there are fields containg <br>. While in a normal page everything works as it's supposed to, in my listbox the <br> shows as it is. What I would like to do is replace it with a space so I've used this:

<option value="<%=(rsProducts.Fields.Item("CatNum").Value)%>"><%=replace(rsProducts.Fi elds.Item("NotesR").Value),"<BR>"," "%></option>

but it doesn't seem to work.
What exactly am I doing wrong here?

View Replies View Related

Space In Variables

i need to combine 2 vriables that are retrieved from a form. idate and
itime.i want to put these into the t_date field in my sql db. but for it to work
properly, there needs to be a space between the idate and itime.
how do i do this?
i know i should know this, and i have used it before. but it has been so
long, that i can't remember for the life of me.

View Replies View Related

Space In Querystring

1. dopage.asp?<% =SessionID=value_here%> is different tha
2. dopage.asp?<%=SessionID=value_here%> ??

Please note that there is a space between the asp tags and the = sign in the first item. I thought ASP will treat #1 and #2 as the same. However it seems that is not the case.

View Replies View Related

Space In SQL Statement?

can anyone fix the space problem in my sql statement? I am getting this error message:

ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

This is my sql statement:
sql = "SELECT * FROM " & tblname & " WHERE " &Col& " = N'" &Var& "' AND [Show]=1 ORDER BY [Code] ASC"

And I am passing the parameters to the url something like this:
Product.asp?Visit=Yes&Var=Hong%20-%20Kong&Col=Place

Problem is that most of my data contain a space (eg. Hong Kong).

I don't have this error when my data is single word (eg. Sydney)

View Replies View Related

Drive Space

I want to check the disk drive space on a small intranet. Like 30 computers. All have been partitioned and have a D: drive that is shared and is the drive I'm trying to check. This is basically what I have tried:

Code:
Dim fs, pcdrive, cdrive, n

Set fs=Server.CreateObject("Scripting.FileSystemObject")
Set pcdrive = fs.GetDrive("xx.xx.xx.xxshare01-d")

Response.Write("Share01 Free Drive Space is:&nbsp;" & pcdrive & "<br>")

set pcdrive = nothing
set fs = nothing

Is there something wrong with the code or would it possibly have to do with permissions? When this script runs,I get a page cannot be displayed.

View Replies View Related

White Space

when it writes the varFault option to SQL, there is lots of whitespace written too!I have tried the Trim option but to no joy

<%@LANGUAGE="VBSCRIPT" %>

<%OPTION EXPLICIT
Dim objConn, strSQL, objRS, varName, VarExt, VarFault, varDept, strSQL1, objRS1
Set objConn = Server.Createobject("ADODB.Connection")
objConn.open Application("helpdesk")
varName = Request.Form("name")
varDept = Request.Form("departments")
varFault = Request.Form("txtFault")
strSQL = "INSERT INTO new_calls (Name, Department, Fault) VALUES "
strSQL = strSQL & "( '" & varName & "','" & varDept & "','" & varFault & "')"
strSQL1 = "SELECT * FROM new_calls "
strSQl1 = strSQL1 & "WHERE call_id= '"'
set objRS = objConn.Execute(strSQL)
%>

View Replies View Related

White Space

Say I have a 'Mc Paul' in the database, what would i need to do if the user searched for 'McPaul' how could i pull that record out of the DB.

View Replies View Related

Uppercase After Space

I'd like to know how can I make the first letter of every word on a textbox field, uppercase, automatically. I'd like to use this for the Name and Surname field, but I don't know how?

View Replies View Related

Server Space

Now that my website is compleate(ish), I am looking for server space(for free) to host it on. A lot of the ones I have seen, for some reason, do not support classic ASP.

View Replies View Related

Out Of String Space

Sometimes I am getting the errormessage "Out of string space ". The error occurs on this code:

sBrf = sBrf & sBodyTmp & "par page par "

When this occurs len(sBrf)<100.000 and len(sBodyTmp)<10.000. Also there is about 1,5gb fysical memory free. I am using Windows 2000 IIS5. I tried isolating the proces in IIS to make sure no other scripts are involved, but it doesn't help.

View Replies View Related

Choped At The Space

If I try to retrieve a char field from MySQL with 11111111

in the field I have no problem, however if I put in: 11111 111111

then it doesn't retrieve the part after the spaces it seems to just chop it at the first space. Can anyone help my with the code to make it work.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved