search and replace from.... to in a string

[mollie]

Hi -

I have a memo field that I want to remove text from.

The memo field may have a lot of text from various entries - - - and I would want to remove everything in between what STARTSWITH ****- and ENDSWITH -**** (SEE SAMPLE BELOW)

Please note that there may be multiple **** in betweeen the first and last instance - - - but I want to remove EVERYTHING in between - - - so, in this particular instance, I'd return an empty string


****- Updated customer info from web input 01/22/2010 -****Company was HOOPER & CO. fax was 207/222-2222 ****- End Update from web input 01/22/2010 -****

appreciate any thoughts on this -

thanks

mollsie

 

[DJWheezyWeez]

if left({table.memo},4) + right({table.memo},4) = "********"
then ""

This will return an empty string only if the string begins and ends with ****.

-DJWW