Netsuite saved search extract the words before Pipe symbol

Question

I need to extract the words before pipe symbol(|) from a memo field value in Netsuite and and the Id after Pipe from the value in memo field in netsuite

for example : memo field has Andreas Riepen | ipi_1NjTgoRW1iGQmhiTKDKi5vI3 | | Scandinavian Airlines | Purchase

I need to extract Andreas Riepen and ipi_1NjTgoRW1iGQmhiTKDKi5vI3 from the memo fields into two separate results

Thanks for your assistance