@Altevir-Gomes said in wrong sintax:
i need help with my sintax, i have already tried this : (?-is).+(?<=|\x20)(.+)(?=\x20-\x20EMAIL:).+
but not work
Try this:
Search: (?-i)^Aprovada *\| *([^ |]*) *\| *([^ |]*) *\| *Verificação:.*
Replace: \1\|\2
Reading from left to right the search part does:
(?-i) - Make this a case sensitive search so that Aprovada will not match aprovada or other variations in the letter case for both Aprovada and Verificação. ^Aprovada - Starting at the beginning of a line expect the word Aprovada. *\| * - Match zero or more spaces followed by a | followed by zero or more spaces. ([^ |]*) - This is the first capture group and will be the e-mail address. It scans/skips over everything that is not a space or |. I used * to allow the e-mail field to be empty. *\| * - Match zero or more spaces followed by a | followed by zero or more spaces. ([^ |]*) - This is the second capture group and is the name field. It too can be empty. *\| * - Match zero or more spaces followed by a | followed by zero or more spaces. Verificação: - Expect the word Verificação followed by a colon : .* match and thus delete everything else on the line.