Nest text functions?

[skearton]

How do you nest two types of text function?

I have TextFormatRemove (self) + Trim (Self) and I get a 0 in the field so I know this is not correct.

[Ocean West]

Trim ( TextFormatRemove ( Self ))

[LaRetta]

When nesting functions, you put one within the other according to the logical sequence of evaluations. And it helps to keep the 'nests' on separate lines for easier reading and understanding. It also hopes to comment your closing brackets as you go (notice the //).

So you decide what you want to do first - Trim. You create [color:green]Trim ( Self ). Then you want to take THAT calculation and remove formatting so you wrap as

[color:blue]TextFormatRemove (

[color:green]Trim ( Self )

[color:blue]) // end TextFormatRemove

Of course this is simple example and splitting the logic onto separate lines or indents is mostly worthwhile when more complex but, when new, it helps you build your calculations ... start from the inside, where the evaluation will happen first and then begin wrapping, recognizing that each wrap will apply to the ENTIRE calculation within. I hope that helps. :smile2:

[LaRetta]

What ... was I asleep while you responded, Stephen? ROFLMAO!!

[skearton]

Thanks Folks! Works perfect!

[StudioData]

This works in version 9 or higher, but I'm trying to do the same thing for a client who is still using version 8.

This works:

TextFormatRemove (Trim ( field name )

but if I want the field to auto-enter related data, nothing happens.

TextFormatRemove (Trim (related data::field name)

In this example, not only does the formatting not remove, but the related data doesn't enter either.

Any ideas?

[StudioData]

I may have found my own solution, but I'll post it here anyway in case there's anyone else having the same problem, or in case someone else has a better solution. This works in FileMaker 8:

Case(

IsEmpty(field name);

linked data::linked field name;

Trim(Substitute(TextSizeRemove(TextFontRemove(field name));"¶";"")))