stripping dashes from a series of numbers in a field

[Tony Martin]

Hello - I have a text field with a number-dash combination in it. It looks like this:

123-45-678-901

I need the numbers in a seperate field looking like this:

12345678901

I created a calculation (text) field to do this, but I have NO idea what function to utilize to remove the "-" from between the numbers. And the format (NNN-NN-NNN-NNN) never changes.

Any suggestions?

Thanks,

Tony

[dreamingmind]

Use the Substitute() function

Regards, Don

[Tony Martin]

Actually, I discovered the FILTER function :

Filter(FieldName;"0123456789")

Seemed to work well. Thank you!