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

Search And Replace

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

If Condition

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 Condition

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

If Condition Ans SQL 2000

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

Multiple Condition

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

Set Condition Using Variable

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

Empty Value Condition

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

My Condition Statement.

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

Session Objects And Condition

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

Show Info Only If Condition Is Met ?

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

Change Font Colour According To IF Condition

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

ASP Update XML Child Nodes By Attribute Condition

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

Replace Function Not Replacing What I Tell It To Replace

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

Need To Convert Google Search Ref To Find What The User Search

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

Replace Url

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

Replace()

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

VB Replace

How do I take out double quotes before writing to database? As doing ,""","&quote;" created an error.Is it something like ,chr(34),"&quote;" 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

Replace Tab Key

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

Using Replace

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

Yet Another Replace

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

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

ASP Replace Function

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

Replace Blankspace With %

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

Replace Error

what's wrong with this string?

" WHERE InStr (" & request("Field") & ", " & chr(34) & replace(replace(request("SearchWord"),"*","%"), "'", "''") & chr(34) & ") > 0 " & _

View Replies View Related

Replace " And '

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

Find And Replace

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

<p> Replace HTML

Does anyone have a snippet that will replace ALL HTML formatting BUT
leave the <p>'s and <br>'s ??

View Replies View Related

Replace Not Working

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

Null: 'replace'

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

Replace Function

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

Using Substr Or Replace

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

Replace & In A Querystring?

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







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