Search and Replace in String

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eternally grateful - 01 Feb 2005 03:37 GMT

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.

Reply to this Message

Vince - 01 Feb 2005 04:53 GMT

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

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

Is this what you want?

Vince

> Can anyone tell me if it is possible to perform a search and replace inside
> of a string?
[quoted text clipped - 5 lines]
>
> Thank you for taking them time to read this.

Reply to this Message

Vince - 01 Feb 2005 06:03 GMT

Sorry, I meant emdash (the symbol) there. Not 3/4. Using the ASCII should
work

> myData=Replace(myData,chr(40),"-")
>
[quoted text clipped - 16 lines]
> >
> > Thank you for taking them time to read this.

Reply to this Message

Jezebel - 01 Feb 2005 06:05 GMT

em-dash is chr(150)

BTW, the string versions of these functions are about 10 times faster than
the variant equivalents --

MyData = Replace$(OldData, chr$(150), "-")

> myData=Replace(myData,chr(40),"-")
>
[quoted text clipped - 16 lines]
>>
>> Thank you for taking them time to read this.

Reply to this Message