Split a string up into rows by delimiter in Notepad++

Use the search string:

\|

With the replacement string:

\|\r\n

You are running the command in REGEX mode, and the | in the search string will be picked up as a REGEX operator, it simply needs to be escaped.

Just use Extended Search Mode instead Normal or Regular expression ones.