I'm trying to strip out none alphanumeric characters (and a couple of punctuation marks) from a string before inserting into a database.
I've put in my code below, basically I thought I'd loop through each character in turn and pass it through a regular expression to check its validity. If it passes I'll add it to a global variable ('validString') if it fails I'll remove it.
But I can't get my Mid() function to accept 'i' as a value so it won't loop. Code:
I know there is a way of stripping out special characters from a string however I need a way of stripping out "" marks from a string or what i really want is to replace all double ("") marks in a string with single ('') marks before inserting the string into a database. Is there a way of doing this in ASP?
I am trying to prepare a report to export data to a csv file and, in addtion to the charaters present in the DB the csv file also contains some charaters which i do not understand (some square type characters), i tried to copy them here but they seem to changing to spaces when copied here.
I'm trying to catch some characters in a string before they are entered into a database that are not ASCII and convert them to ASCII characters. The characters in question are the angular double quotes but this could be associated with similar occurences. I want to check for left angular double quotes [“] or right angular double quotes [“] and replace them with straight double quotes ["].
(I'm not actually storing the HTML equivalents - they are simply there to give you an idea of which characters I'm on about.)a way of catching these buggers? I've tried using chr(8220) (the numeric code for one of the illegal characters apparently) but ASP has a problem working with numbers outside the character map.
I have several isbn's that are eather 10 or 12 charcters long. I need to insert a dot . after the fifth character if it is 10 long, and after the 6th character if it is 12 long. How do I count through the string and find out if it is 10 or 12 charaters long, then insert the dot . after the first 5 if it's 10, or after the first 6 if it's 12?
But I can't find the same way to do it in vbscript using ASP! I simply want to strip the last four characters, but leave the rest of the string in tact! As the string could be any length, I don't know a start position.
I have this bit of code that stores the current web page address in a Session variable. I want to always remove the last four characters, such as E.asp, or G.asp, or I.asp.
I searched tutorials on string manipulation but all seem to take out a string in the middle of a string and replace it with something. I just want the last 4 characters removed.
what is the maximum number of characters that a string variable can hold - i initially thought it was 256, but after some testing it seems that it can hold much more than that..
I have a page that update an Access db. When I operate on this page, randomly the screen is refreshed and I loss the data that I have eventually digited and not saved.
My website has been targetted by a web scam. They have sent out an email, which looks as if it's come from me (the email tells them that they must update their information). There is a link in the email which, when clicked, opens up 2 windows: my site in the background and a small window on top with form. This forms asks the customer to submit sensitive information. Is there any script I can use to close down other windows when my site is opened? I can't think of any other quick solution at the moment.
This may not be possible on the server side, so apologies if this is the wrong group for this post.My form consists of an unknown number of pairs of text boxes. They are named textbox_a and textbox_b. I then split the comma separated list that gets posted:
textbox_a = split(Request.Form("textbox_a"),",") for i = ubound(textbox_a) ...insert into db
then do the same for textbox_b
If anyone puts a comma into one of the text boxes, this will result in unmatched pairs. How can I deal with the comma, or prevent it?
I have a simple form connecting to an Access database where users log in, fill out the form, and submit. Everything works fine.
However, sometimes it takes a user 20 minutes or more to fill out the form. When the user then hits "submit" he is given the login page instead of the response page I have built in. If the user fills the form out in less than 20 minutes or so, it works fine.
I have Session.Timeout=720 (2 hours) but this hasn't changed anything.
Does anyone know what I'm missing? I'm pretty new at asp so forgive me if it's something simple.
Since The recordset paging didn't work as I had posted in my previous thread, I decided to look for a new sample code on paging. Thank God it worked. But I'm trying to figure out what to write in the page links: Code:
i have a record that is returned by the database as domain/username. i want to be able to strip off "domain/" and just display "username". is this possible? if so, how would i go about doing this?
My ASP page allows user to enter comments into a form. To avoid errors I'm having to strip out double quotes before saving to the database. Is there anyway to encode these so that I can store them instead, in the way was an URLEncode works?
in my front end uses will type in a date in a text box. in the code it want to call each individual i.e the month the day and the year i am not sure of how to do this.
i have a record that is returned by the database as domain/username. i want to be able to strip off "domain/" and just display "username". is this possible? if so, how would i go about doing this?
I want to strip email from the text. Some of my users may send me a string:
str = "This is email 1: Join Bytes! and here is email 2: <a href="mailto:me@me.com">me@me.com</a>"
How do I parse the string to get email address only? mI know I may use instr() to determine if email address exists, but please, give me a hint on how to handle it next.
I'm querying a text field with an 8000 character limit. The text also contains HTML tags like <p> <br> and more. Is there a way to strip all HTML tags in the resulting recordset, or do I have to replace each tag individually?
I have an asp page that reads the contents of a database and creates an xml news feed. I have code that strips out the <BR> and <P></P> tags, but it looks one of the databases I'm trying to read from uses only <P> without the closing tag.
So the make a long story short, I can't figure out what to add to my code to strip out these tags (or if that isn't the problem at all!) Code:
I need to make a function that takes Request.QueryString elements and strips all single quotes from the input.
function StripQuotes(array) dim StripQuotes for each old in array new = replace quotes (old) Add new to StripQuotes next return StripQuotes end function
i have a password reminder page that works, but i'm trying to strip down the username. it's in the database as domain/username, but i don't want the user to see the domain in the email they receive.
when i run the page i get a type mismatch error pointing to the line where i'm outputting the username in the email. i can get this to work when i'm outputting the data to a web page. is it because of cdonts? how would i strip off the data? Code:
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 .....
I have a form in which several elements are expected to be all digits. Some of those elements can be left empty, but if specified they must be all digits. I have this Sub to edit them: ....