Open CSV File with Different Delimiter

I'm currently using the default Numbers application to open my CSVs. My current use case involves a file that I had to use a different type of separator ( | ). Is there any way to change the separator? Right now when I open the file it just puts the entire row in one column.