Thursday 14 March 2024

How to extract integers only from a given string ?in MuleSoft 122

 How to extract integers only from a given string ?in MuleSoft

Here are two methods to extract integers only from a given string in MuleSoft 4:

Method 1: Using DataWeave:

DataWeave offers a powerful and flexible approach for manipulating strings and extracting specific data. Here's how to achieve this:

%dw 2.0
// Sample string containing characters and numbers
var inputString = "This string has 123 numbers and 456!"

// Filter only digits using the isNumeric function
var extractedNumbers = inputString filter isNumeric


  1. Define the string containing potential numeric characters (inputString).

  2. The filter function iterates through each character in the string.

  3. The isNumeric function checks if the current character is a number (0-9).

  4. Only characters that pass the isNumeric check are included in the extractedNumbers variable, effectively containing the extracted integers.

Method 2: Using MEL (Message Expression Language):

While less versatile than DataWeave, MEL can be used for basic string manipulation. Here's the approach:


#[payload.replaceAll("[^\\d]", "").toCharArray().join('')]


  1. The replaceAll function removes all characters except digits (0-9) from the payload (payload).

  2. The toCharArray function converts the resulting string into an array of characters.

  3. The join function combines the characters back into a single string, resulting in the extracted integers.

Choosing the Right Approach:

  • DataWeave: This is the recommended method due to its readability, maintainability, and ability to handle more complex string manipulation scenarios.

  • MEL: While functional for simple extractions, MEL expressions can become cumbersome for intricate string processing tasks.

Additional Considerations:

  • Ensure the payload is a string type before applying these methods.

  • Error handling can be incorporated within DataWeave or MEL to gracefully handle cases where the payload might not be a string.

Here are some helpful resources for further exploration:

No comments:

Post a Comment

Note: only a member of this blog may post a comment.