Question MS-Access Remove text that exist in Memo Field basis of start/End Range/Criteria

[Mohsin Malik]

Hello,

I would like to remove specific occurrence of text found in Memo field on the basis of Start and End Identifier.

The Start Identifier is '<' and End Identifier is '>' and I want to remove anything found in the '<' and '>'? The text in start '<' and end '>' tag will always be different and I want to remove any text found in '<' and '>'?

As an example I want to remove/replace the following lines with blank space "" found in the memo field.

Input Text: Test Text Occurrence 1 <www.google.com > Test Text Occurrence 2
<www.facebook.com> Test Text Occurrence 3
<http://www.access-programmers.co.uk/forums/>

Required Output: Test Text Occurrence 1 Test Text Occurrence 2 Test Text Occurrence 3

I want the Required Output is to 'Remove/Replace' all of the contents found in tags '<>'. This is basically hyperlink address and I want to remove the hyperlink addresses found in memo field. Any Idea?

Thank you
Mohsin

 

[spikepl]

1. Make sure that all URLs begin with http:// some global replace should do it : i don't know what effect http://http:// can have
2. Use the function mystring=PlainText(mystring) - it will strip out all url's

 

[Mohsin Malik]

Hi Spikepl,

Thanks for the message, I want to replace different URL's that exist in the memo field not the http:// etc. For instance if the Memo field have anywhere from 10 different urls, I want to have replace all of them with blank spaces? One thing I would know is that all of the urls start from '<' tag and end with '>' tag. Is there a way if something find and replace anything exist between start and end tag '<>'? Does that make sense?

Thank you
Mohsin