In TIBCO BusinessWorks, there is no function for removing all non-numeric characters from a string. A solution using XPATH 1.0 functions is called the “double translate”. The inner translate replaces all numeric characters with an empty string, the result is a string with all non-numeric characters. The second translate replaces all characters from the inner translate with an empty string, the result is a string with only the numeric characters. An example:

Create a string:

StripAlphanumericCharacters-Input

Use the double translate:

StripAlphanumericCharacters-Mapping

The result:

StripAlphanumericCharacters-Result