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:
Use the double translate:
The result:
