Question: how to convert excel file to text file with pipe delimiter in java?
Answer: Open it directly with Excel and setting the delimiter as | (pipe)
Rewrite it as a valid CSV (Comma-Separated Values) file (ie, replace the pipes by commas)
Write the content of the file into a proper Excel file.