Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to ignore a substring enclosed inside brackets from a string only using regex ?

Inputs:  abc@(pqr)xyz.com

Output: abc@xyz.com

The regex used to check "abc@xyz.com"  these type of strings:

"(.*@.*\\..*)"

Requirement: The regex must ignore the "(pqr)" part as a valid match.

Note:We are using tExtractRegexFields component for the same

 

 

Labels (2)
1 Reply
fdenis
Master
Master

"(.*@)(\\([^)]*\\))?(.*\\..*)" replace by $1+$3