'Substitute' function and wildcards

[Emma in England]

I need to create a field which looks at an existing field and strips out everything in it which is between chevrons, i.e. replace with nothing.

How do I put this into the function? I've tried asterisks and it doesn't understand them, I guess because in a function they mean multiplication!

First post, hope someone can help!

Emma

[Ender]

I don't think this can be done in FM5 without knowing ahead of time which text strings to substitute out. I suppose you could try a scripted solution, where it loops through setting the search text into a global, then substituting it out of the source text.

BTW, in FM7/8, this can be done easily with custom functions.

[Emma in England]

Oh no, that sounded great and I've just been told we're only being upgraded to v6!

BTW, if I want to look for strings containing a " character, how do I tell it to treat that as a literal, I can't find anything in the help file...

[Ender]

This seems to be a duplicate post.

http://www.fmforums.com/forum/showtopic.php?tid/169937