Regex: Copy a word/string below in a line above

Question

I want to copy a word/string below in a line above. For example I want to copy TWO-2 from the second line into the first line, replacing the word ONE-1

BEBE ONE-1 NERO

text text

OANA TWO-2 BOGDAN

MUST BECOME

BEBE TWO-2 NERO

text text

OANA TWO-2 BOGDAN

In other case, I have something like this:

  html code ... several lines
  text <p> BEBE ONE-1 NERO <div> text...
    
  other  html code ... several lines
    
  text <table> OANA TWO-2 BOGDAN <tr> text
  again html code ... several lines

MUST BECOME:

  html code ... several lines
  text <p> BEBE TWO-2 NERO <div> text...
    
  other  html code ... several lines
    
  text <table> OANA TWO-2 BOGDAN <tr> text
  again html code ... several lines

My regex is very close to a simple solution, but I believe the replacement is not very good:

FIND (.matches newline): (BEBE(.*?)NERO.*?)(OANA(.*?)BOGDAN)

REPLACE BY: \4\1\3\2

Answer 1

• Ctrl+H
• Find what: (?<=BEBE ).+?(?= NERO.+?OANA (\S+) BOGDAN)
• Replace with: $1
• CHECK Match case
• CHECK Wrap around
• CHECK Regular expression
• CHECK . matches newline
• Replace all

Explanation:

(?<=BEBE )          # positive lookbehind, make sure we have "BEBE " before (note the space)
.+?                 # 1 or more any character, not greedy
(?=                 # positive lookahead, make sure we have after:
 NERO               # space, NERO
.+?                 # 1 or more any character, not greedy
OANA                # OANA, space
(\S+)               # group 1, 1 or more non spaces, you can use (.+?)
 BOGDAN             # space, BOGDAN
)

Replacement:

$1                  # content of group 1

Screenshot (before):

Screenshot (after):