Q: I have this file that my supervisor gave me : sample.txt that contains :

1|BC Hydro|BC|90006390|Minimum 1 Maximum 11|All numeric|Following business day|Utilities|2007-04-04 15:35:00|Y|BC Hydro|Y||1 2|TELUS Communications|National|90031111|Minimum 10 Maximum 10|All Numeric. Must start with 0,1,2,3,4,5,6 or 8. Mod 10(2,1,2,1). To calculate the check digit, add “315” to the registered account number and apply MOD 10 formula. Test accounts: 1250762858, 2286470104, 2323188313|Following business day|Telecommunications|2006-05-24 11:14:00|Y||Y||2 4|Rogers Cablesystems|ON|90007326|12 digits|All Numeric. Must start with 220, 221, 222, 230, 231, 232, 233, 234, 239, 240, 260 or 265.|Following business day|Cable|2006-04-12 08:53:00|Y|Rogers Cablesystems|Y||3

3 lines only if u put it in a txt file.

I need to sort it somehow to let other people understand it. how would i do that ?

i think i need to delete that delimiter | and make tike columns so that we can read the txt clearly.

I noticed that the | in each line is 13.

Any help ?