Split A String Which Stores A Mac Address
I have a field which stores a maccaddress. It has a constant length of 12 characters.
e.g 000000000012
When reading from the database and displaying that field I want to display it in the following format:
00-00-00-00-00-00-12.
So I want to split the string and add a "-" after every two characters.
Can you please tell me how this can be done?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Web Forms / HTTP File Upload / String.Split A StreamReader.ReadLine() String
I'm developing an Asp.NET system to take a CSV file uploaded via the web, parse it, and insert the values into an SQL database. My sticking point comes when I try to split() the string returned by readline() on the file. The following code snippet works for me: tokens = "one,two,three,four".Split(",") for each token in tokens response.write("<td>"+token+"</td>") next However, if I take the next line in the CSV, read using StreamReader.ReadLine on the PostedFile.InputStream, I receive "Object reference not set to an instance of an object." which I have narrowed down to be my string holding the line. Further investigation reveals that no other string member functions work on my line (.ToCharArray, .ToString, etc). I suspect that StreamReader.ReadLine is not correctly returning a string, even though Response.Write(line) displays what I would expect .....
View Replies !
View Related
Split For String
there is a method to split a string with a delimiter checkDelete = Request("checkDelete") arrayDelete = Split(checkDelete, ",") my string is Trim(arrayDelete(i)), that has the format "number_number". I want to put the two numbers in two different variables.
View Replies !
View Related
Add A String After Split
I have an array which I split and then add the values into a table. In total there are 3 values in the array, two integers and one string. The integers are put smoothly but the string is not. Is it possible to add the string? Code: ....
View Replies !
View Related
Split A String
how to do the following. Split a string var at each separate leter and then make an array out of it in asp(vb script). jump the cursor between textboxes automatically. i.e tpye one letter into input field with a max length of 1 and then automatically tab to the second. The end result being able to type a whole word without looking up but still have the letters separated.
View Replies !
View Related
Split String Into Pages
I was wondering if it's possible to split a long string, taken from the database, into several pages. Just like the paging function but instead of rows in database you define the amount of rows in the string.. if it exceeds say 5 rows, then it will show a "Next" -button to contine showing the next 5 rows and so on ....
View Replies !
View Related
Split String Alpha Vs Numeric
I have a text file that I'm reading into a SQL table, from there I need to run various scripts on it to clean it up. One being, there is field that comes in as: ie: JNJG12345 MAN5678 XY4656565 I need to split this by Alpha characters, then Numeric characters and be able to input them into seperate fields as such: JNJG 12345 MAN 5678 XY 4656565 I have managed to locate a script that Memnoch came up with: http://forums.aspfree.com/t24666/s....ht=split+string that managed to get me where I am now. How do I get the loop to stop once it finds the first occurence of a number? Below is the code I am using. Code: ....
View Replies !
View Related
Web Server Stores Form Data
When we click the submit button as the following form, my understanding is it will submit the form to the web server, and then open page2.jsp. web server has some area to store the name-value pairs?? I just want to understand how it works internally. <FORM ACTION="page2.jsp" METHOD="POST"> <INPUT TYPE="hidden" name="username" value="joe"> <INPUT TYPE="submit" value="submit form"> </FORM> In page2.jsp <%= request.getParameter("username") %> ....
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
Remove Email Address/ Pseudo Email Address
has anyone got a function or subroutine which will remove blank out or remove email addresses. i've wrote a function which will remove valid email addresses, it's pseudo addresses such as "blah @ blah.com" or "blah_at_blah_dot_com" or "blah_at_blah_._com" the function is basically to stop users posting an email address in a message.
View Replies !
View Related
SSN Split
One of my fields is the customer's social security number, all originally entered as a 9-character string. How can I split and display that into 3-2-4 format?
View Replies !
View Related
Split()
What I need to do is get the content of a text file, one line at a time, and break it up using , as a delimiter. So far I can open the file and print out all the content, but all I am getting is a million ???????'s on the screen, and not the file. Here is what I am using: Code:
View Replies !
View Related
Split()
How can I calculate the number of the substrings below? Code: Dim txt do until rs.EOF txt=Split(rs("diastima"), ",") For i=1 to number_of_substrings Response.Write txt(i)&"<br>" next rs.MoveNext loop
View Replies !
View Related
Split First & Last Name
I have value sSearch = Lastname Firstname I need to split it into two separate field: sLast = Lastname sFirst = Firstname I tried arrSearch = split(sSearch, " " ) but how do I actually get the values?
View Replies !
View Related
Split And Do
I need to send a mail for each address I found in one var. The var is as follows: emails = "onemail@onedomain.com , other@othermail.com , another@another.com " How Can I make a "do while var not end"?
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 Records
Plz guide me on the follwoing.. database=storedb table=product for e.g i m having 50 records in databse i would like to display the 10 records on one page and other on second page and so on.. using asp.
View Replies !
View Related
Split() Using Database
I have a section where users can add their 'favourite venues' to a list. This is stored in a column in the users table, for example: 10,8,1,18,26 On the user area I can do a select drop-down with all their favourite venues easy. When I try to use the same (slightly modified) code on the venue detail page to determine whether the user has the venue in their favourite to link either to ADD venue (not currently a fave) or REMOVE venue (already on the faves list) it only recognises the last added venue, i.e. (working on the list above) venue #26. Here is the code I'm using: Code:
View Replies !
View Related
How To Split A Word !!
I am looking for a function to split my string into subsequent parts. I am having a textbox from where user can enter more then one numbers (23, 456, 89, 394 etc), and now I want to write a function which return this sting into this fashion i.e. 23 456 89 394
View Replies !
View Related
Split A Email
i am trying to split an email address into a string.Basically, what i wanna do is take the first part of the email just before the "@" symbol and insert it into the database. How can I do this using asp?
View Replies !
View Related
Split A Number
I have this number var mynum="01-12-09-908" I want it to be saved in 4 diff variables like mynum1=01 mynum2=12 mynum3=09 mynum4=908 Can someone tell me how I can do it ....
View Replies !
View Related
Split Numbers!
The number '60' can be written as (50+10) or (25+35) or (15+45) or (7+53) etc... but I want the output as (50+10) only when 60 is typed in a textbox & the Form is submitted. How do I do this?
View Replies !
View Related
Array And Split?
i have a text box, where i want to be able to enter items on a one per line basis. i then need to insert these items into a database. i have the functionality to insert into the db ...
View Replies !
View Related
SPLIT Either BOF Or EOF Is True?
I'm pretty new at this so if someone could tell me what I need to do to the foloowing code I would really appreciate it! strSQL = "SELECT * FROM chapmeetreq2 WHERE chapter = '" & session("chap") & "' and entrydate = '" & date() & "' order by req_id desc" ...
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
Split Word
How do I use the split function to break down a single word. e.g. tree I would like to be able to split so that: letter(0) = t letter(1) = r letter(2) = e letter(3) = e Or is this not possible?
View Replies !
View Related
ASP "Split Command
I have the follow code <%response.write(request.form("Select1"))%> And when I view it the page says Product: TShirt (27.99) What I wanna do is to display Product Name: TShirt Price: £27.99
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
Question About Split And New Lines
This code works great unless the data strValue doesnt have any new lines or no data... i get the error Microsoft VBScript runtime error '800a005e' Invalid use of Null: 'Split' is there a way to allow it to return null or something? Code:
View Replies !
View Related
Split Up Source File
This is not really language specific but more of a source code parsing. I have a large ASP source file that I like to split up, resulting in separate ASP files, each containing one function and the filename named after that function. Does anyone know of a tool/script which does this? PS: I am too lazy to learn Perl/AWK/Python to do this, hence why I believe someone has already written a tool/script to do this. Possibly in C++/etc.
View Replies !
View Related
Split Screen Options
I have 10 athletes i will be testing and displaying their information so there will be two split screens the bottom screen where the user enters the data and the top screen where the data will be sorted to show the ranking of the athletes Code:
View Replies !
View Related
Split Adress And Number?
How do I split the adress and number to 2 variables? ex. "Kingsroad 347" = variabel1 = "Kingsroad" variabel2 = "347" Ill guess i have to search the string from left to right after first apperence of a number, but how do i do that?
View Replies !
View Related
Upload Problem (Split From PDF)
I try to use freeaspupload to upload files with two page. one is upload.asp <form method="POST" action="upload02.asp" enctype="multipart/form-data"> <input type="file" name="attach1" size="20"><br> <textarea rows="5" cols="20" name="note"></textarea> <p><input type="submit" value="send" name="B1"></p> </form> the other is upload02.asp <!-- #include file="freeASPUpload.asp" --> <% uploadsDirVar= server.MapPath("files") Set Upload = New FreeASPUpload Upload.Save(uploadsDirVar) %> but it fails,what's the problem?
View Replies !
View Related
Split, Convert Date
I have a form which is posting a user entered date to an asp page. The date is then used in a SQL string. The format of the date is received as dd/mm/yyyy, with the user typing the '/' as well how can I convert it to yyyy-mm-dd ---------------- I have tried this, but I think I need to strip out the '/' ??, as it is not working D1 = cdate(request.form("date")) strDay = Day(D1) strMonth = Month(D1) strYear = Year(D1) NewstrDate = strYear & "-" & strMonth & "-" & strDay
View Replies !
View Related
Split On A Line Break
I would like to have a textarea and have a user input multiple part numbers and return the results. I have gotten it to work if there is a space in between part numbers but if there is a line break it will not work. Anyone have a clue how to split on a line break. Array = split(request("part"), ch(13) ) doesnt work, just returns first input.
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
|
TRACKER
