I need someone to write a script that converts a text file into rows of excel. I need you to take each line of text and take the words separated by the "|" in the line and put them into different columns. Here is an example of one of the lines.
0HONG KWANHI|801 N 2ND ST K82|BLYTHEVILLE |AR|72315-2021|ENTERGY ARKANSAS INC|Utility Deposits|10/28/2005|$50.85|10670116
If you are interested in this job, send me a sample of 100 rows so that I can see that you've done it correctly, and also that you're not doing it by hand.