How to clean the details with regex?

i want to delete the details on regex

• I have a lot of accounts, and I want to remove all the details [email protected] | example1 | Personal[US] | Verified | | No SMART | No Bank | No Card | Example1 | Example2 | Example3 | Checked on https://www.example.com at 1:43 pm - September 6, 2015 [email protected] | example2 | Personal[US] | Verified | | No SMART | No Bank | No Card | Example1 | Example2 | Example3 | Checked on https://www.example.com at 5:33 pm - September 6, 2015 [email protected] | example3 | Personal[US] | Unverified | | No SMART | No Bank | No Card | Example1 | Example2 | Example3 | Checked on https://www.example.com at 5:35 pm - September 6, 2015 and i want to delete like this [email protected]|example1 [email protected]|example2 [email protected]|example3 question , whats code on regular expression to mass delete?

• Answer:

  You can use the following replacement: Regex: ^([^|]*?)\s*\|\s*([^|]*).* Replacement: \1|\2 See https://regex101.com/r/nT3qP6/1 The regex will match the ^ - start of string ([^|]*?) - 0 or more characters other than | as few as possible (Group 1 - \1) \s*\|\s* - optional whitespace symbols, |, and again optional whitespace symbols ([^|]*) - 0 or more characters other than | (Group 2 - \2) .* - 0 or more symbols other than newline With the back-references to the captured groups, we get our replacement string.