Data Management
RegEX Variable
Use regular expressions to manipulate variables
The RegEX Variable block enables you to use regular expressions to extract or modify text data in your variables.
Inputs
☐ Variable Name (Required)
The name of the variable to process with RegEx.
Good Examples:
- “emailText”
- “phoneData”
- “rawContent”
☐ Method (Required)
Choose how to apply the RegEx:
RegEx Operations
Description: Select the operation to perform.
Options:
☐ Match value (extract matching text)
☐ Replace value (substitute matching text)
Flags Available:
☐ g (global match)
☐ i (case insensitive)
☐ m (multiline)
☐ RegEx Pattern (Required)
The regular expression pattern to use.
Email Pattern
Phone Pattern (US Format)
URL Pattern
Add flags after the pattern:
/pattern/g
for global matching/pattern/i
for case-insensitive/pattern/m
for multiline
Usage Examples
1. Email Extraction
Variable
emailText
MethodMatch
Extract email addresses from text
2. Phone Cleanup
Variable
phoneNum
MethodReplace
Remove non-numeric characters from phone numbers
3. URL Finding
Variable
pageContent
MethodMatch
Extract URLs from webpage content
4. Text Censoring
Variable
comment
MethodReplace
Replace inappropriate words with ****
Notes
- Test patterns before using
- Use appropriate flags as needed
- Consider performance with large datasets
- Backup variables before replacement operations