Avatar of sam2929
sam2929
 asked on

insert flat files in to tables based upon first character

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.
Unix OS

Avatar of undefined
Last Comment
schwertner

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
schwertner

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck