Is there a way to do multiple functions in a single column of a qu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to find and remove a number of things from a column of data in a
query... I know tha I can get some of the junk out using -
Replace([field],"thing1","") but there are two things that i am removing from
every line of this column so i also have to do Replace([field],"thing2","")
unfortunatly, many of the lines also have an ascii character for carrige
return at the start of the string. I know that i can do
IIf(Asc(Left([field],1))=13,Mid$([field],3,Len([Requirement])),[field]) to
get that out.

The problem is I have to do all three of these agains the same field. Is
there a way to do this? I have been looking for a question like this for the
past couple hours every way I can think of to ask the question. I am sorry if
this is a repeat, I did not see a question and answer that applied.

Thanks for the assistance!
 
Don said:
I need to find and remove a number of things from a column of data in a
query... I know tha I can get some of the junk out using -
Replace([field],"thing1","") but there are two things that i am removing from
every line of this column so i also have to do Replace([field],"thing2","")
unfortunatly, many of the lines also have an ascii character for carrige
return at the start of the string. I know that i can do
IIf(Asc(Left([field],1))=13,Mid$([field],3,Len([Requirement])),[field]) to
get that out.

The problem is I have to do all three of these agains the same field. Is
there a way to do this? I have been looking for a question like this for the
past couple hours every way I can think of to ask the question. I am sorry if
this is a repeat, I did not see a question and answer that applied.
Click to expand...


Nest the function calls:

Replace(Replace(IIf(Left(field,1) = Chr(13), Mid(field,2),
field), "thing1",""), "thing2","")
 
Back
Top