Loading flat file data in tables

How can i do below have a flat file like below:

 

T|B|P04|WN4|0018025196|2014-04-14T13:01:17Z|ET3|USD|2.00|4/4/5/7|2.00|

T|B|P04|WN4|0018025314|2014-04-14T13:01:17Z|ET3|USD|2.00|4/6/2/7|2.00|

T|B|P04|WN4|0018025472|2014-04-14T13:01:17Z|ET3|USD|2.00|4/6/8/7|2.00|

T|B|P04|WN4|0018025590|2014-04-14T13:01:17Z|ET3|USD|2.00|4/7/3/7|2.00|

$|N|

S|N|

P|WIN|2014-04-14T21:01:17Z|

P|PLC|2014-04-14T21:01:17Z|

P|SHW|2014-04-14T21:01:17Z|

P|EX |2014-04-14T21:01:17Z

 

Want to handle a file where each row can be a different record format,

which is determined by the first Character in the row.

Then each row processed into 1 of 7 separate tables?

 

Example:

 

T row will go table A

$ row will go table B

P row go in table C and so on.