Custom trim function

[Mental]

Hi,

I have a field that imports from my email. It pulls in the email address and the name at the same time so it looks like this:

John Smith

I really need to trim this by either a calculation or a script that just goes through and processes the records so that it looks like:

[email protected]

I have to trim the name and also the < and > symbols. Any ideas?

With great appreciation!

Randy

[comment]

See if this helps:

http://fmforums.com/forum/showpost.php?post/289685/

[David Jondreau]

How about:

Let([

open = Position(field; "<";1;1);

close = Position(field;">";1;1);

start = open+1;

end = close - open -1;

address = Middle(field; start; end)

];

address

)

PS Which upon further review of the thread is pretty much what comment referred to, though perhaps a little more explicit and "copy and pasteable".

Edited August 25, 2009 by Guest