Search And Replace With Condition
I want to search through different strings and replace the ‘0’ with empty value. My problem is I want to search and replace the ‘0’ with empty values until there is a value other then ‘0’.
Examples
Ex 1: 000010000 - > my desired output -> 10000
Ex 2: 000170000 - > my desired output -> 170000
Ex 3: 004001000 - > my desired output -> 4001000
View Replies
ADVERTISEMENT
I wrote a utility in ASP that would allow me to search program files and replace project identifiers in the text with other project identifiers (e.g. _ab in a file name is replaced with _cd). I then couldn't find a way to revise the actual file and save the changes.
According to my ASP reference manual, you can write to the end of a file and write a brand new file. However, I don't see any mechanism for changing text that's already in the file.I would also like to be able to change file names with a program.
View Replies
View Related
i am creating a kind of search using dropdown boxes to search the database. I have got two dropdown boxes one called location and one called cuisine i have sorted out some if statement.
so that it works if they select either one or the other and if they select any location or any cuisine but the problem comes when i need them to be able to select a cuisine in a particular location ie on bothe boxes.
i need it if both are selected at the same time then search the database via location and cuisine. can anybody help here is the code for the two files.
View Replies
View Related
if Line = "" OR NOT IsNumeric(Line) Then
error_list.add"589344","desired line must be specified"
b_error = true
End If
how i can display an error msg saying that the user must only key in number but not character
View Replies
View Related
i have got one field in sql server 2000 database. field1 char 50 in one record, i m storing value -1 but it doesnt satisfy following condition
if (rs("field1")) = cstr("-1") Then
response.write ("true")
end if
i already checked its value by response.write and
print -1 only..
then y its above condition is false?
View Replies
View Related
I WAS having problems. Solved it myself. I'll edit to show the working query for those who could use an example...
I'm having a multiple condition problem in my query statement. I know the what the result should be, but I have something wrong...
Here's the query:
set GetNADs = server.CreateObject("ADODB.Recordset")
set GetNADs.ActiveConnection = adoConnection ......
View Replies
View Related
what s the correct syntax of setting a condition with a variable that is retrieved from database like in the example below:
dim x
x = 9
if rsTypes("one") = x then
response.write ("error")
View Replies
View Related
I'm trying to make a very simple condition about some variable if it is empty do something but my problem is that it always cannot see it is empty
i mean i have a field in a table called title and this field is some times empty
so i need to type "empty" if it is
i tried this code ....
View Replies
View Related
I want to check a another field and if its got info in it i want it to do the then bit, if the field thats checked has no info then its off to else
can some one give me a quick hand on what it should look like?
<%If Your_Condition_Here Then
Response.Write("<form ACTION=""=MM_editAction"" METHOD=""POST'""name=""form1"">")
Response.Write("<input type=""text"" name=""textfield"" value=""(tpwimportrs.Fields.Item(""comments"").Value)"">")
Response.Write("<input type=""hidden"" name=""MM_update"" value=""form1""><input type=""hidden"" name=""MM_recordId"" value=""tpwimportrs.Fields.Item(""ID"").Value "">")
Repsonse.Write("</form>")
Else
' Do Nothing
End If%>
View Replies
View Related
I've got the following code that sets a session object.
set obj = server.createobject("Scripting.Dictionary")
set session("testobj") = obj
If I want to remove the session object, do each of the following does
the same job? Which one is the best?
1 --> set session("testobj") = null
2 --> set session("testobj") = nothing
3 --> Session.Contents.Remove("testobj")
If I want to check if the session object is not exist, which is the
best option?
1 --> if (session("testobj") = null) then ...
2 --> if (session("testobj") = nothing) then ...
3 --> if (isobject(session("testobj"))) then ...
View Replies
View Related
I have set up a table of Ticket Types. Most of these only have a ticket number but one type also has a reference number.
I am trying to display the info in a table and show the ticket number for every type and only show the Ref number when it is applicable.
I'm guessing its a FOR ELSE statement but I can't get it working. Code:
View Replies
View Related
I want to change the font colour to red if a recordset value is 'high' but i dont know where to put the font tags, Heres what i got so far:
<td width="13%" align="center"><% if rs("priority") = "High" then response.write rs("priority")
else response.write rs("priority") %></td>
But where would i put the font tag and the colour, so it coloured the priorities marked as high red?
View Replies
View Related
I am trying to update and append to an existing XML file. However I seem to be stuck. I am using ASP as my scripting language.
The form fields has the same value as the KEY attribute so all i have to do is loop through the submiting form for its fields and use the name to update the XML via the keys... Code:
View Replies
View Related
If I replace "a" with "b", and then I replace "b" with "a", shouldn't I get the same result? That is what I am trying to encode and decode with Replace() function, but it is giving me different things when I replace and replace again. Here is what I am talking about: Code:
View Replies
View Related
i get the ref url that come to my site and i want to convert it to find
out what was the query in (google or other searcher sites)
foe example : if someone goes to google and search some text and my
site was in his resaults and he click on it , in my site i see his link
ref like
http://www.google.co.il/search?hl=i...91-Google&meta=
i want to know (in asp and save it to DB) what was the word or words
that the user write in search engine.
View Replies
View Related
some text is coming out of the DB with different urls in it, i want to delink it (like href="#" or something), how do i do that when i don't know what url is coming out?
View Replies
View Related
I've got a function that I use to replace ' marks so the page will insert properly into a database - typically I use .Code:
whatever= request.form("whatever")
whatever = replace(whatever,"'", "''")
However, I've got some code that I unfortunately inherited from someone else that I can't get the replace to work:Code:
call buildquery (colq,valq,retq,"whatever")
colq = "(" & colq & ")"
valq = "(" & valq & ")"
ssql = "insert into table_name " & colq & " values " & valq
I was trying to do something in the call buildquery line to add a replace, but that doesn't seem to work.
View Replies
View Related
How do I take out double quotes before writing to database? As doing ,""",""e;" created an error.Is it something like ,chr(34),""e;" which I sort of stumbled accross when I did soem google searching... But what and where do these chr(34) etc coem from?
View Replies
View Related
I have lots of textbox that needs to have data entry. Is it possible for me to replace the tab key to return key that transfers the focus from one textbox to another? And also, how to submit the form after all textbox have values?
View Replies
View Related
I come across this often
PHP Code:
Replace(rs.fields("Headline_f"),"''","'")
Where rs.fields("Headline_f") is actually empty.
I usually use
PHP Code:
IF NOT isNull(rs.fields("Headline_f")) or rs.fields("Headline_f") = "" THEN
Headline_f=Replace(rs.fields("Headline_f"),"''","'")
END IF
Is there a better way to handle this?
View Replies
View Related
Even though I ask customers to enter there phone number like xxx-xxx-xxxx they some times don't. go figure:
I create a text file thats used by the factories EDI system and the number needs to be xxxxxxxxxx. I'm using the code below but what if they enter their number xxx.xxx.xxxx OR (xxx) xxx-xxxx etc. You get the idea.
strPhone = Replace(objRS("DayTimePhoneNbr"),"-","")
Does some one have a small chunk of code to help me replace additional chars?
View Replies
View Related
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
I've tried EVERY way i can think of to do this replace function, basically when i go to insert "Do's and Dont's into the database it cuts it off at "Do" because of the ' now ill show you my section of code that i have it in currently:
curdescription = trim(replace(arrTemp(4), "'", "''"))
I have it this way and it doesnt work, and i even had it
curdescription = trim(arrTemp(4))
curdescription = replace(curdescription, "'", "''")
View Replies
View Related
i use the URLencode function and it changes my form text to: this+is+it%21
ok, this is good, but when I use it in a URL, it includes "this" but then the link dies and the rest is just text, the user must then copy and paste the whole address in the browser. Anyway to get around this?
View Replies
View Related
what's wrong with this string?
" WHERE InStr (" & request("Field") & ", " & chr(34) & replace(replace(request("SearchWord"),"*","%"), "'", "''") & chr(34) & ") > 0 " & _
View Replies
View Related
i have some sql data that has " and ' in it. can someone tell me how to do a replace on those so they display correctly?
View Replies
View Related
I am not sure if this is a question for this forum or the IIS forum but here goes. I have a dedicated server on which I am hosting about 80 websites at the moment, all of which have been created by copying a template site. All of these sites have an identical structure and are located in the same directory on the server, C:Inetpubvhosts. Several times when I have needed to make an adjustment to the sites I have to go into the remote desktop connection to the server and go site by site, copying and pasting files. For example, as each site has the same pages, ie., map.asp, sometimes I make a change to that page and have to copy it to every site. Could I write some sort of script using the FSO and execute it from one site and have it loop through each site on the server making the neccessary change(s)?
View Replies
View Related
Does anyone have a snippet that will replace ALL HTML formatting BUT
leave the <p>'s and <br>'s ??
View Replies
View Related
my replace is not working
Shipping News ...i don't want news word ..mean i just want
Shipping
Code:
<%=Replace(rs("name"), "news", "")%>
View Replies
View Related
Can someone help with an error? It's a StoreFront store. right after the credit card screen is gives me the error. I get the following:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'replace' /ssl/SFLib/incGeneral.asp, line 85
--------------------------------------------
84 Function makeInputSafe(str)
85 makeInputSafe=replace(str, "'", "''")
86 End Function
-------------------------------------------
View Replies
View Related
I'm trying to use the replace function to change a variable ie like this:-
replace folder_old, txtOldFoldername,folder_rename
folder_old = c:DocumentsRoot_Testob
txtOldFoldername = bob
folder_rename = newfoldername
all i want to do is to beable to change the name bob to the new folder, is there a easier way to do this or am I on the right track. if i do the replace like this replace(folder_old, " & txtOldFoldername & "," & folder_rename & ")
i get this error:-
Cannot use parentheses when calling a Sub
View Replies
View Related
I been trying to figure out the following. I have a string of 9 numeric characters such as 000982675 and 001000510. The problem I have is in the following code:
View Replies
View Related
i can get the replace function to work in rs return but i'm returning a qs value and it's not working can someone tell what code will work with a qs.
View Replies
View Related