About
Pricing
Community
Teams
Start Free Trial
Log in
sam2929
asked on
3/13/2017
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|201
4-04-14T13
:01:17Z|ET
3|USD|2.00
|4/4/5/7|2
.00|
T|B|P04|WN4|0018025314|201
4-04-14T13
:01:17Z|ET
3|USD|2.00
|4/6/2/7|2
.00|
T|B|P04|WN4|0018025472|201
4-04-14T13
:01:17Z|ET
3|USD|2.00
|4/6/8/7|2
.00|
T|B|P04|WN4|0018025590|201
4-04-14T13
:01:17Z|ET
3|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
1
1
Last Comment
schwertner
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
schwertner
3/14/2017
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