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

Houd jij je kennis graag up to date?

Mis niets meer van onze kennisdocumenten, events, blogs en cases: ontvang als eerste het laatste nieuws in je inbox!

Fijn dat we je op de hoogte mogen houden!