Re: Search and Replace in String

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vince (sdsad_at_fsd.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 12:53:51 +0800

myData=Replace(myData,chr(40),"-")

OR
myData=Replace(myData,"¾","-")

Is this what you want?

Vince

"Eternally grateful" <Eternally grateful@discussions.microsoft.com> wrote in
message news:1D3B6AAD-28BA-4C32-A474-A934B6C114E0@microsoft.com...
> Can anyone tell me if it is possible to perform a search and replace
inside
> of a string?
>
> I have a string called myData that contains an emdash that I need to
change
> into a hyphen and I cannot find a way to do this.
>
> Any assistance would be greatly appreciated.
>
> Thank you for taking them time to read this.

Relevant Pages

  • Re: Search and Replace in String
    ... I meant emdash there. ... Using the ASCII should ... "Vince" wrote in message ... >> I have a string called myData that contains an emdash that I need to ...
    (microsoft.public.word.vba.general)
  • Search and Replace in String
    ... I have a string called myData that contains an emdash that I need to change ... Any assistance would be greatly appreciated. ...
    (microsoft.public.word.vba.general)
  • Re: Add multiple records using a list box
    ... the bound column is the first), you see the string, but the box's value is ... Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/ ... the kinds of assistance patients need -- dressing, ... unbound list box that allows multiple selections, ...
    (microsoft.public.access.gettingstarted)
  • Re: Extra ) error in search form
    ... Everything worked perfectly until the last field (cboCampaign) was added. ... Now I get a error 3075 extra) in string. ... Any assistance is greatly ... Might your code to trim off the AND ...
    (microsoft.public.access.formscoding)
  • RE: Copy Column data to Page Header
    ... I would like assistance to write a macro which creates a page center to read ... from column data. ... I would like for example the text string to read "Wasuto ...
    (microsoft.public.excel.programming)