Garmaine Staff asked 2 years ago

How can you convert a pipe delimited text file into comma delimited? The pipe text file needs to be converted into comma delimited and stored in an output file.

For example if I had a pipe .txt file like this:

Available tickets|Seat numbers|Ticket Prices|Total Balance|Tax increase|Payment Method|Ticket Fees|Seats        
1234567|5778|Jonas, Jack|1652|5,873.90|Balance|230|3,567.98|Free soda refills       
1876543|2468|Johnson,George|9059|2,187.53|deposit|904|2,457.90|Price for street parking               
130240|3490|Angel, Mike|4237|1,045.50|Balance|560|3,509.87| Ending Balance