troubleshooting Question

insert flat files in to tables based upon first character

Avatar of sam2929
sam2929 asked on
Unix OS
1 Comment1 Solution185 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros