How to extract a phone number from text with a regular expression

How to do it in Eofferix

1. Open the settings of the field or column that should receive the phone number.
2. Add a Regular expression rule; use the star button to choose a phone preset if needed.
3. Select Keep only matching text to remove surrounding text.
4. If the CRM accepts digits only, remove +, spaces, brackets and hyphens with the next rules.

A supplier can send a phone number as part of a longer value, for example Phone: +1 (415) 555-0198 ext. 24. In value settings, you can find the number with a regular expression, keep the matched fragment, and then normalize it.

The rule is available in value transformations for XML, JSON, and table sources. You can type the regular expression manually or choose a preset with the star button next to the pattern field.

Choose a regular expression from presets

For phone extraction, use the regular expression condition and the remove all except action. This action keeps the full matched fragment and removes the text around it.

1. Open the value settings for the phone field.
2. Add a rule and select the regular expression condition.
3. Click the star button and choose a phone preset.
4. Select remove all except as the action and save the rule.

Option 1: keep the matched phone number

Use this when you need to remove text around the phone number but keep the number formatting from the source.

Option 2: normalize the number

If you need one leading plus sign, use a three-rule sequence: first keep the matched phone number, then remove every non-digit character with the regular expression \D+, and then add + at the beginning when the current value is not empty.