Filter text between certain characters?

[deego55]

I have a field that contains variable text between consistent characters: "+" and "dy"

How would i filter the text that falls between these values into a new field?

Thanks for any help!

[PamRotella]

One way would be to use [color:green]substitute (look it up if you haven't used it before) in a calculation -- either making a calculation field or replacing a data field with the calculated value. Just [color:green]substitute "" (a blank value) for the characters you want to disappear.

UPDATE: I'm sorry, you want to extract the text in between these characters -- that would make the calculation more complex. I don't have time to give you a sample, but try looking at the "Position" function to get the location of these start/end characters. Then take those position numbers to use in a forumla with other text functions.

Edited July 9, 2008 by Guest
Misread the original

[comment]

See:

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