Remove all hyphens within a field

[Jeff M]

I need a calculation that will display the contents of 1 field in another without the hyphens. For example...

MMM-45963-000-01

Should be displayed as

MMM4596300001

I'm using everything I can think of, such as Left and LeftWords functions, Mid functions, Position, etc., but I can't get it to remove them all.

I can't predict how many there are, but the most I've seen is 3.

If this would be better served using a looping script, I'm okay with that too.

[efen]

Use the Substitute function

[Drew Sanderson]

Put this in the data viewer to see how it works.

Let

(

[

text = "MMM-45963-000-01"

];

Substitute ( text ; "-" ; "" )

)

[Lee Smith]

You could use the Filter function.

Your example only shows CAPs, so this would work

Filter ( YourField ; "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ" )

Since you are using Advance, you could also do this using a Custom Function and zap the unwanted characters out instead (the opposite of the Filter Function where you tell FileMaker which characters to keep).

Check out Ray Cologon's Custom Function ZapChars found here

HTH

Lee

Edited August 13, 2010 by Guest