Removing character from Text field

Try this.  I was testing with a data entry field called [Dash text]

Part([Dash text], 1,"-") & Part([Dash text], 2,"-")

You do man! Thank you Mark

Shorter:

Left([Field A], "-") & Right([Field A], "-")

But what if there is no dash present?  Then the text would get doubled up.

The poster did not mention that he did not want doubled up text in the odd ball case there was no dash. I consider the case of doubled up text a valuable bonus behavior.

:). I was btw very impressed with you other post here for an MPAN check digit. https://quickbase-community.intuit.com/questions/1287465-a-challenge-for-the-community-mpan-algorithm-can-you-translate-one-of-these-into-the-relevant-formula-for-quickbase

That was trivial.

You should have been impressed with this post:

https://quickbase-community.intuit.com/questions/1282756

I have additional versions of this where I generalize the solution so that *any* summary of child records can be displayed in a field of the parent report. I am working on making the new solution dead simple to reuse.

Yes, that question always comes up on the forum.  A generalized solution would be helpful to the Community.

FWIW, I am not through with my refactoring yet but I posted a more recent version that is more compact and where all the parameters are floated to the top of the script:

https://quickbase-community.intuit.com/questions/1282756

Also there is now a template to summarize the child field to the parent.

Another way to avoid doubling up of text:

If(not Contains([field],"-"), [field],
Left([field],"-")& Right([field],"-"))