I want to convert the pipe Delimited text into the csv. I have tried the Text to Columns for PIPE delimited but it works for only 100,000 records. But I have the file with 2,000,000 records. Please suggest me the best way to convert my file.

Thanks